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.

Answer rating: 100% (QA)

On the given question it says to CREATE TABLE Patient CREATE TABLE Physician CREATE TABLE Visit CREATE TABLE Outpatient CREATE TABLE Nurse CREATE TABL... View the full answer