Problem
An examination is designed for a section of a course and is characterized by a start time and a duration, a list of documents allowed during the examination, the date of the examination, a room (building name and room#). An examination is composed of n questions numbered from 1 to n. A question has a question ID (QID which different from the question number of an examination) a title, a specification (a text describing what to be done) and points for the question (a number between 1 and 100) of an examination is designed by one or several authors that are faculty members. The questions are kept in a question bank and a question can be used in different examinations with a different question number each time it is used. A faculty member has a unique SSN, a name, a date of birth, a title (assistant professor, lecturer, full professor,...), a unique e-mail address, a unique phone number (2 faculty members cannot share the same phone number) and an address. A student can register to several courses but to only one section of the same course for a semester (Fall 2014, Spring 2022). A student has a unique UCID, a name, a date of birth, an e-mail, an address and a major. A course has an ID, a name and a description. A section of a course is assigned to a faculty member who teaches that section of the course for a given semester. A section of a course is taught by one faculty member but a faculty member can teach different sections of the same course or different courses. To take an examination, a student has to register for the course and the section for which the examination is designed. A student gets a grade for each examination taken.
Task
A. Identify entity types and attributes
B. Identify relationships types and mapping cardinalities
C. Present a complete ER diagram
D. Give a step by step mapping of the ER diagram to the relational model.