CIS336 Introduction to Database PK MedicationID INTEGER DeVry University

DeVry University

CIS336 Introduction to Database PK MedicationID INTEGER DeVry University

Medication

PK MedicationID INTEGER

MedicationName VARCHAR(35)

Prescription

PK PrescriptionID INTEGER

FK MedicationID INTEGER
ReturnTime
TIME

provides/ requires

isa typeof/ used to describea

Dosage Cost
QuantityOnHand LastPurchasedDate
FK MethodID ReorderMinimum

VARCHAR(20) DOUBLE INTEGER DATE INTEGER INTEGER

isassignedby/ describesa

BillingAmount TransactionDateTime QuantityDispensed
FK InHomeCareID

FK ClinicLogID

FK PatientID

DOUBLE DATETIME INTEGER INTEGER INTEGER INTEGER

arerecorded by/ keepsrecord of

PK

ClinicLog

ClinicLogID INTEGER

Login TIMESTAMP

HealthcaseWorker

PK HealthercareWorkerID INTEG

LastName VARCHAR(

FirstName VARCHAR(

SSN INTEG

Address VARCHAR(

isassociated with/ has a

Method

PK MethodID INTEGER

MethodDescription VARCHAR(45)

can havea/ isprescribed to a

Pateient

PK PatientNumber INTEGER

FirstName VARCHAR(20)

LastName VARCHAR(20)

Logout

FK HealthcareWorkerID

records/ has a

TIMESTAMP INTEGER

City State Zip
PhoneNumber

FK HealthcareWorkerTypeID

VARCHAR( CHAR INTEG INTEG INTEG

Address

VARCHAR(30)

Clinic

City State Zip
PhoneNumber

VARCHAR(20) CHAR(2) INTEGER INTEG

PK ClinicID

ClinicLocationDesc AMAAccredNum

INTEGER

VARCHAR(30) INTEGER

Preview