Design a generalization /specialization hierarchy for a University Adm

Question

Design a generalization /specialization hierarchy for a University Admission System. The University has many programmes, each programme has a specific duration. Registration into a programme requires students to register for many subjects of that Programme. The eligible students can take fresh admission or can re-register in the courses by paying the requisite fee.

Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table.

24 Apr 2024

Answer :

Word Count : 340

Generalization/Specialization Hierarchy for University Admission System:

At the top level of the hierarchy, we have the entity Programme, representing the various academic programs offered by the university. Each program has specific attributes such as ProgramID, ProgramName, Duration, etc. The Duration attribute is placed at this level because it is a characteristic shared by all programs.

Below the Programme entity, we have two specialization entities: Fresh Admission and Re-registration.

1. Fresh Admission: This entity represents the process of newly enrolling students into a program. It includes ______ _______ ___ _____ _________.
________ _______ ___ ______ ___ _________ __________ ____ _______ __________.
_____ ____ ____ _____ __________ ______ ___ ______ ________.
___ _______ _________ ____ _________ _______ ________ ____ __________ ________ ____.
_______ _________ ________ __________ __________ ____ __________ _____ _________ ________ __________.
_______ _____ ____ _________ ______ ______ ________ __________ _______ _____ ____.
____ _________ _________ _____ _________ _________ _______.
________ _________ ___ __________ _________ __________ _____ ______ _____.
_____ ___ ___ ________ __________ ________.
_______ _______ ________ ____ _________ ________ ________ _________ _______ ______ _________.
________ ___ ________ _______ __________ ________ _______ ________ _________.
_______ _______ _________ _______ _______ ________ __________ ______.
___ __________ _____ _____ ________ ____ _____ _________ ________ ____ ___.
____ ______ _________ ________ ______ ______ ______ ____ __________ _______ ____.
__________ _____ ______ _______ ____ _____.
___ _______ _____ ______ _________ _________ ___ _____ ________.
_______ ________ ____ ____ ______ _____ ______ ___ ________ ________ _______.
_____ _________ _______ _______ ___ ______ ___.
___ _______ _____ ______ _________ __________ _______ ____ ____ ___ _____ __________.
___ ________ _________ _________ ______ ___ ____ ______.
_________ ______ ________ _____ ________ ________ _____ ________ ______ _______ __________.
_____ __________ ___ ___ ________ ______.
_____ _________ ________ ___ __________.
________ _______ ________ __________ _________ _____ __________ __________ ________ ____ _______ ________.
_______ ___ ____ _____ ________ __________ __________ _________ ___ ______ _____.
_________ ______ _________ __________ ____ ________ __________ ________ ____.
__________ _______ ________ ________ ____ ____.
____ ______ __________ ___ ________.
____ ____ _________ _____ ______.
___ ________ _______.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★