Question: TEST/ Tesi Question 1 4 Marks Charges According to the ER model given above, answer the following questions: Note: You need not explain your answer.

TEST/ Tesi Question 1 4 Marks Charges According to the ER model given above, answer the following questions: Note: You need not explain your answer. You can answer these questions with 'yes or 'no REFERRAL (a) Is it possible to record the details of an appointment that does not have any referral? Notes (1 mark) (1 mark) (1 mark) (1 mark) PAYMENT (b) Is every appointment requiring a Test/Procedure? (c) Is it possible to provide more than one qualification for a specialist? is for PATIENT TotalCharges] books (d) Is it possible to store the details of a patient who is not a PensionerNeteran? is with PatientType Question 2 5 Marks Convert the ER model given in Part A into a set of relations that satisfy Third Normal Form (3NF). You do not have to show your workings. You do not have to justify that the relations are in 3NF. You do not have to show any sample data. DISCOUNT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
