Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the table below what would be an appropriate natural key and why? In this tutorial, we will create an entity that helps a
Based on the table below what would be an appropriate natural key and why?
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
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