Data Modeling and Normalization Mastery Quiz Quiz

1. Identifying Primary Key

   Which of the following best describes a primary key in a relational database?

   1. A special column that must contain unique and non-null values for each row
   2. A column that can have duplicate values and sometimes null values
   3. A temporary identifier used only during data import
   4. A secondary column used for sorting results
   5. A hidden value that links tables automatically

2. Understanding 1NF

   What does it mean for a table to be in First Normal Form (1NF)?

   1. Every field contains only atomic (indivisible) values and each record is unique
   2. The table eliminates all transitive dependencies
   3. Each table contains only foreign keys
   4. There are no repeating groups but duplicate rows are allowed
   5. Every non-key attribute is functionally dependent on part of a composite key

3. Detecting Redundancy

   Given the table below, what kind of redundancy issue exists?nn| OrderID | CustomerName | CustomerAddress | ProductID |n| ------- | ------------ | --------------- | --------- |n| 1001 | Alice Smith | 23 Oak St. | P001 |n| 1002 | Bob Stone | 52 Pine St. | P003 |n| 1003 | Alice Smith | 23 Oak St. | P002 |

   1. Repeating group redundancy
   2. Insertion anomaly
   3. Functional dependency violation
   4. Update anomaly
   5. Spelling redundancy

4. Understanding Foreign Keys

   In data modeling, what is the purpose of a foreign key?

   1. To establish a link between two tables by referencing the primary key of another table
   2. To automatically generate unique values for each row
   3. To store encrypted information in a table
   4. To increase the performance of queries
   5. To define the default sorting order of a table

5. 2NF Definition

   Which statement correctly defines Second Normal Form (2NF)?

   1. A table is in 2NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key
   2. A table is in 2NF if every column is unique
   3. A table is in 2NF if it contains no redundant data
   4. A table is in 2NF if it uses foreign keys
   5. A table is in 2NF if all transitive dependencies are removed

6. Normalization Scenario

   If you store both customer and product data in a single table, which problem are you most likely to encounter?

   1. Data redundancy and update anomalies
   2. Faster queries and better indexing
   3. Improved data security
   4. More efficient memory usage
   5. Fewer logical errors

7. Recognizing Transitive Dependency

   In a table where StudentID determines StudentName, and StudentName determines StudentEmail, what kind of dependency exists between StudentID and StudentEmail?

   1. Transitive dependency
   2. Functional dependency
   3. Partial dependency
   4. Reflexive dependency
   5. Complex dependency

8. ERD Concepts

   What does an Entity-Relationship Diagram (ERD) primarily illustrate?

   1. The entities, relationships, and attributes involved in a database system
   2. The set of all data types used in a database
   3. The sequence of program instructions for query execution
   4. The network topology between multiple databases
   5. The index structures applied to database tables

9. 3NF in Practice

   Which of the following must be true for a table to comply with Third Normal Form (3NF)?

   1. It is in 2NF, and all attributes are non-transitively dependent on the primary key
   2. No attribute can have a null value
   3. There are no foreign keys in the table
   4. Each row must be unique
   5. All non-key attributes are multivalued

10. Correcting Misspellings in Modeling

    Which of the following variable names is misspelled for a normalized data model?

    1. CustmoerID
    2. CustomerID
    3. OrderID
    4. ProductID
    5. PurchaseDate