ESSENTIALS OF DATABASE MANAGEMENT
HOFFER ESSENTIAL STUDY QUESTIONS AND
ANSWERS
◉ 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.
◉ Which model is created after the conceptual model?
Answer: Logical database model.
◉ What is the first step in database development?
Answer: Requirements collection, definition, and visualization.
◉ What is logical database modeling?
Answer: Creating a database model that can be implemented by a
DBMS.
◉ What language is commonly used during database
implementation?
Answer: SQL (Structured Query Language).
◉ What is SQL used for?
Answer: Creating, modifying, deleting database structures and
manipulating data.
◉ What are front-end applications?
HOFFER ESSENTIAL STUDY QUESTIONS AND
ANSWERS
◉ 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.
◉ Which model is created after the conceptual model?
Answer: Logical database model.
◉ What is the first step in database development?
Answer: Requirements collection, definition, and visualization.
◉ What is logical database modeling?
Answer: Creating a database model that can be implemented by a
DBMS.
◉ What language is commonly used during database
implementation?
Answer: SQL (Structured Query Language).
◉ What is SQL used for?
Answer: Creating, modifying, deleting database structures and
manipulating data.
◉ What are front-end applications?