Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 4 · TU Board 2076
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.
Group A
Attempt any Two questions(2 x 10 = 20)(2 × 10 = 20)
- 1.10
What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.
- 2.10
What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.
- 3.10
What is normal form? Explain their types. Explain about loss-less join decomposition.
Group B
(8 × 5 = 40)
- 4.5
What is data abstraction? What are three levels of data abstraction? Explain.
- 5.5
What is difference between Entities and Entity sets? Explain with example.
- 6.5
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.
- 7.5
Differentiate between Integrity and Security with example.
- 8.5
Define schedule and serializability. How can you test the serializability?
Answer comingAlso asked in 2078
- 9.5
What is Granularity of data items? How does it effect in concurrency control?
- 10.5
Explain 2 phase locking technique in brief.
- 11.5
What are the different approaches of Database recover? What should log file maintain in log-based recovery?
- 12.5
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key?
— The End —