Lab 1.2 Exercises
1.2.1 Read a Schema Diagram
Describe the nature of the relationship between the ORDER_HEADER table and the ORDER_DETAIL table (Figure 1.23).
Figure 1.23 Order tables.
1.2.2 Identify Data Normalization Rules and Table Relationships
One of the tables in Figure 1.24 is not fully normalized. Which normal form is violated? Draw a new diagram.
How would you change Figure 1.24 to add information about the sales representative that took the order?
Figure 1.24 Not fully normalized table.
How would you change Figure 1.25 if an employee does not need to belong to a department?
Figure 1.25 EMPLOYEE to DEPARTMENT relationship.
Based on Figure 1.25, why do you think the social security number (SSN) column should not be the primary key of the EMPLOYEE table?