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
What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

What are uncommitted modifications? The immediate-modification technique permits database modifications to be output to the database whereas the transaction is still in the act

Write short note on Events Events consist of inputs, interrupts, decisions and actions performed by any external device or users. Every event always has a sender and receiver.

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml