(1)Project Description.

Provide an overview of your project identifying the major components as part of a database design. The format is an executive summary to be presented to management for review.

(2)Entity-Relationship Diagram.

Use the entity-relationship diagram (crows foot) notation to design your database system. Be sure to:

(1) identify entity types; (2) describe relationships between or among entity types; (3) identify modality and cardinality for each relationship; (4) identify associative entities and intersection data; and (5) label primary and foreign key attributes.

Your entity-relationship diagram will have a minimum of six (6) entity types of which at least two (2) are associative entities with intersection data. The ERD is accompanied by a brief explanation of each component in the entity-relationship model.

Note: You can use Microsoft Visio, Word, PowerPoint, or Access as a diagramming tool. Please obtain approval from your instructor regarding the use of other diagramming tools.

EDIT: There is no speciifc topic. The ERD can essentially be based on any project or process as long as it meets the criteria listed above. This is part one of a three part project in which there will be SQL queries created. And this is the actual project statement.