Answer Happy

Question 6 2 pts Consider the following relational database schema (primary keys are underlined; foreign keys are in italic, referring to the same attribute in a different table): Medical Centres (cid, centre, address) Patients (pid, name, date_of_birth, insurance) Appointments (aid, cid, pid, date, time, vaccination, payment) Finish the following SQL query such that it identifies all appointments by patients having an unknown insurance. SELECT aid, date, time, name FROM Appointments [Select] WHERE [Select] Patients

SELECT aid, date, time, name [Select] FROM Appointments [Select] RIGHT OUTER JOIN WHERE [Select] JOIN NATURAL JOIN LEFT OUTER JOIN Patients Pag

ROM Appointments [ Select] [Select] NOT insurance insurance IS NULL insurance IS NOT NULL insurance = " UNKNOWN insurance Patients WHERE Question 7 Page 4 >