TRIBHUVAN UNIVERSITY
INSTITUTE OF SCIENCE AND TECHNOLOGY
2079 B.S.
Candidates are required to give their answers in their own words as far as practicable.
Group A
Long Answer QuestionsAttempt any Two questions.
- 1What is Database Management System? Explain the DBMS architecture with diagram. What is data independence?
- 2What 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.
- 3What is normalization? Why normalization is required? Explain 1NF, 2NF and 3NF with example.
Group B
Short Answer QuestionsAttempt any Eight questions.
- 4What do you mean by Schema and instance in DBMS? Explain both with example.
- 5What is conflict schedule? Explain with example.
- 6Retrieve 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)
- 7Explain aggregation with example.
- 8Define functional dependencies. Explain 2nd normal form with example?
- 9Explain Assertion and Triggers with example.
- 10What is concurrency control? What are its advantages in DBMS?
- 11What is Buffer Management in DBMS? Explain.
- 12What is transaction? Draw states of transaction and explain.