Page 1 of 1
Consider the following relational database schema (primary keys are underlined, foreign keys are in italic, referring to
Posted: Mon Jun 06, 2022 5:54 pm
by answerhappygod
- Consider The Following Relational Database Schema Primary Keys Are Underlined Foreign Keys Are In Italic Referring To 1 (75.51 KiB) Viewed 26 times
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) Write an SQL query that lists the names of patients (unique and in alphabetical order) who made a vaccination appointment at the 'Haymarket Medical Centre' on the 1 June 2022.