Title: Assignment 5 - Normalization
Course: KVCC BUS210 > Section: Assignments

This assignment uses a copy written chart from the textbook.

The point of this assignment is to get used to developing a dependency diagram and beginning the process of normalization. This assignment is taken directly from the text and can be found on page 228.

1.           Given the structure in the table write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.

2.           Draw the dependency diagrams that are in 3NF (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are not multivalued attributes, that the naming conventions are met, and so on)

3.           Draw the relational diagram.

4.           Draw the Crow’s Foot ERD.

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Assignment 5.pdf