CAF-3 · Chapter 6 · Question 3 of 15
A retail company’s 'Order Details' table uses a composite primary key consisting of both OrderID and ProductID. However, the attribute ProductName depends only on the ProductID and not the OrderID. This violates which normal form?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Second Normal Form (2NF)
Explanation
This is a partial dependency. To achieve Second Normal Form (2NF), no non-key attribute should depend on only a part of a composite primary key
More Data Warehouse Schemas & Data Marts MCQs
- Q5When designing a database, an IT team debates whether to fully normalize the data or leave it partially denormalized. What is the primary…
- Q6A nationwide supermarket chain processes tens of thousands of customer checkout transactions every hour. The system must quickly insert…
- Q7The executive board wants to analyze historical sales trends over the past ten years to make strategic business decisions. They query a…
- Q8During the creation of a data warehouse, raw data is pulled from a CRM system, an ERP system, and several flat files. Before this data is…
- Q9In the ETL process, standardizing date formats across different systems (e.g., converting DD/MM/YYYY to MM/DD/YYYY) and calculating new…