BBM 6th Semester
Database Management Board Question Paper 2023

Define data model.

Differentiate between simple and composite attribute.

List out any four aggregate function in SQL.

Define Atomicity and Durability properties of transaction management.

What is data quality management?

Explain any three roles and responsibilities of Database Administrator.

List and explain any three types of degree of Relationship set with example.

Describe how Database can be secure.

Explain different types of anomalies in database.

Explain the types of outer join with example.

a. Consider the following relation
Customer (CID, ACCOUNTNO, CNAME, ADDRESS, AGE)
Write SQL for the following queries.
i. Insert information of two customers in a table Customer.
ii. Display name and accountno of Customers whose name end with “e”
iii. Display the name and address of those customers who doesnot live in “Kathmandu”.
iv. Count the number of customers.
v. Display CID and age of those Customers whose age lies between 16 and 50. [5]
b. Consider a hospital system including Doctor (Did, dname, dspecialization, ddepartment), Nurse (nid, name, ndepartment) and patient (pid, pname, paddress) as entities. A doctor may treat many patients in the hospital. Nurse helps the doctor in treatment process. Draw the E-R model for above scenario assuming necessary constraints.

Normalize the following relation up to 3 NF.