Data Modeling Environment Name: Brief description of proposed environment: Data Retrieval Requirements example - These will translate into appropriate SELECT queries used in VIEWs 1) Input: Patient Num: Output: Patient Name, address Phone, email, Doctor, hospital ward (department) 2) Input: Primary Physician ID: Output: Doctor Name, phone, Email, Specialty, Department 3) Input: Department Num: Output: Department name, On Call Doctor, Admitted Patients I need an ER diagram of proposed environment with complete list of tables, their attributes and datatype, PK(s) and FK(s). The following is a sample ERD