Answered step by step
Verified Expert Solution
Question
1 Approved Answer
data base QUESTION 2 PLEASE Question 1 A database for a hospital needs to store data about medical doctors (identified by doctor ID, with doctor
data base QUESTION 2 PLEASE
Question 1 A database for a hospital needs to store data about medical doctors (identified by doctor ID, with doctor name as an attribute), patients (identified by patient ID, with patient name and ZIP code as attributes), and appointments (identified by appointment ID, with time and date as attributes). An appointment is for exactly one patient and at most one (i.e.,0 or 1) doctor. A patient may have multiple appointments. Similarly, a doctor may have multiple appointments. (a) Draw an E/R diagram that captures all the above information. (b) Define tables using SQL that correspond to the ER Diagram in (a). You must define the smallest number of tables while ensuring that these tables are in BCNF (you do not need to prove that the resulting tables are in BCNF). For each table, specify primary and foreign keys. Also, add all relevant integrity constraints. (c) List all the functional dependencies that you can find from the tables in (b). Please omit functional dependencies that are redundant (for example, if a-> b is included, do not add ac -> bc). Consider we have the following (A, E, D) with the following functional dependencies: AE->D and D-E If we decompose into (A.D) and (E, D), is this decomposition always lossless? If so, prove this. Otherwise, explain it using an exampleStep 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