QUESTION 1: Entity-Relationship Diagram 1. Suppose you are using a spreadsheet for MBA class schedule. The spreadsheet currently has the following columns: StudentID: Student's identification number StudentName: Student's name StudentAddress: Student's address ClassID: Class identification number Class Day: Day of the week the class meets Class Time: Time the class meets InstructorID: Instructor's identification number InstructorName: Instructor's name Each class meets only once a week and may have several instructors. An instructor can teach more than one class. A student can enroll in more than one class. (1) You are being asked to design a database to store this information. Create an E-R diagram. Neatly label the entities, the relationships and the maximum cardinalities. Simplied ERD (as we discussed in class) is ok. (2) How many tables do you need to create for this database? Hint: Each entity will become a table and each many-to-many relationship becomes a table. (3) Now suppose each class has only ONE instructor, but every instructor can teach several classes. Please create another E-R diagram. How many tables do you need to create for this database