1) Explain the three schema architecture. Why do we require mapping between schema levels? How do various schema definition languages suppose this architecture?
2) What are the various kinds of database end users? Explain the major activities of each.
3)(a) Explain the characteristics of a data warehouse. Divide them into functionality of a warehouse and advantageous users derive from it.
(b) What do you mean by data allocation in distributed database design? What typical units of data are distributed over sites?
4)(a) What do you mean by an entity type? What is an entity set? Describe the difference among an entity, an entity type and an entity set.
(b) Describe various constraints in relational model.
5)a) Compare Hierarchical and Network model.
(b) Describe object oriented database in detail.