CREATE TABLE Patient ( PatientID Varchar2(5) Constraint PatPatID_PK primary key PatientLastName Varchar2(20), PatientFirstName Varchar2(20), PatientAddress Varchar2(55), PatientCity
Question:
CREATE TABLE Patient (
PatientID Varchar2(5) Constraint PatPatID_PK primary key
PatientLastName Varchar2(20),
PatientFirstName Varchar2(20),
PatientAddress Varchar2(55),
PatientCity Varchar2(55),
PatientState Varchar2(55),
PatientZip Varchar2(55),
PatientPhone Varchar2(14),
InsurancePolicyNum Varchar2(20),
IsOutpatient Char(1) check (IsOutpatient in (‘Y’,’N’)),
IsResident Char(1) check (IsResident in (‘Y’,’N’)),
PatientsPhysicianID Varchar2(5)
Constraint Pats_Phys_FK references Physician(PhysicianID));
CREATE TABLE Physician (
PhysicianID Varchar2(5) Constraint Phy_PhysID_PK primary key
PhysicianLastName Varchar2(20),
PhysicianFirstName Varchar2(20),
DEA_No Varchar2(20),
Pager_No Varchar2(14),
PhysicianSpecialty Varchar2(20));
CREATE TABLE Visit (
VisitNo Varchar2(5) Constraint VIS_NO_PK primary key,
OutPatientID Varchar2(5)
Constraint VIS_OP_ID_FK references Outpatient(OPatientID),
VisitDate Date,
VisitTime Timestamp,
VisitReason Varchar2(50));
CREATE TABLE Outpatient (
OutPatientID Varchar2(5) Constraint OP_OP_ID_PK primary key
Constraint OP_OP_ID_FK references Patient(PatientID));
CREATE TABLE Nurse (
NurseID Varchar2(5) Constraint NUR_NID_PK primary key
Constraint NUR_NID_FK references Employee(EmpID),
CertDegree Varchar2(5),
StateLicenseNo Varchar2(15),
NurseSpecialty Varchar2(20),
NurseType Char(1) check (NurseType in (‘R’,’L’));
CREATE TABLE RN (
RNID Varchar2(5) Constraint RN_RN_ID_PK primary key
Constraint RN_RN_ID_FK references Nurse(NurseID));
Write a proper SQL join query to retrieve the physician’s first and last name for patients living in Daly City.
Introduction to Java Programming, Comprehensive Version
ISBN: 978-0133761313
10th Edition
Authors: Y. Daniel Liang