Reference no: EM133217470
NJIT would like a database to manage examinations (finals and midterms). The database has to contain information about the examinations to be given for classes and sections as well as the grades of the students who took the examinations. The database should allow to answer queries like "how many database examinations did a student have last year?", "what is the CS 631-851 class average on Question 3 of the final examination given in Fall 2014?" "what are the UCIDs, names and date of birth, ... of the Fall 2014 CS 631-851 students"? What is the average on Question 2, Midterm 1 of the CS 431-001 students?
An examination is designed for a section of a course and is characterized by a 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 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. 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 2008). 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.
Tasks
Identify entity types and attributes
Identify relationships types and mapping cardinalities
Present a complete ER diagram
Give a step by step mapping of the ER diagram to the relational model.