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
2076
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.
Section A
Attempt any Two questions(2 x 10 = 20)
What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.
What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.
What is normal form? Explain their types. Explain about loss-less join decomposition.
Section B
Short Answer Questions(8 x 5 = 40)
What is data abstraction? What are three levels of data abstraction? Explain.
What is difference between Entities and Entity sets? Explain with example.
Create two table Courses (CID, Course, Dept) and HoD (Dept, Head) using SQL language with all constraints [Primary key, Foreign key and Referential Integrity]. Assume the types of attributes by your own.
Differentiate between Integrity and Security with example.
Define schedule and serializability. How can you test the serializability?
What is Granularity of data items? How does it effect in concurrency control?
Explain 2 phase locking technique in brief.
What are the different approaches of Database recover? What should log file maintain in log-based recovery?
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key?