Exercise 1 We want to create a simple database for FCIT in which to record information about professors, students and classes as follows. For each professor we need to store the FCIT-id, name and office number For each student we need to store the student-id and name For each class we need to store the id (e.g., CSE 3311) and the name - Each class is taught by exactly one professor - Each student must take at least one class - For each class that a student took we need to store the grade Simplifying assumptions: there is only one lecture for each class. There is only one semester in the database TO DO: Draw the entity-relationship model corresponding to this case. Exercise 2 Convert the following E-R diagram into tables and identify the primary keys