Home > Articles > Data > SQL

SQL and Data

  • Print
  • + Share This
This chapter is from the book

Lab 1.2 Exercises

1.2.1 Read a Schema Diagram

  1. Describe the nature of the relationship between the ORDER_HEADER table and the ORDER_DETAIL table (Figure 1.23).

    Figure 1.23Figure 1.23 Order tables.

1.2.2 Identify Data Normalization Rules and Table Relationships

  1. One of the tables in Figure 1.24 is not fully normalized. Which normal form is violated? Draw a new diagram.

  2. How would you change Figure 1.24 to add information about the sales representative that took the order?

    Figure 1.24Figure 1.24 Not fully normalized table.

  3. How would you change Figure 1.25 if an employee does not need to belong to a department?

    Figure 1.25Figure 1.25 EMPLOYEE to DEPARTMENT relationship.

  4. 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?

1.2.3 Understand the Database Development context

  1. 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.26Figure 1.26 Logical Data Model.

    Figure 27Figure 1.27 Physical Data Model.

  • + Share This
  • 🔖 Save To Your Account