Database Management and Design – May 2012

Part – A

    1. List the range of Database Applications.
    2. What is cardinality?
    3. Define specialization and generalization.
    4. What are integrity constraints?
    5. Define Client / Server Architecture.
    6. Give syntax and example for a view.
    7. Discuss about QBE.
    8. What is OLE?
    9. What is consistency?
    10. How to do backup for databases?

Part – B

Unit -I

  1. Describe the IS Development and SDLC in detail.
    1. Explain the advantages of DBMS over traditional file processing system.
    2. Briefly discuss about E-P model.

Unit -II

  1. Discuss in detail about Enhanced E-R model, with supertype, subtype hierarchies and constraints.
  2. With the help of examples discuss about I NF, II NF and III NF.

Unit -III

  1. Explain about the various Relational Algebra Operators with examples.
    1. Write notes on Aggregate function and processing multiple tables in SQL.
    2. What are procedures ? Give example.

Unit -IV

    1. Discuss about Building Client Applications.
    2. Write notes on ActiveX controls and Embedded SQL.
  1. Give an overview of Distributed databases.

Unit -V

  1. Describe the role of a Database Administrator with his functions.
  2. Explain about DBMS selection and Implementation.

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.