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
2079
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
Long Answer Questions.
What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?
What is entities and its types? How do we reduce different types of entities and relationships of ER diagram into Tables? Explain with assuming different types of entities and relations.
What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.
Section B
Short Answer Questions.
What do you mean by Schema and Instance in DBMS? Explain both with examples.
What is conflict schedule? Explain with example.
Retrieve the TName, and No_of_priod of teachers who teach in “ABC” school using Relational Algebra.
TEACHERÂ (TID, TName, TAddress, TQualification)
SCHOOL (SID, SName, SAddress, SPhone)
SCHOOL_TEACHER (SID, TID, No_of Period).
Explain aggregation with example.
Define functional dependencies. Explain 2nd normal form with example.
Explain Assertion and Triggers with example.
What is concurrency control? What are its advantages in DBMS?
What is Buffer Management in DBMS? Expalain.
What is transaction? Draw states of transaction and explain.