Tribhuvan University
Bachelor of Computer Application
Semester 4 · TU Board 2024
Course Title: Database Management System (CACS255)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to answer the question in their own words as far as possible.
Group A
Group B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
Define database system. Write the merits and demerits of DBMS.
- 3.5
Draw and explain three schema architecture of the database system.
Answer comingAlso asked in 2022
- 4.5
What are an entity and its attributes? Write the difference between a strong and weak entity set with an example.
- 5.5
Why integrity constraints are used in databases? Explain different types of integrity constraints with examples.
- 6.5
What is functional dependency? Explain its types with examples.
- 7.5
Differentiate between discretionary access control and mandatory access control with example.
- 8.5
Write the ACID properties of transactions. Explain the concepts of serializability in database transactions.
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Why normalization is required in database? Explain the 1NF, 2NF and 3NF of normalization with example.
Answer comingAlso asked in 2022, 2020
- 10.10
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.
- 11.10
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".
— The End —