For your convenience, here is a summary of how the Academic Database (School Management System) works:A School/University has many Departments which offer courses to students in a given academic session. Each of these courses is taught by a faculty. Students enroll for different courses in an academic session. Besides the registration details, the parent information of the student also needs to be maintained by the University/School. The Department maintains the student’s attendance details which would decide the eligibility of the student to take up the exams for that academic session. For each academic session, exams are conducted and the results are shared with the student within a stipulated period of time. The Department also maintains a log of the Faculty login and logout time for their reporting needs. A. With the information provided above, identify and create the entities for the School Management System. B.Identify an entity created above that can be drawn as a supertype with subtype entities. C. Add the * , ° as appropriate to all the entities of the Academic Database to identify and add mandatory and optional notation to the ERD.