DBMS Previous year question paper 2017 | HNBGU Second semester


HNBGU BCA Previous Question Paper 2017-18

  1. Explain DBMS in brief.

  2. Explain data independency with an example.

  3. Explain different keys in RDBMS with example.

  4. What do you mean by E-R diagram What is its importance in RDBMS?

  5. Explain Insert Update and Delete operations in SQL with an example

  6. Explain the concept of normalization with an example.

  7. What are the advantages of DBMS over file system?

  1. Explain the three levels of architecture of DBMS.

  2. Explain the RDBMS model and its component with an example.

  3. Explain the different commands for managing data in SQL with example.

  4. What are the different normal forms in RDBMS? Explain each normal form with an example in brief.

  5. Design an E-R diagram for Inventory system and explain cash entity in detail

  6. Write short notes on any three of the following

    1. BCNF
    2. Triggers and clusters
    3. DDL
    4. Unions and Intersection
    5. Key constraints