BCA 4th Semester
Database Management System Board Question Paper 2024

Define database system. Write the merits and demerits of DBMS.

Draw and explain three schema architecture of the database system.

What are an entity and its attributes? Write the difference between a strong and weak entity set with an example.

Why integrity constraints are used in databases? Explain different types of integrity constraints with examples.

What is functional dependency? Explain its types with examples.

Differentiate between discretionary access control and mandatory access control with example.

Why normalization is required in database? Explain the 1NF, 2NF and 3NF of normalization with example.

How participation constraints are used in ER diagram? Explain. Also Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars and has one or more premium payments associated with it. Each payment is for a particular period and has an associated due date, and the date when the payment was received.

Consider the following employee database, where primary keys are underlined Supplier (supplier-id, supplier-name, city) Suppliers (Supplier-id, parts-id, quantity) Parts (part-id, par-name, color, weight)
a) Write a SQL query to create above table.
b) Find the name of all suppliers who has supplied parts with quantity more than
100 and the name of all parts supplied by "RD Traders"
c) Find the number of parts supplied by "S02"
d) Find the name of suppliers located in city "KTM".