Answer Happy

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 for an unknown vaccination. SELECT A.aid, A.date, A.time, P.name FROM Appointments A [Select] [Select] WHERE [Select] JOIN USING(pid) LEFT OUTER JOIN NATURAL JOIN JOIN Patients P

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 for an unknown vaccination. SELECT A.aid, A.date, A.time, P.name FROM Appointments A [Select] [Select] [Select] NOT vaccination vaccination IS NOT NULL vaccination = None vaccination IS NULL vaccination IS UNKNOWN Patients P WHERE