BTechibtechi.in
Loading Loading
Free IIT Madras BS notes, PYQs and mock tests at btechi.in

DBMS · Entity-relationship model

6 questions · 15 marks · 6 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

Entity-relationship model

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MSQ: One or more options correct. Select all to score.
Scientific calculator allowed for all calculations.
Official answer key is sealed at the end of this sheet.

Quiz 1 · 26 Oct 2025 (AN)Quiz 1

Q1MSQ3 Marks·Choose all correct options
Asked 5 times Key ↓
1. AThere might exist an item that has not been produced by any company
2. BThere might exist a customer who has not ordered any item
3. CAn item can be ordered by multiple customers
4. DAn item cannot be produced by more than one company

End Term · 31 Aug 2025 (FN)End Term

Q2MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
1. A
2. B
3. C
4. D

End Term · 13 Apr 2025 (FN)End Term

Q3MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
Consider the following Entity Relationship Diagram: Choose the correct statements.
1. AA bank can provide more than one ATM machine
2. BAn ATM card is used by only one customer
3. CA customer can use only one ATM card
4. DAn ATM card can be inserted in many ATM machines

End Term · 13 Apr 2025 (AN)End Term

Q4MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
Consider the following Entity Relationship Diagram: Choose the correct statements.
1. AA bank can provide exactly one ATM machine
2. BAn ATM card can be used by multiple customers
3. CA customer can use multiple ATM cards
4. DAn ATM card can be inserted in many ATM machines

End Term · 22 Dec 2024 (FN)End Term

Q5MSQ3 Marks·Choose all correct options
Asked 5 times Key ↓
1. AA bank offers more than one loan
2. BAn account is managed by more than one bank
3. CEvery loan must be availed by at least one customer
4. DEvery customer must be holding at least one account

End Term · 22 Dec 2024 (AN)End Term

Q6MSQ3 Marks·Choose all correct options
Key ↓
Consider the ER Diagram as shown below: Identify the correct relational schema for the relationship set Bank, Account and Manages Note: The primary key is underlined.
1. A
2. B
3. C
4. D

Official Key

Master Answer Key & Explanations

Official answer keys from IIT Madras BS past papers. Click any question to review.

Reveal Key

Q1C, D

Q2A, B, D

Q3A, B, D

Q4C, D

Q5A, D

Q6A

Questions and answer keys are reproduced from the official IIT Madras BS papers. Topics and repeated question types are BTechi’s own grouping. BTechi is not affiliated with IIT Madras.