CAF-3 · Chapter 6 · Question 4 of 15
In an employee database, the EmployeeID is the primary key. The table includes a DepartmentID column and a DepartmentLocation column. The DepartmentLocation depends on the DepartmentID, which in turn depends on the EmployeeID. To achieve Third Normal Form (3NF), what must the database administrator eliminate?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Transitive dependencies
Explanation
In 3NF, a table must not have transitive dependencies. Non-key attributes (like DepartmentLocation) must not depend on other non-key attributes (like DepartmentI
More Data Warehouse Schemas & Data Marts MCQs
- 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…
- Q10To save processing time and bandwidth, a company updates its data warehouse every midnight by only bringing in the new transactions that…