CREATE TABLE Affiliated_With (Physician INT, Department INT, PrimaryAffiliation BOOLEAN)
CREATE TABLE Physician (EmployeeID INT, Name VARCHAR, Position VARCHAR, SSN INT)
CREATE TABLE Appointment (AppointmentID INT, Patient INT, PrepNurse INT, Physician INT, Start DATETIME, End DATETIME, ExaminationRoom TEXT)
CREATE TABLE Medication (Code INT, Name VARCHAR, Brand VARCHAR, Description VARCHAR)
CREATE TABLE On_Call (Nurse INT, BlockFloor INT, BlockCode INT, OnCallStart DATETIME, OnCallEnd DATETIME)
CREATE TABLE Nurse (EmployeeID INT, Name VARCHAR, Position VARCHAR, Registered BOOLEAN, SSN INT)
CREATE TABLE Patient (SSN INT, Name VARCHAR, Address VARCHAR, Phone VARCHAR, InsuranceID INT, PCP INT)
CREATE TABLE Prescribes (Physician INT, Patient INT, Medication INT, Date DATETIME, Appointment INT, Dose VARCHAR)
CREATE TABLE Trained_In (Physician INT, Treatment INT, CertificationDate DATETIME, CertificationExpires DATETIME)
CREATE TABLE Undergoes (Patient INT, Procedures INT, Stay INT, DateUndergoes DATETIME, Physician INT, AssistingNurse INT)
CREATE TABLE Block (BlockFloor INT, BlockCode INT)
CREATE TABLE Department (DepartmentID INT, Name VARCHAR, Head INT)
CREATE TABLE Procedures (Code INT, Name VARCHAR, Cost FLOAT)
CREATE TABLE Room (RoomNumber INT, RoomType VARCHAR, BlockFloor INT, BlockCode INT, Unavailable BOOLEAN)
CREATE TABLE Stay (StayID INT, Patient INT, Room INT, StayStart DATETIME, StayEnd DATETIME)

List the physicians' employee ids together with their primary affiliation departments' ids with a scatter chart.
SELECT Physician, Department FROM Affiliated_With WHERE PrimaryAffiliation = 1
SELECT "Physician", "Department" FROM "Affiliated_With" WHERE "PrimaryAffiliation" = 1