Question 1: The table shown below lists dentist-patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. StaffNo Dentist Name PatNo PatName Appointment Date & Time SurgeryNo S1011 S1011 S1024 S1024 S1032 S1032 James Bond James Bond Andrew Joe Andrew Joe Kevin King Kevin King P100 P105 P108 P108 P107 P110 Kim Su Jenny Gold Ian Chappell Ian Chappell John Spooner Frank Holey 1/9/05 10.00 1/9/05 12.00 1/9/05 10.00 2/7/05 14.00 2/7/05 16.30 2/7/05 18.00 S10 S15 S10 S10 S15 S13 Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form. State any assumptions you make about the data shown in this table.(20 Points) Question 2: Please provide answers Problems 10 through 16 in Chapter 3 of Coronel book 11e Pages 109. (20 Points) To avoid any confusion with the 10th edition, the first question starts with: 10. For each table in the database, identify the primary key¦ Question 3: Please provide answers to the Review Questions 7-9 in chapter 5 of Coronel book 11e, page 182.(10 Points) To avoid any confusion with the 10th edition, the first question starts with: 7. List all of the attributes of a movie Do you want your assignment written by the best essay experts? Then look no further. Our team of experienced writers are on standby to deliver to you a quality written paper as per your specified instructions. Order Now, and enjoy an amazing discount!!
