IT 235 Module Three Activity Guidelines and Rubric

Overview: This activity is meant to support you as you begin the database design process. An ERD is the most common visual used in the database design process; this activity allows you to draw an ERD based on a set of entities and attributes.

Prompt: Using Visio and crows foot notation, design an ERD that uses the entities and attributes noted in the below table. Be sure you correctly notate the entity name, the attribute name, the key fields (primary and foreign), and relationships on your ERD.

Customer	Order	OrderDetail	Product	Employee
CustomerID (PK)	OrderID (PK)	OrderID (PK) (FK)	ProductID(PK)	EmployeeID (PK)
CustomerLastName	OrderDate	OrderDetail (PK)	ProductDesc	EmployeeLastName
CustomerFirstName	CustomerID (FK)	ProductID (FK)	ProductWeight	EmployeeFirstName
CustomerStreet1	EmployeeID (FK)	Qty	ProductPrice
CustomerStreet2
CustomerZip

Guidelines for Submission: Your submission should include a single Visio file with all entities in a single drawing.