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

2023

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 Data Model.

Write SQL statement to delete student table.

Differentiate between simple composite attribute.

List the types of mapping constraints in ER Model.

Write a syntax for check constraint SQL.

Define Transaction.

What is NoSQL?

Define big data.

State 1NF.

Why level of abstraction is maintained in database?

"Section B"

Short Answer Questions : ( Attempt aby FIVE Questions )

[5*3=15]

Describe two phase locking mechanism in brief.

What are the types of database user? Explain each of them in brief.

Explain briefly the importance and methods of Database recovery.

Explain the importance of Creating view with syntax.

What is Database security? How Database is secured? Explain in brief.

What is importance of normalization? Explain with example.

"Section C"

Long Answer Questions : ( Attempt any THREE Questions )

[3*5=15]

Identify and explain different types of database languages with example.

Explain the desirable properties of Transactions.

Explain any five aggregate function used in SQL with syntax.

When generalization and specialization is used in ER model? Support your answer with example.

"Section D"

Comprehensive / Case/Situation Analysis Questions :

[2*10=20 ]

Employee works on the project under one or more project manager for the company. Client pays for the project that is being developed by the company and client provide the feedback for the project.

Draw ER diagram for the above scenario.

Consider following relational database:

Account(ac_no, type, balance, branch)
Customer(cid, name, address, phone_no, dob)
Depositer(ac_no, cid, date)

Write SQL statement for the following:
i) Insert a tuple {1001, checking, 30000} in Account relation.
ii) Delete those accounts which haven't owns any customer.
iii) Change the phone_no of Ram to 11111111.
iv) Find name of customer who owns an account with balance greater than 2000.
v) Display those records of customers whose name starts with "R" and end with "A".