Database Management and Design – November 2012

Part – A

    1. What is cardinality?
    2. Define database approach?
    3. What are integrity constraints?
    4. Define generalization with an example.
    5. Give syntax and example for a view.
    6. Define Triggers.
    7. Discuss about QBE.
    8. Define data replication.
    9. What is consistency?
    10. What is modeling?

Part – B

Unit -I

  1. Describe the IS development and SDLC in detail.
    1. Explain the advantages of DBMS.
    2. Explain the traditional file processing systems.

Unit -II

  1. Discuss in detail about enhanced E-R model, with super type, subtype hierarchies and constraints.
  2. Explain relational model. Explain 1NF and 2NF in detail.

Unit -III

  1. Define middleware. What are procedures of give example?
  2. List out aggregate functions and explain three-tier architecture.

Unit -IV

    1. Define partitioning transparency.
    2. Discuss about building client applications.
  1. Give an over view of distributed databases

Unit -V

  1. Explain about DBMS selection and implementation.
  2. Explain about managing data quality and dictionary and repositories.

Attention : This exam questions are converted from the real exam paper to a digital text format by using an OCR Software that may made some mistakes, I reviewed it many times to correct it, But may still there some errors that I missed or misspelled, So if you detect an error or mistake PLEASE report by adding a comment or contact me.