Question: Consider this relational schema: 1. Technician(tid, firstName, lastName, startDate, endDate, trainingLevel) 2. Sample(patientID, ID, date, time) patientID refers to healthNum in Patient tID refers to

 Consider this relational schema: 1. Technician(tid, firstName, lastName, startDate, endDate, trainingLevel)

Consider this relational schema: 1. Technician(tid, firstName, lastName, startDate, endDate, trainingLevel) 2. Sample(patientID, ID, date, time) patientID refers to healthNum in Patient tID refers to tiD in Technician 3. TestType(testTypeID, description) 4. Test(tID, PID, ttiD) tID refers to tiD in Technician pID refers to healthNum in Patient . tti refers to testTypeld in TestType 5. Patient(healthNum, firstName, lastName, dateOfBirth, height, weight, address) 6. Medication (DIN, name, manufacturer) 7. MedicationEquivalent(DIN1, DIN2) DIN1 refers to DIN in Medication DIN2 refers to DIN in Medication 8. Employee(ID, firstName, lastName, dateOfBirth, startDate, endDate, salary) 9. Doctor(eld graduated from, specialty) el refers to ID in Employee graduated From refers to the medical school the doctor graduated from 10. Prescription(pID, DIN, doctorld, startDate, quantity) PID refers to healthNum in Patient DIN refers to DIN in Medication doctorID refers to eld in Doctor 11. Admission(pID, doctorID, date, reason) PID refers to healthNum in Patient doctori refers to elDin Doctor Not all patients are admitted to the hospital What is the following RA expression trying to find? Note: Doctor is an Employee (non-covering and disjoint). a specialty, address( o reason="swollen lymph nodes"(Doctor Doctor.elD= Admission.doctorID Admission) ^ Patient) Find the specialties of doctors and address of patients of whom the doctors are being treated for swollen lymph nodes Find the address of doctors and specialties of patients of whom the patients are being treated for lymph nodes Find the specialty of doctors and addresses of patients of whom each doctors have treated all the patients in the database for swollen lymph nodes None of the provided options are correct

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!