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
25 Jul 2024
Answer :
Word Count : 633
  1. Entities:

    • Learner Support Center (LSC)
    • Regional Center (RC)
    • Department
    • Programme
    • Course
    • Student
    • Examination Center
  2. 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★★★
Top
📞
Call Support Instant phone assistance ABC is a University which is having Learner Support Centers (LSCs) acr
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→