Question 1) Fill in the blanks:
a) In the hierarchical model data is stored in the form of..........
b) An .......... is a property of an entity that differentiates it from other entities and provides information about the entity.
c) The data base models can be broadly classified into record based model and .......... object based model.
d) .......... is the process of efficiently organizing data in a database.
e) A .......... is a constraint between two sets of attributes in a relation form a database.
f) A .......... is a procedural code that is automatically executed in response to certain events on a particular table or view in a database.
g) The .......... is a distributed application architecture that partitions tasks or workloads between service providers and service requesters, called clients.
h) PGA stands for..........
i) RDBMS stands for..........
j) The ascending order of a data hierarchy is..........
k) Answer the following questions.
Question 2) Briefly explain the three levels of data abstraction?
Question 3) Describe indexed file organization?
Question 4) Describe hierarchical model?
Question 5) Describe Relational database structure and terminology?
Question 6) What do you mean by DBMS? What are the advantages of DBMS?