Database Management System 2024

Group B

Attempt any SIX questions.

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 differences between a strong and weak entity set wiith an examples.

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.

Write the ACID properties of transactions. Explain the concepts of serializability in database transactions.

Group C

Attempt any TWO questions.

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 customer 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, 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 10.

c) Find the name of all parts supplied by "RD Traders"

d) Find the number of parts supplied by "SO2".

e) Find the name of all suppliers located in the city "KTM".