Answer Happy

juestion 1) (7 points) Decide if each of the following statements is True or False based on the ER diagram in Figure 1. Write your final answers in the table below. Figure 1 Date A: Time 1 App Sear N Appointment has 2 Visit 550 Qos ID Patient 3 Doctor Write your final answers in this table: Q: 4 55 1 Tel 5 Specialty Active ingredients Make 6 Name cost N 7 11) A doctor can give many prescriptions in the same appointment. 12) Every medication conflicts with at least one other medication. Medication Date 13) Every prescription has at least one medication. 14) A medication must have multiple active and inactive ingredients. 5 inactive ingredients Prescribed in 1) Every combination of 5 medications is prescribed in many prescriptions. A prescription can have any number (zero or more) of medications. 2) 3) In the database, there may be some patients that were not given any medications. 4) In the database, there may be some patients that did not visit any doctors. 5) In the database, there may be some doctors who have not made any prescriptions. 6) We can know which medication was given in which appointment. 7) For the same doctor and patient, no two appointments have the same date. 8) The value for attribute "Total cost" can be known from the has relationship with "Appointment" 9) A doctor can make more than one prescription for the same patient and in the same date. 10) To distinguish between patients, we need both the SSN and the telephone number. 8 N Prescription Presc N 9 M Conflicts with Total cost 10 11 12 13 14