BIT 3rd Semester
Database Management System Board Question Paper 2083

Views: ...
BIT 202-2083 ✡

Tribhuvan University

Institute of Science and Technology

TUpapers.com TUpapers.com
Bachelor Level/Second Year/Third Semester/Science
Bachelors in Information Technology (BIT 202)
(Database Management System)
Full Marks: 60 Pass Marks: 24 Time: 3 hours

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.
[2x10=20]
1.

Consider the following simple database schema and write SQL statements for each of the following:

Student(SID, SName, City, Faculty)
Course(CID, CName, Credits)
Enrollment(SID, CID, Grade)

a. Use CREATE TABLE statement to create Student, Course and Enrollment table assuming appropriate data types for attributes.
b. Insert a new student: SID=10, SName='Aarav', City='Pokhara', Faculty='BIT'.
c. List the names of all students who are from 'Kathmandu'.
d. Find the names of all students enrolled in the course named 'Database'.
e. Update address of student to Kathmandu having SID = 10.

2.

Define entity, attribute and relationship with suitable example. Design a complete ER diagram for the following scenario:

Scenario: A school has teachers and students. Each teacher has a teacher_id (unique), name, and subject. Each student has a student_id (unique), first name, last name, and date of birth (age is derived). A student can have multiple phone numbers. A teacher teaches many students, and a student can be taught by many teachers. Each teaching relationship records the academic year.

3.

Explain transaction and ACID properties of a transaction in brief. What are different states of a transaction? What is a 'serial schedule' and why it is always considered correct?

Section B

Attempt any Eight questions

[8×5=40]
4.

What is a Database Management System? List any 5 advantages of using a DBMS over a traditional file-based system. Give one real-life example of a DBMS application.

5.

Explain the Three-Schema Architecture of a DBMS with diagram. Differentiate between logical data independence and physical data independence with one example each.

6.

What is a weak entity type? Give one suitable example of a weak entity with a diagram showing the weak entity, its owner entity, the identifying relationship, and the partial key.

7.

Define Domain Constraint and Referential Integrity Constraint. What happens when a DELETE operation violates referential integrity?

8.

Explain two phase locking protocol. How can we detect deadlock in transaction?

9.

What is functional dependency? Define First Normal Form (1NF) with suitable example.

10.

What is concurrency control and why is it needed? Differentiate between shared lock (S-lock) and exclusive lock (X-lock).

11.

What is database recovery? Explain shadow paging technique with suitable diagram.

12.

Write short notes on:
a. NoSQL Database
b. Database Users