Tribhuvan University
Bachelor of Business Administration
Semester 2 · TU Board 2024
Course Title: Database Management System (IT232)
Full Marks: 60Pass Marks: 30Time: 3 Hrs
Candidates are required to give their answers in their own words as for as practicable.
Group A
Brief Answer Questions(10 × 1 = 10)
- 1.1
Define Database Language.
- 2.1
Write a SQL statement for update operation.
- 3.1
What is unary Relationship?
- 4.1
List any four types of attributes in ER Model.
- 5.1
Define serializable schedule.
Answer comingAlso asked in Model question
- 6.1
What is big data?
Answer comingAlso asked in 2023
- 7.1
Define deferred data update.
Answer comingAlso asked in 2025, Model question
- 8.1
What is importance of creating view?
Answer comingAlso asked in 2025, 2023
- 9.1
State 3NF.
- 10.1
Define Roles.
Group B
Short Answer Questions: (Attempt any FIVE Questions)(5 × 3 = 15)
- 11.3
Describe shadow paging concept in brief.
Answer comingAlso asked in Model question
- 12.3
Who is DBA? List the roles of DBA.
- 13.3
Explain the concept of Time stamp ordering concurrency control techniques.
- 14.3
Illustrate how composite attribute is reduced into relational schema with example?
- 15.3
Explain constraints of generalization and specialization in ER model.
Answer comingAlso asked in Model question
- 16.3
What is the importance of database security?
Group C
Long Answer Questions: (Attempt any THREE Questions)(3 × 5 = 15)
- 17.5
Explain any four types of Database user.
- 18.5
How normalization helps to design good database? Explain second normal form with example.
- 19.5
Discuss any four constraints available in database with example.
- 20.5
Explain the Desirable Properties of Transaction.
Answer comingAlso asked in 2025, 2023, Model question
Group D
Comprehensive Answer / Case / Situation Analysis Questions(2 × 10 = 20)
- 21.10
Draw an ER diagram for Hospital management system with at least five entity set. Implement the concept of mapping cardinality and extended ER feature. Assume suitable attribute sets for each entity set.
- 22.10
Consider following relational database:
Car (reg_no, model, price, color) Person (pid, name, address, phone) owns_by(reg_no, pid, date)
Write SQL statement for the following: i) Insert a tuple {1, Ram Bdr, kathmandu} in person relation. ii) Display the model number with highest price. iii) Increase the price of each car by 15%. iv) Find name of person who owns red colored car. v) Display those records of car which model contains at most 4 characters.
— The End —