Database Modeling

Given attached case, develop and document using ERwin/ERX 4.0 or Visio 2003 (not other programs) a fully normalized relational data model (3NF). The model should include the primary keys, foreign keys, other attributes, data type for each attribute, cardinality indicators, relationship indicators, and verb phrases if required. ## Deliverables 1. Given the case below, develop and document using ERwin/ERX 4.0 or Visio 2003 (not other programs) a fully normalized relational data model (3NF). The model should include the primary keys, foreign keys, other attributes, data type for each attribute, cardinality indicators, relationship indicators, and verb phrases if required. 2. Detail on a separate document any assumptions you made over and above those explicit in the case. However, you cannot override the case requirements. 3. Case should display the attribute icon (ERwin) or the data type (Visio) to show that the data type has been assigned for each attribute. Detailed requirements: 1. Identifying the entities, their relationships and attributes (including primary and foreign keys) correctly 2. Model is in 3NF (all entities) 3. Verbs on relationships where necessary and Cardinality identified for relationships 4. Data type for each attribute assigned and displayed on document of model 5. Assumptions stated if required Look at attached case. ## Platform MS Windows ER Win 4.0 or Visio 2003 only.