Question
ABC is a University which is having Learner Support Centers (LSCs) across the World. It also had Regional Centers (RCs) across the World. ABC also includes many departments which offer various programmes. However, not all LSCs offer all the Programmes. Counseling sessions normally take place during weekends.
Minimum attendance of 75% is essential in Practical Counseling Sessions. Every LSC is having a Code. Every RC is having a code. Every Department is having a Code. Every Programme is having a Code. Every Course is having a Code. Any person who takes admission to any of the Programmes is also having an enrollment number. All codes and enrollment number are unique. Semester End Examinations are held at designated Examination Centers and every Examination Center is having a code. Every students is assigned to a LSC where he attends counseling sessions. A student can seek transfer from one LSC to another.
Now, with reference to the above, answer the following:
(1) List the Entities
(2) For each Entity, list Attributes
(3) Define relationships between the Entities
(4) Finally, draw the Entity Relationship Diagram
Answer :
Word Count : 633
-
Entities:
- Learner Support Center (LSC)
- Regional Center (RC)
- Department
- Programme
- Course
- Student
- Examination Center
-
Attributes:
-
Learner Support Center (LSC):
- LSC_Code (Primary Key)
- LSC_Name
- Location
- Supported_Programs (could be a list of program codes offered at that LSC)
-
Regional Center (RC):
- RC_Code (Primary Key)
- RC_Name
- Location
-
Department:
- Department_Code (Primary Key)
- Department_Name
-
Programme:
- Programme_Code (Primary Key)
- Programme_Name
- Department_Code (Foreign Key from Department)
-
Course:
- Course_Code (Primary Key)
- Course_Name
- Programme_Code (Foreign Key from Programme)
-
Student:
- Enrollment_Number (Primary Key)
- Name
- LSC_Code (Foreign Key from LSC)
- Programme_Code (Foreign Key from Programme)
- Attendance (can include attendance percentage for counseling sessions)
- Transfer_Status (Indicates if the student ________ ______ ______ _______ _________ _______ __________ _____.
_________ _________ ___ _______ ________ _________ _______ _________.
________ ________ __________ ____ ________ ______ ____.
_____ _____ ______ _____ _______ __________ ________ ________ ___ ____ ____.
_____ ____ _______ ____ ____ ______ ___ _____ __________ _______ __________.
_________ __________ __________ ________ __________ __________ _________ _____ _____ ______ __________ ___.
_______ _____ ________ ________ ___ _________ _____.
_____ ___ _____ __________ ______ _____ _____ ________ _______ __________.
________ ____ ____ _____ ____ _________.
__________ ___ _______ ___ _____ _______.
_____ ___ __________ ______ _____ _____ _____ _____ _____ ___.
__________ ______ ________ ___ ___ ________ __________ _____ ____.
______ ___ ______ _____ __________ _________ __________ _____ ____ ___.
___ __________ _________ ________ __________ ________ ____ ____ ____.
________ _______ _____ ____ _____ ____ _________ ______.
___ _________ ____ _______ ___ ______ _______ ___ _____.
__________ ________ ______ ______ _______ __________.
_______ _________ _________ ___ _________ _______.
__________ __________ ___ _____ ________ _______.
_________ __________ ___ __________ ______ __________ _________ ______.
_____ ______ _________ _____ _________ ______ __________ ________ ____ ______.
____ _________ __________ _________ ___ _____ ____ _________ ____.
_____ ____ _________ ____ ________ ____ ________ _________.
_______ ___ ______ _____ ___ _______ _______ _________ _______.
________ _________ ____ ______ ____ __________ ___ ________ ______.
_______ ________ ________ ___ ____.
______ ___ _________ _____ ________ ________.
_________ ______ __________ __________ ___ ________ ___ __________ _________.
__________ ___ ___ _______ ________ ______.
_________ ____ ___ ___ _______ __________ _____.
______ _______ _____ _______ ___.
_____ _____ _________ _______ ________ _________ ______ _______ ___ _____ ___ ___.
__________ __________ _____ ____ ________ ___ ____ _____.
_____ _________ _______ __________ ____.
___ ____ _____ __________ ________ _____ ____ _____.
______ ________ __________ ______ ___.
_________ ______ _________ _____ _________ _____ _____ ___ _______ ____.
____ _______ ______ _______ _________ ____ ____ ________ ______ __________ __________ ___.
______ ________ ____ ______ ___ ______ ________ ______ ___.
________ ______ _____ ___ _______ ______ _______ ___ ______ __________ _____.
______ ____ ___ ____ _____ __________ ____ _______ ________.
___ ___ ________ _______ ______ _______ ____ ___ _______ ___ _________.
___ __________ _________ __________ __________ ________ _____ ___ ______ _______.
_______ _______ _______ _____ ________ __________ ___.
________ _______ ______ __________ ______.
_____ ___ _____ _________ ________ ______ ______ ___ _______.
______ _________ ___ _______ ____ ____ ___ __________.
__________ ____ ___ _____ _________ _______ _______ _____ _____ ______ __________ ________.
________ ______ ________ ___ _____ ________ ______ _____ ______.
________ _________ _________ ___ ______ ____.
____ _______ ________ _______ ___ ____ ___ ___ _______ ____ ________ ____.
___ ______ ______ __________ ____.
________ ___ _____ ___ _________ ______ ______ ___.
_________ ______ ___ ________ _______ ____ _____ ___.
_____ __________ _________ _______ ___ _________ _______ __________ _____ ___ ____ _________.
_______ _______ ____ ___ __________.
_______ ______ ______ ________ ______ ______ ________.
_____ ________ ___ ________ _________ ________ ____ _________ _______.
_______ _______ ___ ___ ____ __________ ______ ____ _________ _________ ______.
____ ______ ___ __________ __________ __________ ___ ________ ________ _______.
__________ __________ ____ ______.
Get Full Answer on WhatsApp
-
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★