Questioncreate a set of in third normal form 3nf from

Assignment Help Computer Engineering

Reference no: EM13348291

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.

Reference no: EM13348291

Questions Cloud

Question1 write code for selection sort insertion sort and : question1. write code for selection sort insertion sort and bubble sort. make sure that you are able to read input from

Questionproduce an average class with a public data member : questionproduce an average class with a public data member to collect the sum of integer entries and a public data

Questionthere was a sport in air craft on independence day : questionthere was a sport in air craft on independence day. on the air two aircrafts are in the air parallel to

Question1 determine net cash flow from operationsa 74000b : question1. determine net cash flow from operations?a. 74000b. 75000c. 83000d. 850002. evaluate net cash flow from

Questioncreate a set of in third normal form 3nf from : questioncreate a set of in third normal form 3nf from following un-normalised relation. you must use finkelstein

Questionexplain your idea for a database along with your : questionexplain your idea for a database along with your thoughts for a partitioned view.1. how will you use this

Questionthe bailey company has had a defined pension plan : questionthe bailey company has had a defined pension plan for various years. at the end of 2013 baileys actuary

Question1 write code for following-a compare s2 to s1b : question1. write code for following-a. compare s2 to s1b. select the fifth in s2c. converts s1 to a new string

Question 1richard traveled from new orleans to new york for : question 1richard traveled from new orleans to new york for both vacation and business. he spent 4 days conducting

User Account

All Pages