National Louis University E R Modeling Worksheet

Your team is hard at work to build a prototype for a demo to the Millennium Health executives.  To get started, you need to design the DBMS that will support the Business Support System. Your team begins this task by reviewing the DFDs that you prepared in milestone 6.

Tasks:

Identify 6-8 entities and provide a list in a two-column table to include the entity name in one column and a brief definition for it in the second column.

Create an initial ERD for the new Business Support System that contains the eight entities.

1. Draw the relationships between entity types needed by the system. Give a meaningful name to each relationship. Specify cardinalities for each relationship.