E-R diagram with instructors and courses entities, manages and works relationships, and weak entity health linked through information (Figure 2: Organization ERD)

(A) The instructor can work in various courses and courses can have more than one instructors working in them.

(B) We will not store the information about a health record once the instructor leaves the organization.

(C) The instructor can manage more than one courses.

(D) Total 5 tables are required to represent the given ERD into a relational schema.

Database Management Systems · Quiz 1 · 13 Jul 2025 · May 2025 term

DBMS Quiz 1 13 Jul 2025 — Question 12

Question 12

+4 marksOne or more correct options

Select all that apply.

A
The instructor can work in various courses and courses can have more than one instructors working in them.
B
We will not store the information about a health record once the instructor leaves the organization.
C
The instructor can manage more than one courses.
D
Total 5 tables are required to represent the given ERD into a relational schema.

Show answer

Correct answers

A
The instructor can work in various courses and courses can have more than one instructors working in them.
B
We will not store the information about a health record once the instructor leaves the organization.
C
The instructor can manage more than one courses.

See the whole paper Take it as a mock test

Question 12 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 13 Jul 2025, in the May 2025 term (IIT M DIPLOMA AN EXAM QDD2 13 July 2025). It carries 4 marks.

DBMS Quiz 1 13 Jul 2025 — Question 12

Question 12

More questions from this paper