Database Management System · Class 12 · CBSE · Science Computer Science
Explain why storing several phone numbers as a single comma-separated value in one attribute violates First Normal Form (1NF). Suggest a suitable rel…
Practice question from Database Management System (Class 12 · CBSE · Science Computer Science), with the correct answer and a step-by-step solution.
hard · Subjective · Q-B67FC5
Explain why storing several phone numbers as a single comma-separated value in one attribute violates First Normal Form (1NF). Suggest a suitable relational design to store multiple phone numbers for each customer.
Solution
1NF requires each field to contain one indivisible value rather than a repeating group or list. Separating phone numbers into a related relation preserves atomicity and supports any number of phone numbers per customer.
More from Database Management System
- Whatever whatever we do do do ???
- Test
- A relation named STUDENT has attributes RollNo, Name, Class and Email. RollNo is unique and never contains a NULL value, while the other at…
- A relation named Employee has the attributes EmpID, EmpName, Department and Salary. Which SQL query displays the names of employees who bel…
Practise more Computer Science
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed