Based on the table below what would be an appropriate natural key and why? In this tutorial,

Based on the table below what would be an appropriate natural key and why?

  

Transcribed Image Text:

In this tutorial, we will create an entity that helps a physiotherapy centre, LiveEasy, to keep track of their appointments. We have the following scenario that has to be captured: Sam Huynh has an appointment with physiotherapist Bruno on Monday 17 April 2023 at 9am for 30 minutes. He is rehabilitating after a broken wrist. Andrea Kostyanska has an appointment with physiotherapist Sylvia on Tuesday 18 April 2023 at 3:30pm for 30 minutes. She has a problem with her lumbar spine. Philip Chen has an appointment with physiotherapist Bruno on Tuesday 18 April 2023 at 10:30pm for 40 minutes. He has a problem with his neck. 1. Create ONE entity for this scenario. Make a table with column headers (attribute names), taking care that all of the attributes are APPOINTMENT-specific. Show the data in the table. (If you are in your tutorial, get feedback from your tutor before you move on to question 2.) Your answer: Name Surname Doctor_Name Day Date Appointment Session Duration Sam Huynh Bruno Monday 17 April 2023 09:00am 30 Andrea Kostyanska Sylvia Tuesday 18 April 2023 03:30pm 30 Philip Chen Bruno Tuesday 18 April 2023 10:30pm 40 In this tutorial, we will create an entity that helps a physiotherapy centre, LiveEasy, to keep track of their appointments. We have the following scenario that has to be captured: Sam Huynh has an appointment with physiotherapist Bruno on Monday 17 April 2023 at 9am for 30 minutes. He is rehabilitating after a broken wrist. Andrea Kostyanska has an appointment with physiotherapist Sylvia on Tuesday 18 April 2023 at 3:30pm for 30 minutes. She has a problem with her lumbar spine. Philip Chen has an appointment with physiotherapist Bruno on Tuesday 18 April 2023 at 10:30pm for 40 minutes. He has a problem with his neck. 1. Create ONE entity for this scenario. Make a table with column headers (attribute names), taking care that all of the attributes are APPOINTMENT-specific. Show the data in the table. (If you are in your tutorial, get feedback from your tutor before you move on to question 2.) Your answer: Name Surname Doctor_Name Day Date Appointment Session Duration Sam Huynh Bruno Monday 17 April 2023 09:00am 30 Andrea Kostyanska Sylvia Tuesday 18 April 2023 03:30pm 30 Philip Chen Bruno Tuesday 18 April 2023 10:30pm 40