BIT Database Management System

bitsemester 3

The course covers the basic concepts of databases, database system concepts and architecture, data modeling using ER diagram, relational model, SQL, relational algebra and calculus, normalization, transaction processing, concurrency control, and database recovery.

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Institute of Science and Technology

2079

Bachelor in Information Technology

Database Management System

BIT202

Full Marks: 60

Pass Marks: 24

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"

Long Answer Questions Attempt any TWO questions.

[2 × 10 = 20]

What is Transaction? Draw a Transaction state diagram and discuss the typical state that a transaction goes through during execution.

[2 + 8]

What is a functional dependency? What are the four informal measures of quality for relational schema design? Explain.

[3 + 7]

Explain the various Symbols used in E-R Model?

[10]

"Section B"

Short Answer Questions Attempt any EIGHT questions.

[8 × 5 = 40]

What is NoSQL? Explain the NOSQL characteristics related to data models and query languages.

[1 + 4]

What is the system log used for? What are the typical kinds of entries in a system log?

[2 + 3]

What is normalization? Explain 2NF with example.

[1 + 4]

What is meant by the concurrent execution of database transactions in a multiuser system? Discuss why concurrency control is needed, and give informal examples.

[5]

Retrieve the Employee Name, Department Number and Department Name of "John Smith" using Relational Algebra. The relations are given below.

a. EMPLOYEE ( Ssn, Fname, Lname, Bdate, Address, Sex, Salary, SuperSSN, Dno)

b. PROJECT ( Pnumber, Pname, Plocation, Dnum )

c. WORKS ON ( Essn, Pno, Hours )

d. DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr Start date)

[5]

Discuss the different types of failures. What is meant by catastrophic failure?

[2 + 3]

What is Relational Data model? How Relation is different than Flat file?

[2 + 3]

What is Database? Explain the characteristics of Database Approach.

[1 + 4]

What are the three layers of the Three-Schema Architecture? Explain.

[5]

BIT Database Management System

BIT Semester 3 Database Management System Question Paper 2079 – Solved

Institute of Science and Technology