1. As an experienced database designer, you are charged with the task of building a database for student enrollment in the college. Each department in the college has a course inventory that includes a list of the courses that the department can offer for enrollment. Also, each department has instructors who will be teaching the courses when they are offered. Once an instructor is hired, she he will be assigned to teach in one department. It is important to note that an instructor can teach more than one class i.e. course offering) each semester and there might be instructors in the database who hasn't started teaching yet. Additionally, no classes will be taught by more than one instructor Before the beginning of each semester, each department publishes their schedule for the semester. The schedule includes the course offerings for that semester. Each course offering in the semester contains the course number, the instructor who will be teaching the class, the days and times the class meets, the classroom, and the maximum number of enrollment. The schedule also includes a identifier for each offering called the CRN number. Some courses are offered each semester while others are offered every other semester. There will be courses that exist in the database for a while before they are offered for the first time. When students are admitted to the university, they must declare a major in one of the departments. Once they declare a major, students can enroll in classes (i.e. course offerings) when they are offered. Each student can enrol in more than one class each semester with a maximunm of 5 classes in any given semester. There will be cases where student information is stored in the database for a while before the student is enrolled in her/his first class Use the information provided above to answer the following questions 1- Identify all the entities that will exist in this database. 2 List all the business rules that can be extracted from the information given above. 3- Draw the ERD that captures all the business rules you identified. 2. Write the business rules that are captured in the following ERD COACH HOMEPHONE coaches PLAYER TEAM has plays for K PLAYER CooE FK1 TEAM CODE CITY NAME CITY MANAGER PLAYER FNAME PLAYER INITIAL FK1 CITY CODE