MODEL PAPER
SECOND SEMESTER, M. Sc INFORMATION TECHNOLOGY

Paper - I (MIT - 201): Database and Distributed Computing

1. Question.


1. What do you understand by Abstract View of Data? Explain different levels of Abstractions.
2. What is Transaction? Explain transaction management.
2. Question.


1. What is E-R model? Construct the E-R model for:
   A Bank has Account holder identity by
   - Customer name Account number
   - Balance.
   A Branch of Bank identity by
   - Branch name
   - Branch asset.
   An account holder may have several Accounts at several Branches.
2. Explain Weak Entity Set.
3. Question.


1. Explain Relational model. How it is different from E-R model?
2. What is Relation Algebra? Explain basic operations of Relational Algebra.
4. Question.


1. What is View in SQL? Write syntax for creating view. What are the limitations of view?
2. Explain the aggregate functions like: sum(), avg() etc. What is embedded SQL
5. Question.


1. What is Integrity? Explain Referential Integrity. How it is implemented in SQL?
2. Explain functional dependency with example.
6. Question.


1. Explain the Normalization. Define Boyce-Cod Normal form.
2. What is Object Oriented Database System? Where it is used
7. Question.


1. Explain sporse and dense index. Write down the difference between indexing and hashing.
2. Define the distributed database system. How it is better than centralised database system?
8. Question.

Write short notes on the following: -

1. Store Procedure.
2. Database Administrator.
3. Data Dictionary.