Question 6 2 Pts Consider The Following Relational Database Schema Primary Keys Are Underlined Foreign Keys Are In Ita 1 (50.89 KiB) Viewed 19 times
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 >
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!