1/89
Looks like no tags are added yet.
What is a bit?
The smallest data unit: one binary digit, 0 or 1.
What is a byte?
A group of bits representing a character, number, or symbol; typically 8 bits.
What is a field?
A group of bytes representing one attribute, such as Student Name.
What is a record?
A group of related fields describing one entity, such as one student.
What is a file in the data hierarchy?
A collection of related records, such as all student records.
What is a database?
A collection of related files or data serving multiple applications.
What is an entity in a relational database?
A person, place, thing, or event about which data is stored.
What is an attribute?
A characteristic of an entity, represented by a field or column.
What is a relational database?
A database organizing data into related two-dimensional tables.
What is a row or tuple in a relational table?
One record describing an instance of an entity.
What is a column in a relational table?
A field containing one attribute for the records.
What is a primary key?
A field that uniquely identifies each record in a table.
What is a foreign key?
A field referencing a primary key in another table to link records.
SUPPLIER and PART: how is Supplier Number used?
Primary key in SUPPLIER; foreign key in PART.
What does a DBMS separate?
The logical view of data from its physical storage.
How does a DBMS improve traditional file systems?
Controls redundancy, reduces inconsistency, and centralizes data management.
What is data redundancy?
Unnecessary duplication of the same data in multiple places.
What is data inconsistency?
Conflicting values for the same data across files or records.
What is a Data Definition Language (DDL)?
Defines database structure, tables, and field characteristics.
What is a data dictionary?
A repository of definitions and characteristics of data elements.
What is a Data Manipulation Language (DML)?
Adds, changes, deletes, or retrieves data in a database.
What does SQL stand for?
Structured Query Language.
Which DBMS capability modifies or retrieves records?
Data Manipulation Language (DML).
What is an entity-relationship diagram?
A diagram showing entities and relationships in a data model.
What is a one-to-one relationship?
Each instance has exactly one related instance on the other side.
What is a one-to-many relationship?
One instance can relate to many; each of those relates to at most one.
What is a many-to-many relationship?
Instances on both sides can have multiple related instances.
What are the three sources of network effects?
Exchange, staying power, and complementary benefits.
What is a network effect?
A product becomes more valuable as the number of users grows.
What does staying power mean?
The long-term viability of a product or service.
What are complementary benefits?
Additional products or services that increase a network's value.
What is technological leapfrogging?
Skipping older technologies to adopt newer ones.
What is the data hierarchy?
Bit → byte → field → record → file → database.
What is a DBMS?
Software that manages databases and interfaces with applications.
Primary key vs. foreign key?
Primary uniquely identifies a record; foreign links to another table.
What are the three main DBMS capabilities?
Data definition, data dictionary, and data manipulation.
What are the original three Vs of Big Data?
Volume, variety, and velocity.
What are the additional two Vs of Big Data?
Veracity (trustworthiness) and value (business usefulness).
Descriptive vs. predictive analytics?
Descriptive explains the past; predictive forecasts future outcomes.
What does prescriptive analytics do?
Recommends actions or optimal decisions.
Moore's Law vs. Mass Digital Storage?
Moore: computing power doubles ~18 months; storage: amount stored doubles annually.
What is green computing?
Reducing the environmental impact of computing.
What is autonomic computing?
Systems that manage and maintain themselves with minimal human intervention.
Goal Seek vs. Data Table?
Goal Seek finds an input for a target; Data Table tests input values.
What are Solver's three model components?
Decision variables, objective function, and constraints.
What does a binding constraint mean?
The resource is fully utilized; slack equals zero.
What is a shadow price?
Marginal objective-value change from one more resource unit, within its valid range.
What does an Answer Report show?
Optimal objective, decision variables, and constraint slack.
What does a Sensitivity Report show?
Shadow prices and allowable changes to model parameters.
PMT vs. IPMT vs. PPMT?
Total periodic payment vs. interest portion vs. principal portion.
CUMIPMT vs. CUMPRINC?
Total interest vs. total principal over a range of periods.
Why is the initial investment outside Excel NPV?
It occurs at time zero and is already at present value.
Tableau dimensions vs. measures?
Dimensions categorize data; measures are numerical values.
When is AVG preferable to SUM?
When comparing per-transaction values across groups of different sizes.
What is the Tableau profit-margin formula?
[Profit]/[Sales] — without a leading equals sign.
What does unchecking Aggregate Measures do?
Displays individual marks instead of aggregated values.
What is a Tableau dashboard?
Multiple worksheets or visualizations combined into one view.
Why do firms use customer loyalty cards?
To gather purchase data and improve targeting, service, and retention.
Why do consumers use loyalty cards?
For rewards, discounts, or personalized benefits.
Why might data fail to create lasting advantage?
Competitors may obtain similar data or copy the analysis.
What is data analytics?
Using math and statistics to interpret data for decisions.
What is volume in Big Data?
The large quantity of data generated and stored.
What is variety in Big Data?
Different data formats and sources, such as text, images, and tables.
What is velocity in Big Data?
How quickly data is generated and must be processed.
What is veracity in Big Data?
The trustworthiness, accuracy, and quality of data.
What is value in Big Data?
The useful business benefit obtained from data.
Which analytics category uses dashboards and scorecards?
Descriptive analytics.
Which analytics category forecasts customer responses?
Predictive analytics.
Which analytics category uses optimization and simulation?
Prescriptive analytics.
What are network externalities?
Another name for network effects.
What is Metcalfe's Law?
Network value is proportional to the square of connected users.
What is exchange as a network-effect source?
Value created when network users interact or exchange information.
What are switching costs?
Money, time, learning, or data loss incurred when changing products.
What is a one-sided network?
A network deriving most value from one class of users.
What is a two-sided network?
A platform connecting two distinct participant groups.
What are cross-side network benefits?
More users on one side increase value for the other side.
Example of a two-sided network?
Job seekers and recruiters, or cardholders and merchants.
What must technological leapfrogging overcome?
Incumbent exchange benefits, switching costs, and complements.
Name a strategy for building network effects.
Move early, subsidize adoption, or leverage viral promotion.
What is IT infrastructure?
The technology platform supporting a business's information systems.
Name four IT infrastructure components.
Hardware, software, data management, and networking/telecommunications.
What are technology standards?
Specifications enabling product compatibility and network communication.
Batch processing vs. online processing?
Batch processes stored transactions together; online processes immediately.
What is grid computing?
Combining remote computers' processing power into a virtual supercomputer.
What is virtualization?
Making one physical computing resource function as multiple resources.
What is cloud computing?
Obtaining computing resources over the Internet.
What is SaaS?
Software delivered as a service over the Internet.
What is IaaS?
Computing infrastructure provided as a service over the Internet.
System software vs. application software?
System software controls hardware; application software serves user tasks.
What is open-source software?
Software whose source code is available to inspect and modify.