Question

An online learning platform, "EduSphere," needs a database to manage its operations. The requirements are as follows:

 




     
  • The platform has many Students. Each student is identified by a unique StudentID and has a Name, Email, and RegistrationDate.



  •  
  • The platform features several Instructors. Each instructor has a unique InstructorID, Name, and a short Bio.



  •  
  • There are multiple Courses on offer. Each course has a unique CourseID, a Title, Duration (in hours), and a Fee.



  •  
  • An instructor can teach multiple courses, but each course is taught by only one instructor.



  •  
  • A student can enroll in multiple courses, and a course can have many students. When a student enrolls, the EnrollmentDate and the final Grade obtained are recorded.



  •  
12 Sep 2025
Answer :
Word Count : 240
To design a database for "EduSphere," we need to identify entities, their attributes, and relationships based on the given requirements. The main entities are Students, Instructors, Courses, and Enrollments. The Students entity will include attributes: `StudentID` (Primary Key), `Name`, `Email`, and `RegistrationDate`. This ensures that each student is uniquely identifiable and their personal and registration information is recorded. The Instructors entity will include: `InstructorID` (Primary Key), `Name`, and `Bio`. This captures details about instructors and allows linking them to the courses they teach. The Courses entity
__________ _____ _____ __________ ____ ____ _________ _________.
___ _________ ___ _____ ______ ______ __________ ______ _____ ___ ___.
_________ _________ ____ _____ ____ _______.
_____ ______ _______ _________ _____ ___ ________ ________ _____ ____ _________.
________ _______ _____ _____ _________ _________ _________ _____.
___ ________ ___ ___ _____ ___ ___ _______ _________ _____ ______.
____ ________ ______ ____ ________ _______ _________ _______.
__________ _______ ___ ______ _______.
______ __________ ________ ________ ______ __________ _____ _____ ______ _______.
____ _____ _____ _________ _____ ____ __________ _____ ________.
_______ ___ ___ __________ _________.
_________ _________ ____ ____ ______ _____.
___ _____ ______ ________ ____ _________ ________.
_______ __________ __________ ____ ____.
__________ ________ _________ ______ ____ __________ ______ _____.
______ ____ _____ ___ ______ ___ ________ ______.
________ _____ __________ __________ ___ ________ __________ _________ _______ ________.
_____ ______ ____ ___ ___ ________ ___ __________.
____ __________ ___ ___ ________.
____ _____ ___ ______ ___.
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 23 2025 2026 - An online learning platform, "EduSphere," needs a database t | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→