Question 1 of 30
A company is designing a database to manage its inventory of products. Each product can have multiple attributes, including product ID, product name, and a list of suppliers. The initial design of the product table includes the following columns: ProductID, ProductName, and SupplierNames (where SupplierNames contains a comma-separated list of supplier names). Which of the following statements best describes the normalization status of this table in relation to First Normal Form (1NF)?
The table is not in 1NF because it contains a repeating group in the SupplierNames column.
The table is in 1NF as it has a primary key and all attributes are atomic.
The table is in 1NF, but it requires further normalization to eliminate redundancy.
The table is in 1NF because it adheres to the rules of database design.

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free