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
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t

What do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)

Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

explain concept of decomposition?

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries?  Ans: Relational calculus contain two calculi, the tuple relati