Question 1: Millennium Institute of Information Technology (MIIT) needs a database. MIIT is an Information Technology (IT) institute with hundreds of students. It is necessary to keep track of all the different classes that are being offered, who is assigned to teach each class, who is qualified to teach each course, and which students take each class. Also, it is important to track the progress of each student as they advance.(i)Students are given a student number when they join the school. This is stored along with their name, date of birth, address, contact number, and the date they joined the school. (ii)There are three levels of courses: beginner-level, intermediate-level, and advanced-level. Each course has a code and a title. Each time a particular course is offered, it is called a class of the course. MITT offers several classes of each course. (iii)Each class is offered during a given semester. Semester defines the year and the term that the class will be offered (e.g., Spring 2021). (iv)MITT maintains records about all instructors including their name, address, contact number, email address, and rank. An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors may not be assigned to any class. MITT also keeps track of courses that a particular instructor is qualified to teach. (v) Students can take multiple classes at the same level in a given semester. Once a student has completed all the required courses for a given level she/he receives a certificate. Each course belongs to one and only one level. Each level has at least three courses. A list of required courses for each level are stored. MITT needs to keep track of all certificates issued to each student and issue dates.

1.What are all the entities in this company?

2. List each attributes for each entity

3.Describe the possible relationships between the various entities.

4.Create a Crows Foot notation E-R diagram for this case. For each entity, include the attributes, the primary key, and foreign keys (if any). Name each relationship and diagram both the minimum and maximum cardinalities. If you cannot infer the cardinalities from the case description, make your own assumption. You can use MySQL Workbench, Visio or any other drawing software to draw your ERD.