Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started