ESSENTIALS OF DATABASE MANAGEMENT
HOFFER COMPREHENSIVE REVIEW AND STUDY
GUIDE
◉ What is the importance of databases?
Answer: They improve data management, enhance decision-making,
support modern applications, ensure data security, reduce data
redundancy, develop technical skills, and increase career
opportunities.
◉ What is a Database Management System (DBMS)?
Answer: Software used to store, organize, manage, and retrieve data.
◉ What is the difference between data and information?
Answer: Data refers to raw facts, while information is processed and
organized data that has meaning.
◉ What are the basic characteristics of a database?
Answer: Organized, shared, integrated, accurate, secure, and
persistent.
◉ What are the main functions of a DBMS?
, Answer: Store, retrieve, update, delete, and secure data.
◉ Name an example of a Database Management System.
Answer: MySQL, Microsoft Access, Oracle Database.
◉ What is an Entity Relationship Diagram (ERD)?
Answer: A visual design of the database used before creating it in
MySQL.
◉ What is SQL?
Answer: Structured Query Language, the standard language for
interacting with relational databases.
◉ What does SQL DDL stand for and what does it do?
Answer: Data Definition Language; it defines and modifies database
structures.
◉ What is the purpose of the WHERE clause in SQL?
Answer: To filter rows before grouping.
◉ What is normalization in databases?
Answer: The process of organizing data to reduce redundancy and
improve data integrity.
HOFFER COMPREHENSIVE REVIEW AND STUDY
GUIDE
◉ What is the importance of databases?
Answer: They improve data management, enhance decision-making,
support modern applications, ensure data security, reduce data
redundancy, develop technical skills, and increase career
opportunities.
◉ What is a Database Management System (DBMS)?
Answer: Software used to store, organize, manage, and retrieve data.
◉ What is the difference between data and information?
Answer: Data refers to raw facts, while information is processed and
organized data that has meaning.
◉ What are the basic characteristics of a database?
Answer: Organized, shared, integrated, accurate, secure, and
persistent.
◉ What are the main functions of a DBMS?
, Answer: Store, retrieve, update, delete, and secure data.
◉ Name an example of a Database Management System.
Answer: MySQL, Microsoft Access, Oracle Database.
◉ What is an Entity Relationship Diagram (ERD)?
Answer: A visual design of the database used before creating it in
MySQL.
◉ What is SQL?
Answer: Structured Query Language, the standard language for
interacting with relational databases.
◉ What does SQL DDL stand for and what does it do?
Answer: Data Definition Language; it defines and modifies database
structures.
◉ What is the purpose of the WHERE clause in SQL?
Answer: To filter rows before grouping.
◉ What is normalization in databases?
Answer: The process of organizing data to reduce redundancy and
improve data integrity.
