Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Credit:Eli TamangEli Tamang

Tribhuwan University

Institute of Science and Technology

2082

Bachelor Level / Second Year / Third Semester / Science

Bachelors in Information Technology (BIT202)

(Database Management System)

Full Marks: 60

Pass Marks: 24

Time: 3 Hours

Candidates are required to give their answers in their own words as for as practicable.

The figures in the margin indicate full marks.

Section A

Long Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
What is a transaction? Describe how lost update and dirty read problems occur in concurrent execution of transactions? Illustrate with examples. [10]
2.
What is the need for an ER diagram? Design an ER diagram that contains at least five entities. One of the entities must be a weak entity. There should be many to many relationships between the two strong entities. One of the entities should have derived and multi-valued attributes. Any one strong entity should have total participation in a relationship with another entity. Use your own assumptions as per required. [10]
3.
Why is normalization required? Define 1NF, 2NF and 3NF with suitable examples. [10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
Write SQL statements to create a table and update value in a table. Also mention the use of cascade on delete while creating the table. Use your own assumption for the table and update conditions. [5]
5.
How is the Group By Having clause used in SQL statements? Mention the syntax and example. [5]
6.
Describe the three schema architecture. How does the architecture create data independence? [5]
7.
What is database recovery? How can shadow paging be used for database recovery? [5]
8.
How data is stored and retrieved in NoSQL databases? Illustrate with examples. [5]
9.
What is two phase locking protocol? How can it lead to the deadlock condition? [5]
10.
Discuss the various types of constraints used on Extended ER Model. [5]
11.
What is the view? How can you create a view in SQL? Illustrate with an example. [5]
12.
Given following relations, write relational algebra statements for Person(Pid, pname, dob, paid) and Doctor(Did, pid, dname, dspeciality). a. Retrieving name of person who is doctor b. Retrieving all doctors whose speciality is pediatric. [5]