Question: ( 2 ) Consider the conceptual schema about a hotel chain given below and the list of extensions about customers to the database domain. Modify
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
