Chapter 6: Essentials of Management
Information Systems
What is a database? - correct answer-a collection of related files containing
records on people, places, or things
What is an entity? - correct answer-a generated category representing a
person, place, or thing
What are attributes? - correct answer-specific characteristics of each entity
What is a primary key? - correct answer-A field (or group of fields) that
uniquely identifies a given entity in a table
What is a foreign key? - correct answer-A field in one table that points to a
primary key field in another table, creating a relationship between the two
tables
What is normalization? - correct answer-Streamlining complex groups of data,
minimizes redundant data elements, minimizes awkward many-to-many
relationships, increases stability and flexibility
What is a data warehouse? - correct answer-A database that stores current
and historical data that may be of interest
What is a data mart? - correct answer-Subset of data warehouses, highly
focused and isolated
What is data mining? - correct answer-Finds hidden patterns and relationships
in large databases and infers rules from them to predict future behavior
What is referential integrity? - correct answer-Ensure relationships between
coupled tables remain consistent
What is a DBMS? - correct answer-Software for creating, storing, organizing,
and accessing data from a warehouse
Information Systems
What is a database? - correct answer-a collection of related files containing
records on people, places, or things
What is an entity? - correct answer-a generated category representing a
person, place, or thing
What are attributes? - correct answer-specific characteristics of each entity
What is a primary key? - correct answer-A field (or group of fields) that
uniquely identifies a given entity in a table
What is a foreign key? - correct answer-A field in one table that points to a
primary key field in another table, creating a relationship between the two
tables
What is normalization? - correct answer-Streamlining complex groups of data,
minimizes redundant data elements, minimizes awkward many-to-many
relationships, increases stability and flexibility
What is a data warehouse? - correct answer-A database that stores current
and historical data that may be of interest
What is a data mart? - correct answer-Subset of data warehouses, highly
focused and isolated
What is data mining? - correct answer-Finds hidden patterns and relationships
in large databases and infers rules from them to predict future behavior
What is referential integrity? - correct answer-Ensure relationships between
coupled tables remain consistent
What is a DBMS? - correct answer-Software for creating, storing, organizing,
and accessing data from a warehouse
