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 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

Answer 1

As, you have not defined of which topic is for ER diagram I have provided you with the hotel management diagram. Hope it will help.

Thankyou.