CAF-3 · Chapter 6 · Question 2 of 15
A bank's database table stores a customer's 'Phone Number' attribute. However, several customers have submitted two or three phone numbers, which the data entry clerk has entered into a single cell separated by commas. To achieve First Normal Form (1NF), what must be done?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Ensure there are no repeating groups and all attributes are atomic (single-valued).
Explanation
A table is in 1NF only if it has no repeating groups and all attributes are atomic, meaning each cell contains only a single, indivisible value
More Data Warehouse Schemas & Data Marts MCQs
- Q4In an employee database, the EmployeeID is the primary key. The table includes a DepartmentID column and a DepartmentLocation column. The…
- 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…