Database Management and Design – December 2011

Part – A

    1. Discuss about three-tired architecture.
    2. What is the degree of a relation ?
    3. Define specialization.
    4. What is normalization ?
    5. Define foreign key.
    6. Write syntax and give example for a query in tuple relational calculus.
    7. Give an example query in query by example.
    8. Define OLE.
    9. What do you mean by tuning the database ?
    10. Explain about data dictionary.

Part – B

Unit -I

    1. Describe the steps involved in SDLC.
    2. Discuss about three schema architecture.
    1. What are the cost and risks in DBMS ?
    2. Explain about ER-Model.

Unit -II

  1. What is an enhanced ER model ? Discuss in detail.
  2. How to convert EER diagrams into relations ? Discuss with suitable examples.

Unit -III

  1. Write notes on U, ^, x, ∞ and ÷ operators of relational algebra with examples.
  2. Explain about triggers, functions and procedures with examples.

Unit -IV

    1. Briefly discuss about COM and active X controls.
    2. Write notes on building Internet database servers.
  1. Describe replication, partitioning and concurrency in distributed databases.

Unit -V

  1. Explain about DBMS functions and capabilities and future requirements.
  2. Discuss about the functions of database administrator in detail.

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.