Based on that ER diagram, how do I display all patients under any specific employee ID? So I need an SQL query for it with a little comment. Thanks alot!

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