Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 4 · TU Board 2079
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
(2 × 10 = 20)
- 1.10
What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?
- 2.10
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.
- 3.10
What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.
Answer comingAlso asked in 2082, 2080, Model question
Group B
(8 × 5 = 40)
- 4.5
What do you mean by Schema and Instance in DBMS? Explain both with examples.
- 5.5
What is conflict schedule? Explain with example.
- 6.5
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).
Answer comingAlso asked in 2078
- 7.5
Explain aggregation with example.
- 8.5
Define functional dependencies. Explain 2nd normal form with example.
- 9.5
Explain Assertion and Triggers with example.
- 10.5
What is concurrency control? What are its advantages in DBMS?
- 11.5
What is Buffer Management in DBMS? Expalain.
- 12.5
What is transaction? Draw states of transaction and explain.
— The End —