, indicate the entity types and the relationship types between them by identifyi

Question

, indicate the entity types and the relationship types between them by identifying the nouns, verbs and prepositions as appropriate.You do not need to draw an ER diagram. a. A hotel chain has a number of hotels. Each hotel has a number of rooms to rent to customers. b. An airline employs pilots, flight attendents, and mechanics. The airline has a number of aircraft that it owns. The pilots fly the aircraft. The flight attendants serve on the aircraft. The mechanics repair the aircraft. Customers book an aircraft for travel. , indicate the entity types and the relationship types between them by identifying the nouns, verbs and prepositions as appropriate.You do not need to draw an ER diagram. a. A hotel chain has a number of hotels. Each hotel has a number of rooms to rent to customers. b. An airline employs pilots, flight attendents, and mechanics. The airline has a number of aircraft that it owns. The pilots fly the aircraft. The flight attendants serve on the aircraft. The mechanics repair the aircraft. Customers book an aircraft for travel. , indicate the entity types and the relationship types between them by identifying the nouns, verbs and prepositions as appropriate.You do not need to draw an ER diagram. a. A hotel chain has a number of hotels. Each hotel has a number of rooms to rent to customers. b. An airline employs pilots, flight attendents, and mechanics. The airline has a number of aircraft that it owns. The pilots fly the aircraft. The flight attendants serve on the aircraft. The mechanics repair the aircraft. Customers book an aircraft for travel.

Explanation / Answer

1) in the first sentence the entity are

a) hotel chains

b) Hotels

c) Customers

d) rooms

the relation is as follows

a) hotels chains has hotels , so has is relationship

b) hotels has rooms

c) rooms rent to customer , rent to is another relationship

2)

Entity are

a) Arplane

b) pilots

c) flight attendants

d) mechanics

e) aircraft

f) cutomer

the relationship is folows

a) airline employs pilots

b) airline employs flight attendants

c) airline employs mechanics

d) mechanics repairs airplane

e) customer books aircraft

f) airline has number of aircrafts

g) flight attendants serve on aircraft

h) pilots fly aircraft

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.