Produce a set of relations - normalisation, Database Management System

Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodology as used in the study book and 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 )

Notes:

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

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

3. A customer may have many preferences, for example room type or a specific paper in the morning. There are no preference codes. Preferences are stored per reservation and are not held permanently.

Posted Date: 3/2/2013 2:12:00 AM | Location : United States







Related Discussions:- Produce a set of relations - normalisation, Assignment Help, Ask Question on Produce a set of relations - normalisation, Get Answer, Expert's Help, Produce a set of relations - normalisation Discussions

Write discussion on Produce a set of relations - normalisation
Your posts are moderated
Related Questions
Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su

How can Redundant Associations be done It can be done by asking questions: i)  Is there a specific arrangement of network which would optimize critical aspects of completed

Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an average of 2.5 copies per book). About 10 percent of the

Drawbacks of Data Distribution: The primary drawbacks of distributed database systems are the added complexity needed to ensure proper coordination between the sites. This increas

Example: Consider the following relations: ROLLNO NAME ADDRESS COURSE_ID 100 Ka

Package classes and associations into models  Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships