Also, assume any triggers that are needed and post that assumption aswell. emplo

Question

Also, assume any triggers that are needed and post that assumption aswell.

employee has patient v employee Employee ID vARCHAR(45) t patient patient ID VARCHAR(45) employee Type INT (10) employee receptionist v Employee ID VARCHAR(45) Employee ID VARCHAR(45) HH Employee Type INT(10) Employee Type INT(10 FName VARCHAR(45) ------H LName VARCHAR(45) Triggers Employee ID VARCHAR(45) Employee Type INT(1) patient record Specialty VARCHAR(45) record ID INT(45) Indexes patient ID VAROHAR(45) date admitted TIMESTAMP date released TIMESTAMP doctor Employee ID vARCHAR(45) Specialty VARCHAR(45) patient patient ID VARCHAR(45) Fname VARCHAR(45) Lname VARGHAR(450 Minit VAROHAR(1) Birthday VAROHAR(10) Sex VARCHAR(10) Address VARGHAR(100) Weight DECIMAL(10,0) Height DECIMAL (10,0) blood type VARCHAR(2) chief complaint VARCHAR(45) diagnosis VARCHAR(45) Indexes Triggers

Explanation / Answer

SELECT * FROM patient WHERE patient_ID IN (SELECT DISTINCT patient_patient_ID FROM employee_has_patient WHERE employee_Employee_ID='specific_employee_id');

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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