Week 3 Quiz 3 DB Normalization

What is the process of mapping a high-level data model (like an ERD) into a logical data model (like a relational schema) called?

• Normalization

• Data Modeling

• Relational Mapping

• Data Translation

According to the First Normal Form (1NF), what must be true about the values in each cell of a table?

• They must be non-atomic.

• They must be repeating.

• They must be single and atomic.

• They must be null.

In a relational schema, what is a primary key that is composed of a foreign key from a parent entity and a partial key from a weak entity?

• Simple Key

• Foreign Key

• Primary Key

• Composite Primary Key

What is the database concept that eliminates repeating groups and ensures that each cell contains only one value?

• Third Normal Form (3NF)

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Fourth Normal Form (4NF)

How is a One-to-Many (1:M) relationship from an ERD converted into a relational schema?

• The primary key of the 'many' side is placed as a foreign key in the 'one' side's table.

• A new table is created to link the two entities.

• The primary key of the 'one' side is placed as a foreign key in the 'many' side's table.

• The tables are merged into a single table.

When converting a Many-to-Many (M:N) relationship from an ERD to a relational schema, what is the most common approach?

• Placing the primary key of one entity as a foreign key in the other entity's table.

• Creating a single table for both entities.

• Creating an intermediate table whose primary key is the combination of the primary keys of the participating entities.

• Adding a new attribute to both entities.

Which of the following is a key rule for a table to be in the First Normal Form (1NF)?

• The table must have a primary key.

• The table must have no transitive dependencies.

• The table must have repeating groups of columns.

• The table must have multi-valued attributes.

Scenario: A new EMPLOYEE table is designed with the columns EmployeeID, EmployeeName, and Certifications. The Certifications column holds multiple values (e.g., 'PMP, PRINCE2, ITIL') for each employee. Question: Based on this design, which rule of the First Normal Form (1NF) is being violated?

• Each attribute must have a unique name.

• The table must have a primary key.

• Each column must have an atomic value.

• The table must have foreign keys.

Scenario: You have an ERD with two entities, STUDENT and COURSE, linked by a Many-to-Many relationship ENROLLS. Question: When converting this ERD to a relational schema, what will the final structure likely include?

• Two tables: STUDENT and COURSE.

• Three tables: STUDENT, COURSE, and a new ENROLLMENT table.

• One single table with all student and course data.

• Two tables with a direct link using a foreign key in one of them.

Scenario: An ERD shows a weak entity DEPENDENT that is dependent on the strong entity EMPLOYEE. DEPENDENT has a partial key DependentName, and EMPLOYEE has a primary key EmployeeID. Question: How would the primary key of the DEPENDENT table be constructed in the relational schema?

• It would be a simple primary key, DependentID.

• It would be the EmployeeID from the EMPLOYEE table.

• It would be a composite primary key consisting of EmployeeID and DependentName.

• It would be the DependentName as a primary key.