Question
Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use
Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was previously submitted or appears on the Web, in a textbook, or otherwise made available via an external source. Contact your instructor if you have any questions regarding this requirement. Deliverables for Part 1: (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 (crow's 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 E-R diagram 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started