Question 1
IIT Madras runs a BS Degree Program in Data Science & AI, which has thousands of students enrolled across multiple levels (Foundational, Diploma, and Degree). The institution needs a database system to manage:
- Student enrollments, tracking performance across multiple subjects and semesters.
- Faculty assignments to courses, ensuring each instructor handles only specific subjects.
- Course prerequisites (e.g., a student must complete Mad1 before Mad2).
- Secure storage of student grades and transcripts, ensuring only authorized access.
- Handling transactions such as course enrollments, fee payments, and refunds.
Considering the above requirements, which type of database system is most appropriate?
NoSQL (Document-based database like MongoDB)
Graph Database (e.g., Neo4j)
RDBMS (e.g., PostgreSQL, MySQL, SQLite)
Key-Value Store (e.g., Redis, DynamoDB)