CSCI 466 Assignment 3
ER Diagram to Third Normal Form (100pts)
Introduction
For this assignment, you will be converting the following ER diagram, which models the operational data for
a department store, to a set of relations that conform to Third Normal Form (3NF). Use the steps from the
slides that we went over in class. Make sure to indicate the primary keys by underlining them. Include a list
of which attributes are foreign keys, with the home relation of each foreign key indicated.
ER Diagram
Store
Store_ID
Address
Manager
City
City_Name
State
HeadQuartersAddr
Item
Item_ID
Description
Size
Color
Customer
Customer_Name
Address
Phone_Number
Order
Order_Num
Date
located in
(1,n)
(1,1)
stored in
(1,n)
(1,n)
Quantity
ordered in
(1,n)
(1,n)
Quantity
placed (1,1)
(1,n)
hold
(1,n)
(1,n)
Quantity
Figure 1: This is the ER diagram. There may be some things that may seem weird. These may be errors
that were missed during the design phase, or they could be intentional. The purpose of this assignment is to
convert it, not to revise it.
What to turn in?
Submit a PDF file through Blackboard containing the relational schema for the database, including the
information required above.
