Database Management System (CSC265) 2079 BS Past Questions & Solutions

Tribhuvan University (TU) 2079 BS board exam question paper with verified step-by-step solutions for BSc CSIT Fourth Semester.

TRIBHUVAN UNIVERSITY

INSTITUTE OF SCIENCE AND TECHNOLOGY

2079 B.S.

Bachelor Level: B.Sc. CSIT

Semester: Fourth Semester

Subject: Database Management System (CSC265)

Full Marks: 60 / 80

Pass Marks: 24 / 32

Candidates are required to give their answers in their own words as far as practicable.

Group A

Long Answer Questions

Attempt any Two questions.

  1. 1
    What is Database Management System? Explain the DBMS architecture with diagram. What is data independence?
  2. 2
    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. 3
    What is normalization? Why normalization is required? Explain 1NF, 2NF and 3NF with example.

Group B

Short Answer Questions

Attempt any Eight questions.

  1. 4
    What do you mean by Schema and instance in DBMS? Explain both with example.
  2. 5
    What is conflict schedule? Explain with example.
  3. 6
    Retrieve the TName, and No_of_period 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)
  4. 7
    Explain aggregation with example.
  5. 8
    Define functional dependencies. Explain 2nd normal form with example?
  6. 9
    Explain Assertion and Triggers with example.
  7. 10
    What is concurrency control? What are its advantages in DBMS?
  8. 11
    What is Buffer Management in DBMS? Explain.
  9. 12
    What is transaction? Draw states of transaction and explain.