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 appointments 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 3NF. 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 dependencies (FDs). By using dependency gliagram 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: RipoerAepoinmeot, (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: DipnerAppoinment(TableNo,AppoinmentDate, AppoinmentTime,CustomerNo,DinnerNo) Table(TableNo. TableLocation)