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.
______ _____ _____ ________ _______ _________ ______ _____ _________ ____ ____.
____ _______ ________ ____ _________ _______ ______ __________ ___.
_________ ________ ___ ___ _______ _____ ________ ________ _________ _______ ____.
_____ ______ ____ ___ _______ ____ ________ ___ ___ ________ _________ ________.
________ _______ ___ _______ _________.
___ _________ _______ __________ ________ _______ _____ _________ __________ ________ _______.
______ _____ ____ _________ _______ _________ _______.
_______ ________ _____ _________ _________ ______ _____ __________ _____ _______.
___ ________ ____ __________ ___ __________ _________ _________ ________ _________ _______.
________ ____ ____ _______ _________ ______ ______.
__________ ____ ______ ________ ____.
____ ______ ____ ________ ___ __________ __________ ____ ___.
________ ____ _____ _______ _________.
___ _______ _______ _____ _________ __________ _______ ____ _________.
_____ _______ _________ ___ ____ _____ ___.
________ ________ ____ ______ _________ _________ _____ ____ _____ ____ ________ ________.
_____ ______ __________ ____ _______ _______ _____ _______ ____.
______ _______ ___ __________ _________ ______ ________ ________ _________ _________.
______ _____ ___ ______ ___ ________ __________ _________ _________ ________.
__________ ________ __________ ____ ____ _____ ___ ____.
_________ ___ _____ __________ ___ ______ __________ __________.
____ ______ _______ ______ _________ __________ ____ _______ __________ _________.
_______ _______ _______ ____ ______ ___ _________ ________ ____ _________.
________ _____ ____ ____ ____ _________ __________ __________ ___ _______.
_________ _______ _______ ________ _______ ________ _________ ____ _________.
________ ___ __________ ________ __________ _________ ____.
_____ _______ ___ _____ _________.
________ ____ _______ ______ _________ __________ ________.
________ ___ _______ ____ _____ ____ ______ _______ _____ ______.
__________ ____ __________ ____ ______ ___ _________ ___ ______ ____.
________ _____ _____ __________ ___ ___ ______ _________ _______.
__________ __________ ________ ________ ________ ______.
______ ________ ______ __________ ____.
____ _______ _________ ________ _______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required