Exercise 2 ONLY

1 of 1 mework 10: Entity-Relationship Modeling Submission Deadline: Monday 05/07/2018 11:00 AM. Exercise 1: Create an ER model for the following descriptions of a database hosting companies: a) Each company operates one or more departments, and each department is operated by one company b) A company has a unique companyName, an address, and a telNo (telephone number). A department has a unique deptName, a location, and a telExtention (telephone extension number). c) Each department employs one or more employees, and each employee works for one department. d) An employee has a unique employeeNo, a name, a position, ad a salary e) An employee may or may not support dependents, and each dependent is supported by one employee f) A dependent has a unique depNo, a depName, and a dateOfBirth Exercise2: Create an ER model for the following descriptions: a) Professors, students, and courses have the following unique numbers respectively: professorNo, studentNo, and courseNo b) Each professor can teach from 1 to 6 courses. c) A student can take any number of courses. d) The capacity of each course is 25 students. e) A professor can advise up to 5 students. ) An associate professor can inspect up to 3 assistant professors