ISM 521 Task 2

Task 2

Think of a project/business and give brief context on what the business requirements are in terms of Relational Database?

1. Create an Entity relationship diagram for the proposed database

a. With data fields

b. Define Primary and Foreign Key

c. Attached is a sample ERD (for reference purpose only)

2. Create a class diagram for the proposed database.

3. List all the entities

Brief overview on your experience in creating the ER diagram

· What did go right? Why?

· What did go wrong? Why?