ESSENTIALS OF DATABASE MANAGEMENT
HOFFER COMPLETE COURSE REVIEW GUIDE
◉ What is information?
Answer: Data that is accessed by a user for a particular purpose.
◉ What is metadata?
Answer: Data that describes the structure and properties of the data.
◉ What is a database?
Answer: A structured collection of related data stored on a
computer.
◉ What is a DBMS?
Answer: Software used to create, store, retrieve, update, delete, and
maintain databases.
◉ What is a database system?
Answer: A computer-based system that allows users to interact
efficiently with information stored in a database.
◉ What can a DBMS be used for?
, Answer: Creation, storage, retrieval, updating, deletion, and
maintenance of databases.
◉ What are the two purposes of information collected in a database
system?
Answer: Operational (transactional) and analytical purposes.
◉ True or False: Data and information always mean exactly the same
thing.
Answer: False.
◉ True or False: Metadata describes the data.
Answer: True.
◉ What is conceptual database modeling?
Answer: A visualization of database requirements using ER
modeling.
◉ What is another name for conceptual database modeling?
Answer: Database requirements visualization.
◉ Which model is created first?
Answer: Conceptual database model.
HOFFER COMPLETE COURSE REVIEW GUIDE
◉ What is information?
Answer: Data that is accessed by a user for a particular purpose.
◉ What is metadata?
Answer: Data that describes the structure and properties of the data.
◉ What is a database?
Answer: A structured collection of related data stored on a
computer.
◉ What is a DBMS?
Answer: Software used to create, store, retrieve, update, delete, and
maintain databases.
◉ What is a database system?
Answer: A computer-based system that allows users to interact
efficiently with information stored in a database.
◉ What can a DBMS be used for?
, Answer: Creation, storage, retrieval, updating, deletion, and
maintenance of databases.
◉ What are the two purposes of information collected in a database
system?
Answer: Operational (transactional) and analytical purposes.
◉ True or False: Data and information always mean exactly the same
thing.
Answer: False.
◉ True or False: Metadata describes the data.
Answer: True.
◉ What is conceptual database modeling?
Answer: A visualization of database requirements using ER
modeling.
◉ What is another name for conceptual database modeling?
Answer: Database requirements visualization.
◉ Which model is created first?
Answer: Conceptual database model.