Tribhuvan University
Bachelor of Information Technology
Semester 3 · TU Board 2079
Course Title: Database Management System (BIT202)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
Group A
Attempt any Two questions.(2 × 10 = 20)
- 1.10
What is Transaction? Draw a Transaction state diagram and discuss the typical state that a transaction goes through during execution.
- 2.10
What is a functional dependency? What are the four informal measures of quality for relational schema design? Explain.
- 3.10
Explain the various Symbols used in E-R Model?
Answer comingAlso asked in 2078
Group B
Attempt any Eight questions(8 × 5 = 40)
- 4.5
What is NoSQL? Explain the NOSQL characteristics related to data models and query languages.
- 5.5
What is the system log used for? What are the typical kinds of entries in a system log?
- 6.5
What is normalization? Explain 2NF with example.
Answer comingAlso asked in 2080
- 7.5
What is meant by the concurrent execution of database transactions in a multiuser system? Discuss why concurrency control is needed, and give informal examples.
- 8.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)
Answer comingAlso asked in 2080, 2078
- 9.5
Discuss the different types of failures. What is meant by catastrophic failure?
- 10.5
What is Relational Data model? How Relation is different than Flat file?
- 11.5
What is Database? Explain the characteristics of Database Approach.
- 12.5
What are the three layers of the Three-Schema Architecture? Explain.
— The End —