Database Management System

bbasemester 2

Introduction to DBMS, Types of DBMS, Data Models, Relational Database Model, Entity Relationship models, Structured Query Language, Distributed Database Management Systems, Database Security, and Designing Good Designed Database

semester photo

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions

Faculty of Management

2024

Bachelor in Business Administration

Database Management System

IT 202

Full Marks: 60

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

"Section A"

Brief Answer Questions :

[10*1=10]

Define Database Language.

Write a SQL statement for update operation.

What is unary Relationship?

List any four types of attributes in ER Model.

Define serializable schedule.

What is big data?

Define deferred data update.

What is importance of creating view?

State 3NF.

Define Roles.

"Section B"

Short Answer Questions : ( Attempt aby FIVE Questions )

[5*3=15]

Describe shadow paging concept in brief.

Who is DBA? List the roles of DBA.

Explain the concept of Time stamp ordering concurrency control techniques.

Illustrate how composite attribute is reduced into relational schema with example?

Explain constraints of generalization and specialization in ER model.

What is the importance of database security?

"Section C"

Long Answer Questions : ( Attempt any THREE Questions )

[3*5=15]

Explain any four types of Database user.

How normalization helps to design good database? Explain second normal form with example.

Discuss any four constraints available in database with example.

Explain the Desirable Properties of Transaction.

"Section D"

Comprehensive / Case/Situation Analysis Questions :

[2*10=20 ]

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.

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.