create pharmaceutical table
CREATE TABLE PHARMACEUTICAL
(
PharName VARCHAR2(30),
PharTelephone VARCHAR2(25),
Primary key(PharName)
)create doctor table
CREATE TABLE DOCTOR
(
DID VARCHAR(20),
DName VARCHAR(50),
Specialty VARCHAR(70),
YearOfExp NUMBER,
Primary key(DID)create patient table
CREATE TABLE PATIENT
(
PID VARCHAR(20),
PName VARCHAR(50),
PDOB DATE,
PAddress VARCHAR2(70),
PPostalCode VARCHAR(12),
FamilyDoctor VARCHAR(20),
Primary key(PID),
Foreign key(FamilyDoctor) REFERENCES DOCTOR(DID)create drug table
CREATE TABLE DRUG
(
PharName VARCHAR2(30),
Tradename VARCHAR2(30),
Formula VARCHAR2(70),
Primary key(PharName,Tradename),
Foreign key(PharName) references PHARMACEUTICAL(PharName)create prescription table
CREATE TABLE PRESCRIPTION
(
DID VARCHAR2(20),
PID VARCHAR2(20),
PharName VARCHAR2(30),
Tradename VARCHAR2(30),
PrescriptionDT DATE,
Quantity NUMBER,
Primary key(DID,PID,PharName,Tradename,PrescriptionDT),
FOREIGN key(DID) references DOCTOR(DID),
FOREIGN key (PID) REFERENCES PATIENT(PID),
FOREIGN key (PharName,Tradename) REFERENCES DRUG(PharName,Tradename),
Constraint Check_Quantity check(Quantity between 1 and 30)References
[9]J. Wang, Oracle database 11g. New York: McGraw-Hill, 2011.
[10]A. Momen, Oracle Database XE 11gR2 jump start guide. Birmingham, UK: Packt Pub., 2012.
[11]R. Greenwald, R. Stackowiak and J. Stern, Oracle Essentials. Sebastopol: O’Reilly Media, Inc., 2009.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
