The Relational Model Employee ID, FName, LName, Salary, jobTitle, officeNum, emp

Question

The Relational Model Employee ID, FName, LName, Salary, jobTitle, officeNum, empRank, supervisorID) That is one design, other designs for the ISA relationship are possible... Equipment Type (ID, Desc, model, instructions) Equipment (Serialft, TypeID, PurchaseYear, Lastlnspection, roomNum) Room (Num, occupied flag) RoomService (roomNum service Room Access (roomNum EmplD) Patient (SSN, FirstName, LastName, Address, TelNum) Doctor (LD, gender, specialty, LastName, FirstName) Admission (Num, AdmissionDate, LeaveDate, TotalPayment, InsurancePayment, Patient SSN, FutureVisit) Examine (Doctor ID, AdmissionNum, comment) Stayln(AdmissionNum, RoomNum, startDate, endDate)

Explanation / Answer

1) create view CriticalCases as select patient_SSN,FirstName,LastName,(select count(service)>=2 as numberofAdmissionsToICU from RoomService r where service='ICU' AND r.roomNum=(select s.roomNum from StayIn s where s.AdmissionNum = a.Num))) from Admission a, Patient p;

2)create view DoctorsLoad as select ID as DoctorID,gender,Load from Doctor;

insert into DoctorsLoad(Load) values('OverLoaded') where (select count(E.AdmissionNum)>10 from Examine where ID=E.DoctorID);

insert into DoctorsLoad(Load) values('UnderLoaded') where (select count(E.AdmissionNum)<=10 from Examine where ID=E.DoctorID);

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.