Tribhuvan University
Bachelor of Business Management
Semester 6 · TU Board 2023
Course Title: Database Management (COM312)
Full Marks: 40Pass Marks: 20Time: 2hrs
Candidates are required to give their answers in their own words as for as practicable.
Group A
Brief Answer Questions(5 × 1 = 5)
- 1.1
Define data model.
- 2.1
Differentiate between simple and composite attribute.
- 3.1
List out any four aggregate function in SQL.
- 4.1
Define Atomicity and Durability properties of transaction management.
- 5.1
What is data quality management?
Group B
Short Answer Questions(5 × 3 = 15)
- 6.3
Explain any three roles and responsibilities of Database Administrator.
- 7.3
List and explain any three types of degree of Relationship set with example.
- 8.3
Describe how Database can be secure.
- 9.3
Explain different types of anomalies in database.
- 10.3
Explain the types of outer join with example.
Group C
Analytical Questions(2 × 10 = 20)
- 11.10
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.
- 12.10
Normalize the following relation up to 3 NF. D-IDD-NameE-IDE-NameAddressContact noD01HRME01RamKTM9841,5560D02FinanceE02ShyamPKH9841,5573D01HRME03HariBRT98510,2374D03CRME04SitaBKT9830,9880
— The End —