This chapter is from the book
This chapter is from the book
This chapter is from the book
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.
)
Figure
1.23 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?
)
Figure
1.24 )
Figure
1.25 1.2.3 Understand the Database Development context
Figures 1.26 and 1.27 depict the logical and physical model of a fictional movie rental database. What differences do you notice between the following entity relationship diagram and the physical schema diagram?
Figure
1.26 Logical Data Model.
Figure
1.27 Physical Data Model.
)
Figure
1.26 )
Figure
1.27