COMP 266 Lecture Notes - Lecture 5: Oracle Forms, Sql, Unique Key
1 Jul 2018
School
Department
Course
Professor
Question: Use Oracle Forms, or write a
program (using PL/SQL...
Bookmark
Use Oracle Forms, or write a program (using PL/SQL and/or Java), to display the following
report for a given patient (the user will only enter the patient number).
Patient Number: _______________
Patient Name: ______________________
Care Centre Name: ___________________
Name of Nurse-in-Charge: ___________________
Treatment IDTreatment NamePhysician ID Date
__________
____________ __________
____________
. . . . . . . . . . . .
Expert Answer
create table patient
(pno number(3) primary key,
pnm varchar2(40) not null
);
insert into patient values(1,'James Baven');
insert into patient values(2,'Kevin Morrison');
create table care_center
(carecenter_no varchar2(3) primary key,
carecenter_name varchar2(30),
carecenter_nurse varchar2(20),
pno number(3) references patient);
insert into care_center values('C01','Apollo Medical','Kelly Johnson',1);
insert into care_center values('C02','World Medical','Lissa Morrison',2);
create table treatment
(treatment_id varchar2(4) primary key,
treatment_name varchar2(20),
physician_id varchar2(3),
pno number(3) references patient,
Date_1 date
);
find more resources at oneclass.com
find more resources at oneclass.com
