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.
Tribhuvan University
Institute of Science and Technology
2078
Bachelor Level / fourth-semester / Science
Computer Science and Information Technology( CSC265 )
Database Management System
Full Marks: 60 + 20 + 20
Pass Marks: 24 + 8 + 8
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.
Short Answer Questions
Attempt any Two Questions (2 x 10 = 20)
What are different types of Database users and their roles? Explain the Data independence with example.
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.
Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?
Short Answer Questions
Attempts any Eight Questios (8 x 5 = 40)
What is difference between logical data independence and physical data independence?
Explain Relationship and Relationship sets with example.
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)
What is integrity? Explain different types of database integrity.
Define Functonal dependencies. Explain trival and non trival dependencies?
Explain the difference between “Join” and “Natural Join” of algebriac operations with example.
What is Checkpoints in database recovery? How does it help in database recovery? Explain.
Define schedule and serializability. How can you test the serializability?
Define Boyce-Codd normal form with example. How it is different that 3rd Normal form.