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
File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Define what Immediate database modification technique uses?  Ans: Both undo and redo.

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

please give me introduction to full data in D B M S in a short assignment