Answered step by step
Verified Expert Solution
Link Copied!

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)...1. 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 2900 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions

Question

1 . Television News channels importantance of our Life pattern ?

Answered: 1 week ago