CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A Mumbai-based fintech firm stores customer records in a table where the PAN, name and city appear along with a column 'phone_numbers' holding values such as '98200xxxxx, 98210xxxxx' in a single cell. The table violates which normal form first?
The table first violates First Normal Form because the phone_numbers column stores multiple values in one cell. 1NF demands atomic values in every attribute. Higher normal forms build on 1NF, so the atomicity breach is the primary defect to fix.
- AFirst Normal Form (1NF)Correct
- BSecond Normal Form (2NF)
- CThird Normal Form (3NF)
- DBoyce-Codd Normal Form only
Explanation
1NF requires every attribute to hold atomic, single values. Storing several phone numbers in one cell breaks atomicity, so 1NF is violated first. Higher normal forms presuppose 1NF, so they cannot be the first violated.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- A bank encrypts the customer table in its database so that data files stolen from the server cannot be read without a key. This control main…
- A company's payment database transfers Rs 5,000 from Account A to Account B. The debit on A succeeds, but the system crashes before the cred…
- A bank's employee, while a transaction updating a customer's balance is still uncommitted, is shown by another session a balance value that …
- Referential integrity in a relational database ensures that:
- In the ETL process used to populate a data warehouse, which activity is performed in the 'Transform' step?
- An e-commerce firm stores personal data of buyers. Its database designer finds that a Buyer table holds buyer name, city and also the city's…