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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!