Question: 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.

 1. Technician(tid, firstName, lastName, startDate, endDate, trainingLevel) 2. Sample(patientID, ID, date,

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, ID) tID refers to tiD in Technician pID refers to healthNum in Patient ttiD refers to testTypeld in TestType 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(elDgraduated 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 doctorld refers to eld in Doctor 11. Admission(plD, doctorID, date, reason) pID refers to healthNum in Patient doctorID refers to eld in Doctor Not all patients are admitted to the hospital 5. Patient(healthNum, firstName, lastName, dateOfBirth, height, weight, address) 6. Medication (DIN, name, manufacturer) Which of the following description is this query fulfilling? - means negation/set difference as per lecture slides Medication AAA(DIN) Medication(DIN, name, manufacturer), Medication(DIN', name', manufacturer'), name = name', manufacturer manufacturer' Answer(quantity) - Prescription(_, DIN, ---, quantity), - Medication AAA(DIN) Find the quantities prescribed of medications that have the same name and manufacturer. None of the options fulfill the query's purpose. Find the quantities prescribed of medications that have the same name but different manufacturer Find the quantities prescribed of medications that have not been created with the same name and different manufacturers

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!