Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw a simple ERD diagram for each of the following scenarios. Include proper cardinality and all keys.Besides PK and any FK required, include at least
Draw a simple ERD diagram for each of the following scenarios. Include proper cardinality and all keys.Besides PK and any FK required, include at least one other attribute. Instead of providing drawn tables, you will have to draw in the tables yourself. I've given you the tables, but this does not include any associative entities, should they be required and they will be You may hand draw below or even use Astah but use it correctly IG Hotels manages several hotel chains; the best known is Holiday Inn. They manage other chajns as well, such as Candlewood Suites, Staybridge Suites and Crowne Plaza. Each chain manages many hotels for example, Holiday Inn Express has over hotels worldwide; a hotel belongs to one chain. Each hotel has nany employees; an employee may work for zero to many hotels. This includes at a minimum these entities:
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