Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 4 · TU Board 2078
Course Title: Database Management System (CSC265)
Full Marks: 60Pass Marks: 24Time: 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.
Attempt any Two Questions (2 x 10 = 20)
- 1.
What are different types of Database users and their roles? Explain the Data independence with example.
- 2.
What are the components of ER diagram? Explain the function of various symbols use in ER diagram. Construct an ER diagram to store data in a library of your college.
- 3.
Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?
- 4.
What is difference between logical data independence and physical data independence?
- 5.
Explain Relationship and Relationship sets with example.
- 6.
Retrive the TName, SName, SPhone for "ABC" school using SQL from given relation as below.
TEACHER (TID, TName, TAddress, TQualification) SCHOOL (SID, SName, SAddress, SPhone) SCHOOL_TEACHER (SID, TID, No_of Period)Answer comingAlso asked in 2079
- 7.
What is integrity? Explain different types of database integrity.
- 8.
Define Functonal dependencies. Explain trival and non trival dependencies?
- 9.
Explain the difference between "Join" and "Natural Join" of algebriac operations with example.
- 10.
What is Checkpoints in database recovery? How does it help in database recovery? Explain.
- 11.
Define schedule and serializability. How can you test the serializability?
Answer comingAlso asked in 2076
- 12.
Define Boyce-Codd normal form with example. How it is different that 3^rd Normal form.
— The End —