How to create a set in third normalreservationreservation, Ask an Expert

Engineering

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.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M9132656

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

You own a specialty company self made company smc which

You own a specialty company; self made company (SMC) which sells hats and jackets. You obtained an object IDENTIFIER 5000 under enterprises node from IANA. You have two branch locations. Each has an inventory system that ...

Suppose two nodes a and b are attached to opposite ends of

Suppose two nodes, A and B, are attached to opposite ends of an 800 m cable, and that they each have one frame of 1, 500 bits (including all headers and preambles) to send to each other. Both nodes attempt to transmit at ...

System analysis project 4 can you answer the 4 questions at

System Analysis project 4: can you answer the 4 questions at the task section, thank you. Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company ...

Question suppose we want to build a b tree that has space

Question : Suppose we want to build a B+ tree that has space for 200,000 data entries in its leaf pages. Each data entry is made up of a key and its corresponding data value. Let us assume the following specifications. E ...

Case study 1 requirement analysis and gathering for the

Case Study 1: Requirement Analysis and Gathering for the State Firefighters Association Read the mini case on The State Firefighters Association located in Chapter 3 of the textbook and complete the assignment. Write a t ...

Question suppose that someone tells you that an attribute

Question : Suppose that someone tells you that an attribute that is part of a composite primary key is also a candidate key. How would you respond to that statement? Explain.

When i have a class that extends application public class

When I have a class that extends Application (public class Game extends Application) I can easily call it from my driver class by typing launch(Game.class). Now I have two other classes where one extends JFrame and the o ...

You are required to carry out an analysis of the it

You are required to carry out an analysis of the IT requirements of a software company and design a virtualisation solution to satisfy these requirements. You will need to produce a report outlining your design and provi ...

Question suppose that you have called a function called

Question : Suppose that you have called a function called sphere that creates (stores points and normals in a vertex Array and in the buffer) a sphere of radius 1 centered at the origin. Write the portions of the render ...

Suppose that 75 of all trucks undergoing a brake inspection

Suppose that 75% of all trucks undergoing a brake inspection at a certain inspection facility pass the inspection. Consider groups of 15 trucks and let X be the number of trucks in a group that have passed the inspection ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert