CS – ITEC 2116 D426 Data Management
Foundations
Complete Final Assessment (Qns & Ans)
2025
Question 1 (Multiple Choice)
Case:
A company maintains a relational database with tables for
Customers , Orders , and Order_Details . The schema has
been redesigned to minimize redundancy and anomalies.
Question:
Which normal form specifically eliminates transitive
dependencies among non-key attributes?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
©2025
,C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Correct ANS: C. Third Normal Form (3NF)
Rationale:
Third Normal Form (3NF) mandates that all non-key attributes
depend solely on the primary key. This requirement eliminates
transitive dependencies (i.e., when a non-key attribute depends on
another non-key attribute), thereby reducing redundancy and
enhancing data integrity.
---
Question 2 (Fill-in-the-Blank)
Case:
A database designer is creating a table to store customer records.
To comply with proper relational database design, the table must
store only atomic values and not contain any multi-valued
attributes.
Statement:
©2025
,A table that meets the requirements of the First Normal Form
contains only atomic values and no ______ groups.
Correct ANS: repeating
Rationale:
First Normal Form (1NF) requires that each field in a table
contains only a single, indivisible (atomic) value and prohibits
repeating groups or arrays of values in a single column.
---
Question 3 (True/False)
Case:
A banking application processes transactions that must be
executed in full or not at all.
Statement:
ACID properties guarantee that database transactions are Atomic,
Consistent, Isolated, and Durable.
Correct ANS: True
©2025
, Rationale:
The ACID properties are a set of guarantees provided by
transaction processing systems. They ensure that transactions are
processed reliably by enforcing atomicity (all-or-nothing
execution), consistency (valid data state), isolation (independent
execution), and durability (permanence of committed
transactions).
---
Question 4 (Multiple Response)
Case:
A data engineer is designing a query optimizer for a relational
database to enhance performance by reducing disk I/O and
execution time.
Question:
Which of the following techniques are commonly employed in
query optimization? (Select all that apply.)
A. Indexing on frequently queried columns
B. Utilizing materialized views
C. Query rewriting and plan caching
©2025
Foundations
Complete Final Assessment (Qns & Ans)
2025
Question 1 (Multiple Choice)
Case:
A company maintains a relational database with tables for
Customers , Orders , and Order_Details . The schema has
been redesigned to minimize redundancy and anomalies.
Question:
Which normal form specifically eliminates transitive
dependencies among non-key attributes?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
©2025
,C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Correct ANS: C. Third Normal Form (3NF)
Rationale:
Third Normal Form (3NF) mandates that all non-key attributes
depend solely on the primary key. This requirement eliminates
transitive dependencies (i.e., when a non-key attribute depends on
another non-key attribute), thereby reducing redundancy and
enhancing data integrity.
---
Question 2 (Fill-in-the-Blank)
Case:
A database designer is creating a table to store customer records.
To comply with proper relational database design, the table must
store only atomic values and not contain any multi-valued
attributes.
Statement:
©2025
,A table that meets the requirements of the First Normal Form
contains only atomic values and no ______ groups.
Correct ANS: repeating
Rationale:
First Normal Form (1NF) requires that each field in a table
contains only a single, indivisible (atomic) value and prohibits
repeating groups or arrays of values in a single column.
---
Question 3 (True/False)
Case:
A banking application processes transactions that must be
executed in full or not at all.
Statement:
ACID properties guarantee that database transactions are Atomic,
Consistent, Isolated, and Durable.
Correct ANS: True
©2025
, Rationale:
The ACID properties are a set of guarantees provided by
transaction processing systems. They ensure that transactions are
processed reliably by enforcing atomicity (all-or-nothing
execution), consistency (valid data state), isolation (independent
execution), and durability (permanence of committed
transactions).
---
Question 4 (Multiple Response)
Case:
A data engineer is designing a query optimizer for a relational
database to enhance performance by reducing disk I/O and
execution time.
Question:
Which of the following techniques are commonly employed in
query optimization? (Select all that apply.)
A. Indexing on frequently queried columns
B. Utilizing materialized views
C. Query rewriting and plan caching
©2025
