Question

 

 Draw ERD for a Student Admission System. Make necessary assumptions.

12 Sep 2025
Answer :
Word Count : 1390
The Student Admission System is a crucial application in the domain of academic institutions, designed to handle the complete process of admitting students into various programs. Systems Analysis and Design provides a framework for understanding how such a system can be modeled, developed, and implemented. One of the essential techniques in this process is the construction of an Entity Relationship Diagram (ERD), which is a graphical representation of the entities, attributes, and relationships in the system. In order to develop an ERD for the Student Admission System, it is important to first analyze the requirements, identify the entities involved, define their attributes, and establish the relationships that exist among them. With necessary assumptions, the ERD will serve as a logical representation of the data requirements, which can later be translated into a physical database model. In the Student Admission System, the primary objective is to capture all information related to the admission process, from the stage of a student applying for admission to the stage of final enrollment in a course or program. The system should also maintain details of programs, departments, courses, faculty involved, and supporting details like entrance exams, documents submitted, and fee payments. Assumptions can be made in order to simplify the diagram, while still covering the critical aspects. For example, it may be assumed that a student can apply to only one program at a time, that all students are required to submit basic documents such as identity proof and previous academic records, and that every student who is admitted will be enrolled in a specific course under a department. These assumptions guide the construction of entities and their relationships. The first major entity is Student, which represents all candidates applying for admission. The attributes of this entity may include Student\_ID (primary key), First\_Name, Last\_Name, Date\_of\_Birth, Gender, Address, Email, Phone\_Number, Nationality, and Category (such as General, OBC, SC, ST). Student\_ID serves as a unique identifier for every applicant and will form the basis of relationships with other entities. The second important entity is Application, which captures details about the admission application submitted by the student. Since a student can submit one or more applications (in the case of multiple programs or institutions being modeled), there exists a one-to-many relationship between Student
________ _____ ________ ___ __________ _______ _________ _________ _______.
________ _____ _____ _________ ______ _________ _________ ___ _____ _____ _______ _______.
_______ _________ _________ ___ ___ _________.
__________ _________ _________ ___ _______.
________ _________ ______ ______ ______ ______ ___.
___ _______ ______ ___ _________ _______.
__________ ________ ______ _______ ___ ____ _________ ________ ____ __________ ____ __________.
________ ____ _________ ____ _________ __________.
___ ___ _________ _______ ____ ________ _______ _______.
_________ __________ _____ ______ _____ ____ _______ _______.
___ _________ __________ _______ _________.
______ _______ ___ _____ ___ ___ _________.
_____ _________ _________ ____ _____ ______ _______ ________ _______ _________ __________ _________.
______ _____ _____ _________ ____ __________ _________ _________ _____ ______.
______ ________ ____ ____ ____ ________ ______ _______.
_______ ________ ______ ______ __________ ______ ____.
__________ _________ _____ ______ __________ ____ _______.
___ __________ _________ __________ __________ _______ _______ ___ _________ __________.
_________ _____ _________ _________ ______.
______ __________ ________ _________ __________ ___ ______ _____.
_____ ________ __________ ___ _______ ________ __________ _____ ______ ____ _________ ___.
______ _____ _________ __________ ____ ____ ___ ______ ___.
___ _____ ___ __________ ___ __________ ________ ___.
__________ ______ ________ _______ _______ ____ ________ _______ ____ _______ __________ ________.
_____ ______ ___ _______ _______ ___ ______ _____ ________ _______ _________ ____.
__________ ______ _____ __________ _______ _______ ______.
_______ ___ _________ _______ _______ _____ _______ _____ ____ _______ ______.
______ ______ ___ _________ ____ _______ _____ ______ _______ _____.
_________ ___ _______ __________ _____ ____ ________ ____ ___.
__________ ___ ___ _____ ___ ________.
_________ _______ _________ ____ ________ ____ ___ ____ _________ _____ __________.
___ ______ ______ _____ ___ ___ _____ __________.
_____ ___ _________ ____ ____ ________.
__________ ______ ________ ________ ________ ____ _______.
________ ________ __________ __________ ____.
______ ________ ___ ___ ____ ________ __________ __________.
_________ __________ ________ _________ _____ _______ __________ __________ _________ ___ _______.
______ _____ ________ __________ _________ ___ ____.
_____ ______ ________ _______ _______ ___ ____.
____ _____ __________ ____ ____.
______ __________ _____ ____ _____ _______ _________ __________ _____ _____ ____.
__________ ____ ____ __________ ________ ______ _________ _____.
__________ ___ ______ _______ ___ _________ ______ ________ _______ ______.
___ _____ _______ ____ ____ ______.
_________ __________ _____ ________ ______ ________ _______ _________ ______ ________ __________ ___.
_______ _______ _______ ____ _____ _______ ______ _______ _________ __________.
_____ _____ __________ _____ _________ _________ ____ _____ ____ _____ _________ ____.
_________ __________ __________ __________ __________ ___ _________ _______ _________ _________ ______.
_____ ________ ____ ________ _____ __________ ____ ____ __________ _____ _____ _________.
___ _________ ___ ______ _____ __________ __________ ______ ____.
_________ ________ _______ ___ ______ ____ _________ _______ ________ ______ _________.
_____ _____ __________ _________ ___ _______ ____ ____ ____.
______ _____ ________ _____ ________ _________ ______ ___ _______ ___.
______ ______ __________ __________ _______ ___.
____ ______ _________ _______ _______ _________ ____ ________ ____ ______ ________ __________.
__________ _________ ______ _________ _______ ______ _____ _________ _________ _________.
___ ___ _____ _______ _______ ______ ____ _______ ___ _______.
_______ _________ ___ ___ _______ _____ ____.
_________ _______ ____ ___ ________ _____ ___ ____.
________ __________ ________ _____ _______ ______ _____ __________ ________ ________ ____.
______ ______ _______ ___ _______ _____ _______ _______ ____ ___ ______.
_____ __________ ____ _________ ____ ________ ______.
______ __________ ______ ______ _________ ___ ___ ________ __________ ______ ________.
______ ________ ___ ___ ____ _________ _______ _________ _____ ____.
____ ________ __________ _________ _______ __________.
___ ___ ___ ___ ______ _____ ________.
__________ _____ _________ _________ ____ __________ _________ _______ ____ ___ _________ _________.
______ ______ _____ __________ _________ ______ __________ ____ ______ ____.
___ ____ ________ ____ _______ _______ __________ _____.
______ ____ __________ _______ __________ ___ ________ _____.
_________ _______ ____ _________ ___ __________ __________ _________ ______ _________ ______.
______ __________ _____ __________ ________ ____ _______ ___.
________ _______ ___ ________ _________ _____ _____ __________ _____ ____ _______ ________.
_________ _____ _______ _____ ___ _________ _______ __________ _____ _______ _________.
_______ ___ ____ ____ _____ _____ ________ ________.
__________ _________ __________ ___ ______ ____ ______ ___ _______ ______ _________.
____ ______ ___ ____ ___ _______.
_______ _______ __________ _______ ____ _______ ________ _______ _________ ___.
___ ___ _________ _____ _______ _________ ______ ___.
_________ ___ ____ __________ _____ _______ _________ ______ _________ ________ __________ ________.
_________ ______ ___ __________ _________ ____.
____ __________ ____ __________ ________.
___ _______ _________ __________ _____ _________ _____ _________ ________ ______ ___ _____.
_________ ________ ___ ______ _______.
_____ _____ ____ _______ _________ __________ ___ ______ ______ _____ __________ ____.
___ _________ __________ ____ _________ _____ ___ ______ _______ _____.
______ _________ __________ __________ _________.
_______ __________ ____ _________ __________ _________ _____ __________ ________ _______ __________ __________.
________ _____ ____ ___ __________ __________ _______ ____ ______.
________ ________ _________ ______ ______ ______ ___ __________ _________ ___ ________ _____.
_________ ________ ______ _________ _________.
_________ __________ ___ ___ ______ ______ __________ _____ __________.
____ ____ __________ __________ ____ _________ ______.
_______ _________ ________ ___ _____ ____ ______ ___ _______.
_________ _____ ________ __________ __________ _____.
_____ ____ _____ _________ ________ ___ _________ _________ ______.
____ _____ ___ ____ _____ ________ _____ ______ ______ __________.
_______ __________ ___ ____ _____ __________ __________ _____ _______ __________.
________ ___ __________ _____ _________.
_____ ____ ______ _____ _______ __________.
__________ _______ _________ _______ ________ ____ _________ _____ _________ __________ ______ _______.
_______ ________ ________ ____ ______ _____ _______ _____ ________ _______.
___ ______ __________ ______ __________ __________ ______ ________ _________ ______ ___.
________ ______ _______ ________ _________ _______ _____ ______ __________ ______ ______ ____.
_______ ___ _______ _______ ____ _____ __________ _____.
_______ _________ _____ __________ ___ _______ __________ ___ _______ __________ _______.
___ ____ _____ ______ _____ ____ _______ ______ ______.
_______ ________ ________ ___ ___.
______ ______ ____ __________ _________ ________ ___.
__________ _____ _______ ________ ____ _____.
____ _________ _______ ________ __________ _______ _____ _______ _____ _______.
__________ __________ _________ ___ _____ ______ ________ _________ ______ __________ __________ _______.
______ _________ ________ _____ ____ ________ ___ ____ ________.
________ _______ ____ _____ _________.
_________ ________ _______ ____ ______.
__________ __________ ________ ____ ___ _______ _______ _____.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCS 14 2025 2026 -   Draw ERD for a Student Admission System. Make necessar | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→