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:49 pm
by answerhappygod
- Consider The Following Relational Database Schema Primary Keys Are Underlined Foreign Keys Are In Italic Referring To 1 (33.83 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): MedicalCentres (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. Edit View Insert Format Tools Table 12pt ✓ Paragraph VT² V O Ev To √x B I U AV €0 lli 8 E