Scribd
Upload
2 views1 page

DBMS Module 4 Question Bank

The document is a question bank for a DBMS module focusing on database normalization and functional dependencies. It includes questions on the concepts of normalization, such as 1NF, 2NF, 3NF, and BCNF, along with examples and the process of computing minimal covers. Additionally, it examines functional dependencies and their role in reducing redundancy within databases.

Uploaded by

pushkargk2006
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

DBMS Module 4 Question Bank

The document is a question bank for a DBMS module focusing on database normalization and functional dependencies. It includes questions on the concepts of normalization, such as 1NF, 2NF, 3NF, and BCNF, along with examples and the process of computing minimal covers. Additionally, it examines functional dependencies and their role in reducing redundancy within databases.

Uploaded by

pushkargk2006
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DBMS-Module 4

Question Bank
1. How functional dependencies contribute to the process of database normalization.
Illustrate your answer with suitable examples. Analyze the need for normalization in
DBMS. Outline 1NF and 2NF with examples.
2. Explain how functional dependencies help in database normalization. How does
normalization help in eliminating redundancy?
3. What are functional dependencies? Give examples.
4. Explain First Normal Form (1NF) with an example.
5. Explain Second Normal Form (2NF) with an example.
6. Convert a 3NF relation into BCNF.
7. Explain the steps to compute a minimal cover.
8. Consider 2 sets of functional dependencies. Examine whether they are equivalent.
a) F= {A→C, AC → D, E → AD, E → H} AND
G= {A → CD, E→AH}.
b) X= {AB→CD, B→C, C→D}, AND
Y= {AB→C, AB→D, C→D}
9. Explain Third Normal Form (3NF) and Boyce–Codd Normal Form (BCNF), and
illustrate each with suitable examples.
10. Analyze the following relation schema and its functional dependencies to determine its
level of normalization:
Given a relation R(A, B, C, D) with functional dependencies
F = { A → B, B → C, C → D }
[Link] whether the relation R is in Third Normal Form (3NF). Justify your answer
by examining the functional dependencies and identifying any violations.
[Link] the relation is already in 3NF, analyze and transform it further into Boyce-Codd
Normal Form (BCNF) by identifying violating dependencies and performing
appropriate decomposition.
11. Examine given set of functional dependencies and construct minimal cover
a) E: {AB → D, B → C, AE → B, A → D, D → EF}
b) F: {A → BC, B →C, A→B, AB →C}

You might also like