Database Management and Design – December 2014

Part – A

    1. What is database analysis
    2. Define SDLC.
    3. What is super type?
    4. What are business rules?
    5. Define SQL.
    6. Define middleware.
    7. What is VBA?
    8. Define concurrency.
    9. How to do backup for databases?
    10. Define database administrator.

Part – B

Unit -I

  1. Explain the following terms:
    1. Entities
    2. Attributes
    3. Relationships.
  2. Explain IS development.
  3. Explain traditional file processing system.

Unit -II

  1. What is normalization? Explain 2NF in detail.
  2. Explain transforming EER diagrams into relations.

Unit -III

  1. Explain about the various relational algebra operators with examples.
  2. Explain the following terms:
    1. View definition
    2. Transaction integrity

Unit -IV

  1. Explain the following terms:
    1. COM
    2. Data Replication
  2. Explain OLE and COM in detail.

Unit -V

  1. Explain about DBMS functions and capabilities.
  2. 11 Explain modeling and planning for databases.

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.