BSC CSIT Semester 4 – Database Management System () Questions & Answers | Past TU Exam Papers

Question 1

What is normal form? Explain their types. Explain about loss-less join decomposition.

Marks: 10

Year: 2076 Final TU

Normal Forms in DBMS A Normal Form is a set of rules or guidelines used in database design to remove redundancy, avoid anomalies, and ensure data is stored efficiently. Normalization is the process

Question 2

Define Functonal dependencies. Explain trival and non trival dependencies?

Marks: 5

Year: 2078 Final TU

Q: Define Functional Dependencies. Explain Trivial and Non-Trivial Dependencies. 1. Functional Dependency (FD) A Functional Dependency in a database is a constraint between two sets of attributes in

Question 3

Define Boyce-Codd normal form with example. How it is different that 3rd Normal form.

Marks: 5

Year: 2078 Final TU

Q: Define Boyce-Codd Normal Form (BCNF) with example. How is it different from 3rd Normal Form (3NF)? 1. Boyce-Codd Normal Form (BCNF) A relation is in BCNF if, for every non-trivial functional depen

Question 4

What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.

Marks: 10

Year: 2079 Final TU

1. What is Normalization? Definition: Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves dividing a database into two or mor

Question 5

Define functional dependencies. Explain 2nd normal form with example.

Marks: 5

Year: 2079 Final TU

1. Functional Dependencies (FD) Definition: A functional dependency is a relationship between attributes in a relation, where the value of one attribute (or set of attributes) uniquely determines th

Question 6

Define normalization. Why normalization is important in database design? Explain 1NF, 2NF and 3NF with suitable example.

Marks: 10

Year: 2080 Final TU

1. Definition Normalization is the process of organizing data in a database to: - Reduce data redundancy (duplicate data) - Improve data integrity and consistency - Make the database design effi

Question 7

What are informal design guidelines for relational schemas? why do we need functional dependencies? Explain 2NF, 3NF with suitable example.

Marks: 10

Year: 2080 Final TU

1. Informal Design Guidelines for Relational Schemas Informal design guidelines help in creating relational schemas that are free from redundancy, anomalies, and inconsistencies, and that are easy to

Question 8

What are informal design guidelines for relational schemas.

Marks: 5

Year: 2081 Final TU

Informal Design Guidelines for Relational Schemas Informal design guidelines are general rules used to design relational schemas that improve data quality, reduce redundancy, and avoid anomalies. Thes