Based on the table below what would be an appropriate natural key and why? In this tutorial,
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
Which of the environmental policy options discussed in this and previous chapters would you recommend if a hypothetical society were facing the following environmental problems? In each case, briefly...
-
Air is compressed isothermally from 20 psia and 100°F to 1200 psia, as shown in Fig. 7.8. Calculate the enthalpy change, the entropy change, and the work required if the heat loss is 80 Btu/lbm....
-
For the following exercises, find the distinct number of arrangements. Hector wants to place billboard advertisements throughout the county for his new business. How many ways can Hector choose 15...
-
On October 1, 2017, Gordon borrows \($150\),000 cash from a bank by signing a three-year installment note bearing 10% interest. The note requires equal payments of \($60\),316 each year on September...
-
Day Ko Incorporated presented the following comparative income statements for 2009 and 2008: Other relevant financial information follows: Required a. How did 2009 net sales compare with 2008? b. How...
-
A swimmer wants to cross a river, from point A to point B, as shown in the figure. The distance di (from A to C) is 200 m, the distance d (from C to B) is 150 m, and the speed vr of the current in...
-
Consider the conical pivot bearing below. Calculate external torque magnitude, T, required for the pivot bearing to rotate at the constant angular speed shown. 0.0008in. 4200rpm 30 0.2 in. -0.010...
-
Shares of stock of Sweet & Sour Co., a domestic corporation, held as investment by Benjo bought at P1,000,0000 cost in mid 2022, are listed and traded in the local stock exchange. A year later, Benjo...
-
Accounting A man claims he had no idea the car he bought had entered the island illegally. If this is the case, what provisions have been established to allow the man to keep or receive value for...
-
What are the principal objectives of virtual memory management in modern operating systems, and how do techniques like demand paging and page replacement algorithms such as LRU (Least Recently Used)...
-
Write a program in C++ to write the following pattern in a text file "pattern.txt" and read the same pattern from the file and display it. |-|-|-| -|-|-|-|- |-|-|-|-|-| -1-1-1-1-1-1- -|-|-|-|-|-|-|-...
-
General Bonds Corp. (GBC) has a pension liability of $100M. The duration of this liability is 15 years. On the asset side of its balance-sheet, GBC has a 100% bond portfolio that consists of two...
-
In the last 5 years, the interest rate on purchasing a home has been = 4.3%, = 0.2% following a normal distribution. You purchase a $250,000 home at a rate that is 1.5 standard deviations below the...
-
What key concerns must functional tactics address in marketing? Finance? POM? Personnel?
-
One of the recommendations regarding indexes is to specify a unique index for each primary key. Explain the justification for this recommendation.
-
Give an example (other than those described in this chapter) for each of the following, and justify your answer: a. Derived attribute b. Multivalued attribute c. Atomic attribute d. Composite...
-
Describe the key steps to improve data quality in an organization.
-
Explore whether the original Bell inequality can be violated at large angles as well.
-
Consider an EPR state \(|\phiangle_{A B}\); Alice measures the spin on \(z\), then Bob measures it on \(x\), and then Alice measures it again on \(z\). Classify the possible answers for the second...
-
In quantum cosmology, one can define a "wave function of the Universe" \(\Psi[a(t)]\), whose variable is the expanding scale factor of the Universe, \(a(t)\), and which satisfies a general relativity...
Study smarter with the SolutionInn App