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 stored. Course entity includes attributes: *Course\_ID (PK), Course\_Name, Credits, Programme\_ID (FK)*. Every course belongs to one programme, so there is a ________ __________ ________ _________ _________ _______ _______ __________ ________ __________ _________ _______.
________ ______ ____ ______ _____ _______ _________ _____ ___ ___ __________ _________.
___ ________ ___ _______ __________ _______ ___.
_________ ___ _______ ____ _________.
______ __________ ____ _______ _________ _________ ________ _________ ____ _____.
________ _______ _________ ________ _____ _________ ____ ________ _________ ___ _______ _____.
________ ___ _______ __________ ____ _________ ________ ____ _______ _________ ________.
________ _______ ____ ________ ___ _____ ________ ___ __________.
________ _______ __________ ________ __________ _________ ___.
__________ _______ ____ _______ __________ ____ ______.
______ ____ _____ ________ ______ _________ ___ ______ _________.
_____ ______ __________ ____ ______.
_____ _________ ___ ______ __________ ________.
___ __________ ___ __________ ________ __________.
_________ ___ _________ ___ ______ ________ ____ _________ ________.
_________ ________ _________ __________ _________ ______.
____ _______ ___ __________ __________ __________ _____ __________ _______ ________.
__________ ______ _____ _____ __________ ___ ____ _________ ________ ______ __________.
_____ _______ ________ ____ __________ _____.
_____ _______ __________ _________ ______ ________ __________ _________ _____ _____.
____ _______ __________ ________ ___ _____.
__________ ______ _____ ____ _____.
___ ____ ____ __________ _________ _______ ____ ____ _______ ____.
_____ ________ _______ ________ __________ __________.
____ _____ ___ _____ _________ _________ _______ __________ _________.
_________ ____ ____ ____ ______.
______ ____ _____ _____ ______ ____ _______ _______.
_________ __________ _________ _______ ________ ______ ________.
_____ _______ ______ ________ ________ __________ ____ _______ ________ __________ __________.
_________ ____ __________ ________ ____ ____ ____ _______ ________ ___ _____ __________.
_________ _______ _______ __________ ___ _______ __________ ______ _______ ______ ________ _________.
____ ____ _______ ______ ________.
________ ________ ___ _______ ____ _________.
____ __________ ___ ____ _________ _________ _________ ____ __________ ______ ____ ___.
______ ________ ______ __________ _________ ____ ____ ______ ____ ______.
____ _______ _______ _________ ________ __________ __________ ________ ______ _________.
______ ________ ___ ___ ___ _____ ______ ______ _______.
____.
Get Full Answer on WhatsApp