Design an ER diagram for a University, which manages the students, Programmes, courses and student results. You should clearly identify the entities, relationships, relationship cardinality and key constraints in your answer. You must also add proper attributes for each entity. A brief description of the University is given below. Make suitable assumptions.
A University allows students to register for its programmes offered during an Academic year. The academic year starts in July and ends in June. All the programmes of the University are of 1-year duration. Each programme consists of 5 compulsory courses of 4 credits each. A student is given an account on the University MIS, where s/he can see her/his result. University conducts the examinations at the end of the academic year. A student is declared passed in a course if she secures 50% marks in the examination of that course. A student must pass all the courses of the programme in which she has registered. The students who have passed their programme are awarded a certificate during a convocation, which is held once a year.
The University database system can be designed using an Entity–Relationship (ER) model that captures all entities, attributes, relationships, cardinalities, and key constraints. The main entities are Student, Programme, Course, Academic Year, Examination, and Result. Student entity includes attributes: *Student\_ID (PK), Name, Date\_of\_Birth, Gender, Address, Contact\_No, Email, Account\_ID*. Each student is uniquely identified by Student\_ID. Programme entity includes attributes: *Programme\_ID (PK), Programme\_Name, Duration, Total\_Credits*. Since every programme is of one-year duration and has 5 compulsory courses, the duration and credits are fixed but explicitly ____ __________ ______ _____ __________ _______ _________ _______ _________ ________.
___ _____ _________ ______ _________ _____ _____ ______ ___ ______ _________.
_____ _________ ________ ______ ________ _______ _______ ______.
__________ _________ _____ _____ _____ ___ _____ _________ ________ ___ __________ ________.
__________ _______ ______ _______ _____.
__________ __________ ______ ____ _______.
______ __________ ________ ________ __________ _________ ________.
___ __________ _____ _____ ______ ______ ________.
_______ _______ ______ ___ __________ ____ ________ _______ ______ _______ _________ _________.
________ _________ __________ _______ _______ __________.
_____ ________ _______ _____ ________ ___ _________ _____ ________.
_________ ________ ______ ___ ________.
______ __________ ____ ____ ____ __________ _______.
________ _________ _______ ___ ____ ________.
___ _______ ________ _________ _______ ________ ____.
__________ _______ _______ ___ __________ __________ _____.
_____ ______ _________ ___ ________ _______ _________ ____ _____ ________ ___ ____.
____ ______ __________ ____ ___.
___ ___ ______ __________ ____ __________.
_____ _______ ____ _________ ____.
__________ ______ ____ _____ __________ ___ ___ __________ _______ ___ __________.
____ ____ _______ __________ _____ _____ _____ ___.
________ ____ ________ __________ ________ _______ ____ ________ _______ ________.
_____ ___ _____ _____ ______ ____.
_________ ______ ___ __________ _______ ________ _______ __________ ___.
_______ ___ ____ __________ _____ __________ ____ _____.
_________ __________ _______ ____ ________ ______ ______ _______ _____ _________ ______ ________.
______ ________ _______ ____ __________ _________.
_____ _________ _______ ____ _______ ___.
_______ _______ __________ _____ ______.
___ ______ ______ ___ ______ ____ _________ _________ __________ ______.
___ _________ ___ __________ ______ __________ ______ ____.
_______ ______ _____ _________ ______ _______ _____ _______ _________ ____ _________ __________.
_________ ________ _______ ____ __________.
________ ______ _________ _________ _______ ____ ____.
________ ________ _______ _________ ______ _____ ________ __________ ___ _____ _____ ______.
______ _______ ______ _____ _________ ___ _______ ________ _________.
________ ___ __________ ___ ______ _____.
__________ ________ ____ ______ __________ _______.
_______ ______ ______ _____ _____ ________ _______ ______ _________ _________.
_______ ____ ________ _________ _____ _______ __________ ______ ______.
________ _________ _________ ________ _____ __________ __________.
________.
Get Full Answer on WhatsApp