LAIL 1. Database Design Assume that you are the database developer for this task, complete the information-level design for the new database for "MIT_short_courses" that satisfies the constraints and user view requirements given below. Create a Crow's Foot Notation Entity Relationship Diagram (ERD) to support the following business operations. MIT is planning to design a data model to hold information relating to their Courses, Students, Coordinators, Instructors and Classes. User requirement/ business rule 1: As a database designer for "MIT_short_courses", you need to ensure that each student can register for one or more short courses. You need to store students' details including students ID, first name, last name, gender, age, and postal code. User requirement/ business rule 2: Each course has one Coordinator assigned to look after general administration of the course. However, each Coordinator may be assigned to one or more courses. System stores Coordinator's code, name and the school he/she attached to. Each course offers zero or more classes. Some courses are research based they do not offer classes. Each Course has an ID (for unique identification), title, credits and prerequisites. User requirement/ business rule 3: Each class has an ID, Section no, Date and Time. Each class is taught by an instructor. Instructors can teach in one or more scheduled classes. However, some Instructors are working with research students therefore no classes allocated to them in the system. Write down any assumptions you have made, if they are not explicitly described here. While completing the information-level design you are required to answer questions given below. a. Identify and list entities described in the given case scenario. b. ER diagram (5 Marks) Add attributes to those entities and select suitable primary keys for each entity. Represent the structure of your database visually by using the entity-relationship (ER) diagram. 1. You are required to mark all cardinality on the relationships. if you make any assumptions (When you mark cardinality) about data that are not explicitly given in the problem, these must be described. (5 Marks) II. You are required to use a software tool to create the ER diagram. You can use draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram. Note: All many to many relationships must be replaced with bridge tables. (20 Marks)