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

DBMS · Normal forms & decomposition

8 questions · 27 marks · 4 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

Normal forms & decomposition

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MCQ: Exactly 1 option is correct. Negative marking applies.
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.

End Term · 31 Aug 2025 (FN)End Term

Q1MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A(0,1,2,7,8)
2. B(0,5,2,3,4)
3. C(0,5,6,3,8)
4. D(0,5,2,7,4)
Q2MSQ3 Marks·Choose all correct options
Asked 4 times Key ↓
1. A
2. B
3. C
4. D

Quiz 2 · 3 Aug 2025 (AN)Quiz 2

Q3MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. AThe decomposition is lossless and dependency preserving
2. BThe decomposition is lossy and dependency preserving
3. CThe decomposition is lossless but not dependency preserving
4. DThe decomposition is lossy and not dependency preserving
Q4MCQ4 Marks·Choose one option
Key ↓
1. A1NF
2. B2NF
3. C3NF
4. DBCNF
Q5MCQ4 Marks·Choose one option
Key ↓
1. AStatement 1 is correct and Statement 2 is wrong
2. BBoth the statements are wrong.
3. CStatement 1 is wrong and Statement 2 is correct.
4. DBoth the statements are correct.
Q6MCQ4 Marks·Choose one option
Asked 2 times Key ↓
1. AF = Novel, G = BookWorld, H = ReadersHub, I = Delhi, J = Mumbai
2. BF = Magazine, G = BookWorld, H = ReadersHub, I = Delhi, J = Mumbai
3. CF = Magazine, G = ReadersHub, H = BookWorld, I = Delhi, J = Mumbai
4. DF = Novel, G = ReadersHub, H = BookWorld, I = Mumbai, J = Delhi

End Term · 22 Dec 2024 (FN)End Term

Q7MSQ3 Marks·Choose all correct options
Asked 4 times Key ↓
1. AThe decomposition of R into R1 and R2 is dependency preserving.
2. BThe decomposition of R into R1 and R2 is lossless.
3. CThe schema R1 is in 3NF.
4. DThe schema R2 is in 2NF.

End Term · 22 Dec 2024 (AN)End Term

Q8MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. AThe decomposition of R into R1 and R2 is dependency preserving.
2. BThe decomposition of R into R1 and R2 is lossless.
3. CThe schema R1 is in 3NF.
4. DThe schema R2 is in 2NF.

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1B, C, D

Q2A, B, C

Q3C

Q4B

Q5D

Q6B

Q7A, C, D

Q8B

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.