Database Principles Study Guide: (2026/2027 Syllabus)
This guide is organized to follow the typical progression of a database course, from
foundational concepts to advanced implementation and management.
Part 1: The Database Environment and Foundational Concepts
This section covers the basic definitions, the components of a database system, and the
evolution from file systems to modern databases.
1. What is raw, unprocessed facts that have no meaning by themselves?
o ANSWER ✓ Data
2. What is the result of processing raw data to reveal its meaning?
o ANSWER ✓ Information
3. What do you call data about data, which describes the data's characteristics and
relationships?
o ANSWER ✓ Metadata
4. What is the body of information and facts about a specific subject, often implying
awareness and understanding?
o ANSWER ✓ Knowledge
5. What is a shared, integrated computer structure that stores a collection of end-
user data and metadata?
o ANSWER ✓ A database
6. What software serves as the intermediary between the user and the database,
managing data access and storage?
o ANSWER ✓ Database Management System (DBMS)
7. What are the five main components of a database system?
o ANSWER ✓ Hardware, software, people, procedures, and data.
8. What type of database is designed to support a company's day-to-day operations?
o ANSWER ✓ An operational database (also known as an online transaction processing
(OLTP) or production database)
9. What type of database stores data derived from operational databases and
external sources, and is used for business intelligence and decision support?
, o ANSWER ✓ A data warehouse
10. Data that exists in its raw, unprocessed state, such as a text file or an image, is
called what?
o ANSWER ✓ Unstructured data
11. Data that results from formatting unstructured data to enable storage and use is
called what?
o ANSWER ✓ Structured data
12. What is a disadvantage of the traditional file-based system where different
versions of the same data appear in different places?
o ANSWER ✓ Data inconsistency
13. What term describes the condition when it is possible to make changes in the file
structure without affecting the application's ability to access the data?
o ANSWER ✓ Structural independence
14. When data is stored in multiple places unnecessarily, what is this called?
o ANSWER ✓ Data redundancy
15. What are the three main problems that data redundancy can cause?
o ANSWER ✓ Data inconsistency, data anomalies (insert, update, delete), and poor data
integrity.
16. What is a detailed description of an organization's operations and constraints,
which are then translated into data model structures?
o ANSWER ✓ Business rules
17. In a business rule, what does a noun typically translate to in a data model?
o ANSWER ✓ An entity
18. In a business rule, what does a verb typically translate to in a data model?
o ANSWER ✓ A relationship
19. What is a person, place, thing, or event about which data is to be collected and
stored?
o ANSWER ✓ An entity
20. What is a characteristic of an entity?
o ANSWER ✓ An attribute
21. What is the set of possible values for an attribute called?
o ANSWER ✓ A domain
22. What is an attribute that can be further subdivided into smaller meaningful
components called?
o ANSWER ✓ A composite attribute
This guide is organized to follow the typical progression of a database course, from
foundational concepts to advanced implementation and management.
Part 1: The Database Environment and Foundational Concepts
This section covers the basic definitions, the components of a database system, and the
evolution from file systems to modern databases.
1. What is raw, unprocessed facts that have no meaning by themselves?
o ANSWER ✓ Data
2. What is the result of processing raw data to reveal its meaning?
o ANSWER ✓ Information
3. What do you call data about data, which describes the data's characteristics and
relationships?
o ANSWER ✓ Metadata
4. What is the body of information and facts about a specific subject, often implying
awareness and understanding?
o ANSWER ✓ Knowledge
5. What is a shared, integrated computer structure that stores a collection of end-
user data and metadata?
o ANSWER ✓ A database
6. What software serves as the intermediary between the user and the database,
managing data access and storage?
o ANSWER ✓ Database Management System (DBMS)
7. What are the five main components of a database system?
o ANSWER ✓ Hardware, software, people, procedures, and data.
8. What type of database is designed to support a company's day-to-day operations?
o ANSWER ✓ An operational database (also known as an online transaction processing
(OLTP) or production database)
9. What type of database stores data derived from operational databases and
external sources, and is used for business intelligence and decision support?
, o ANSWER ✓ A data warehouse
10. Data that exists in its raw, unprocessed state, such as a text file or an image, is
called what?
o ANSWER ✓ Unstructured data
11. Data that results from formatting unstructured data to enable storage and use is
called what?
o ANSWER ✓ Structured data
12. What is a disadvantage of the traditional file-based system where different
versions of the same data appear in different places?
o ANSWER ✓ Data inconsistency
13. What term describes the condition when it is possible to make changes in the file
structure without affecting the application's ability to access the data?
o ANSWER ✓ Structural independence
14. When data is stored in multiple places unnecessarily, what is this called?
o ANSWER ✓ Data redundancy
15. What are the three main problems that data redundancy can cause?
o ANSWER ✓ Data inconsistency, data anomalies (insert, update, delete), and poor data
integrity.
16. What is a detailed description of an organization's operations and constraints,
which are then translated into data model structures?
o ANSWER ✓ Business rules
17. In a business rule, what does a noun typically translate to in a data model?
o ANSWER ✓ An entity
18. In a business rule, what does a verb typically translate to in a data model?
o ANSWER ✓ A relationship
19. What is a person, place, thing, or event about which data is to be collected and
stored?
o ANSWER ✓ An entity
20. What is a characteristic of an entity?
o ANSWER ✓ An attribute
21. What is the set of possible values for an attribute called?
o ANSWER ✓ A domain
22. What is an attribute that can be further subdivided into smaller meaningful
components called?
o ANSWER ✓ A composite attribute
