Quiz Space

Database Management Systems · Quiz 1 · 23 Feb 2025 · January 2025 term

Question 14: In a typical design, what is the relationship between th…

Question 14

+2 marksOne correct option

Consider the following scenario and answer the given subquestions
A startup company is building an online learning platform that hosts courses on various subjects. In this platform, students can enroll in multiple courses, and each course can be taught by one or more instructors. The company wants to design the database schema to manage the core entities: Student, Instructor, Course, and Enrollment.

In a typical design, what is the relationship between the Student table and the Enrollment table?

  1. A

    One-to-One

  2. B

    One-to-Many

  3. C

    Many-to-Many

  4. D

    Many-to-One

Show answer

Correct answer

  • D

    Many-to-One

See the whole paperTake it as a mock test

Question 14 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 23 Feb 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025). It carries 2 marks.

More questions from this paper

  1. Q1Which level of abstraction is responsible for providing data security by limiting access to specific data views?
  2. Q2Consider the relation student shown in Table 5. | roll_no | name | house_name | |---|---|---| | 1 | John | Nilgiri | | …
  3. Q3Consider the tables Products and Suppliers given below: | P_ID | P_Name | S_ID | |---|---|---| | 1 | Laptop | 3 | | 2 |…
  4. Q4Consider a relational database for Formula One Racing containing the following tables. | D_ID | D_Name | T_ID | Points …
  5. Q5Consider the following relations:\ auto_part(<u>pid</u>, pname, color)\ auto_suppliers(<u>sid</u>, sname, location)\ ca…
  6. Q6Figure question
  7. Q7Figure question
  8. Q8Figure question
  9. Q9Figure question
  10. Q10Consider the following Students table | student_id | name | grade | marks | |---|---|---|---| | 1001 | Alice | A | 85 |…
  11. Q11Consider relations Book and Author shown in Table 6 and Table 7 | BookID | Title | AuthorID | Genre | |---|---|---|---|…
  12. Q12Consider the tables student and course as shown below. | ID | name | dept_name | |---|---|---| | 21f11 | Ram | CS | | 2…
  13. Q13In the Enrollment table, which of the following is a typical way to handle the primary key?