(Solved): ER Diagram LAB2 Assignment - Draw Entity Relationship Model for the following scenario using Chen ...

ER Diagram LAB2 Assignment - Draw Entity Relationship Model for the following scenario using Chen's notation. - Use any software to help you draw the ER Model and then save it as a pdf file. - Submit the pdf file before the next lab session. An Course Offering Example (Business Rules) In a university, each department offer courses. Department has instructors who teach courses. For a course, the instructor may or may not have a teaching assistant. - Each department has a unique department name, a unique department code, 1-4 phone numbers, and an address (street, city, state, zip code). - Each course has a unique course number (e.g., INFO605), a section number (e.g., 900), a title, a course type (e.g., online), and units. - Each instructor has an instructor ID, first name, last name, gender, SSN, position, and units taught. An instructor may or may not be supervised by another instructor. - Each instructor can state his/her teaching preferences including number of courses to teach for each course type. - Each teaching assistant has a teaching assistant ID, SSN, a student ID, and salary. - For each course, both the instructor and the teaching assistant will have an evaluation score individually.