Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. The manager of a company dinner club would like to have an information system that assists him to keep track of who makes 3.

image text in transcribed

2. The manager of a company dinner club would like to have an information system that assists him to keep track of who makes 3. please solve this appontments for each dinner. A customer can only reserve one table at a specific time and date for a particular dinner. One each day, a table can be allocated to more than one reservation on that day. The table below lists a sample data. (Note: Please keep CustomerName as one attribute) -State any assumptions you make about the data shown in this table (if any). -List all the functional dependencies of the relation. -Describe and illustrate the process of normalizing the table above to 3 NF. In the 1NF we remove all the repeating groups, assigning new column (Appointment Date and Appoioment. Time) and assigned keys (candidate keyso. Then we figure out the function dependencles (FDs). By using dependency diagram we represent the table as shown below. -State any assumptions you make about the data shown in this table (if any). -List all the functional dependencies of the relation. -Describe and illustrate the process of normalizing the table above to 3NF. Note 1: Price means the price per each product 1NF: BinnerAppoinment,(TableNo, AppoinmentDate, AppoinmentTime, TableLocation, CustomerNo, CustomerName, DinnerNo) In the 2NF, we remove partial dependent attributes from the relation by plecbiog them in a new relation along with a copy of their determinant. Note 2: Please keep Customer/Address as one attribute 3NF: DinoerAppoinment(TableNo,AppoinmentOate, Appoinment Time,CustomerNo,DinnerNo) Table(TableNo. TableLocation)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle RMAN For Absolute Beginners

Authors: Darl Kuhn

1st Edition

1484207637, 9781484207635

More Books