Skip to content
CampusPrep
IT-405 · Data Base Management System/Unsolved PYQ Paper

DATABASE MANAGEMENT SYSTEM - NOV 2022 Question Paper

  1. Unit 1
    7 Marks
    aDifferentiate between DBMS and Traditional file storage system.
  2. Unit 1
    7 Marks
    bConstruct an E-R diagram for a hospital with set of patients and set of medical doctors. Associated with each patient a log of the various tests and examination conducted. Map your E-R diagram to relational model.
  3. Unit 2
    7 Marks
    aDifferentiate between data definition language and data manipulation language.
  4. Unit 2
    2 Marks
    iConsider the following schema for institute library: Student (Roll No, Name, Father-Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of-Issue) Write the following queries in relational algebra: i) List Roll Number and Name of all students of the branch 'CSE'.
  5. Unit 2
    2 Marks
    iiConsider the following schema for institute library: Student (Roll No, Name, Father-Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of-Issue) Write the following queries in relational algebra: ii) Find the name of students who have issued a book published by 'ABC' publisher.
  6. Unit 2
    2 Marks
    iiiConsider the following schema for institute library: Student (Roll No, Name, Father-Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of-Issue) Write the following queries in relational algebra: iii) List title of all books and their author's issued by a student 'XYZ'.
  7. Unit 2
    1 Marks
    ivConsider the following schema for institute library: Student (Roll No, Name, Father-Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of-Issue) Write the following queries in relational algebra: iv) List all books published by publisher 'ABC'.
  8. Unit 2
    7 Marks
    aExplain the terms: CANDIDATE KEY, PRIMARY KEY, SUPER KEY and COMPOSITE KEY.
  9. Unit 2
    7 Marks
    bWhat are the various characteristics of SQL? Discuss five aggregate functions with a suitable example.
  10. Unit 2
    7 Marks
    aDiscuss the selection, projection and join operator of relational algebra with suitable example.
  11. Unit 2
    7 Marks
    bDiscuss the various features of relational data model in detail.
  12. Unit 3
    7 Marks
    aWhat is Normalization of data? Explain 1NF, 2NF and 3NF with example.
  13. Unit 3
    7 Marks
    bDefine Functional dependency. What do you mean by Loss‑Less Decomposition? Explain with a suitable example how function dependencies can be used to show that decompositions are loss-less.
  14. Unit 1
    7 Marks
    aExplain Aggregation and Specialization with example.
  15. Unit 4
    7 Marks
    bState the condition for the two schedules to be equivalent. Define a serializabile schedule.
  16. Unit 4
    7 Marks
    aWhat is Transaction? Draw a state diagram of a transaction showing its states. Explain ACID properties of a transaction with suitable examples.
  17. Unit 4
    7 Marks
    bExplain in brief working of two-phase locking protocol. Explain with the help of example of a schedule, how this protocol ensures a schedule to be conflict serializable, but not cascade-less?
  18. Unit 5
    7 Marks
    aWhat is RAID in DBMS? Explain it with its types.
  19. Unit 5
    7 Marks
    bWhy the hashing techniques are required in DBMS? Explain any one of the technique with example.
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in