Question: ( 2 ) Consider the conceptual schema about a hotel chain given below and the list of extensions about customers to the database domain. Modify

(2) Consider the conceptual schema about a hotel chain given below and the list of extensions
about customers to the database domain. Modify the conceptual schema to make it consistent
with the required extensions. Note that, only one (the final with all the extensions) conceptual
schema is expected.
We would like to extend the database domain in the following ways.
(a) A description of a customer consists of the first name, last
name, date of birth and optional nationality.
(b) The first name, last name and date of birth together identify a
customer.
(c) Customers book hotels.
(d) A booking is described by booking date, room type, expected
arrival date, the total number of days a booking is valid for and
the rate.
(e) A customer can only book a hotel once a day.
*Use qualifications and link attribute pls

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!