Question

Create a set of in third normal form (3NF) from following un-normalised relation. You must use Finkelstein methodology as used in tutorials.

RESERVATION(reservation id, date of reservation, start date, end date, (( customer id, customer name, customer address, customer type, customer type description, ((customer preferences)), customer credit card number )), payment method, hotel id, hotel name, hotel address )

1. A reservation is for one hotel only but can be for one or many customers.

2. There are three customer types- corporate, private and concession.

3. A customer could have many preferences, as in room type or a specific paper in morning. There are no preference codes. Preferences are stored per condition and are not held permanently.