(b) Whai are the advantages of index-sequential file organisation ? With the help of an example explain the structure of index-sequential file
(c) Why are remote procedure calls used ? Why is a set of DDE mainiained at application level ?
(d) Design an ER diagram for any of IGNOU's study centres. Clearly indicate the entities, attributes, relationships and the key constraints.
(e) With the help of two examples for each, explain the use of multimedia databases and knowledge databases.
Q.2. (a) Consider an employee file with the details given below:
| Record | E# | Name | Occupation | Degree | Sex | Location | Salary |
| A | 800 | Milind | Prog. | ME | M | Delhi | 10,000 |
| B | 510 | Adwet | Analyst | BE | M | Mumbai | 15,000 |
| C | 200 | Devendra | Analyst | BE | M | Delhi | 12,000 |
| D | 300 | Mukesh | Prog. | ME | M | Chennai | 9,000 |
(i) Make a multi list representation of this employee file
(ii) Write a query to retrieve the record of Salary > 12,000, Degree
= M.E., Location = Delhi, Occupation = Analyst, Sex = M.
(b) What are the main features of client-server model ? Explaint he stages involved in the development of an application using this model.
Q.3. (a) Why is the administration of a database system required ? What are the various functions associated with database administration?
(b) Define a data manipulation language.Write a syntax for the following and give an example for each:
(i) Select statement
(ii) Update statement
(iii) Delete statement
(iv) Insert statement
Q.4. (a) With the help of an example relation and the dependency diagram, explain ihe concept of functional dependency.
(b) Explain the following tools with respect to client-server environment:
(i) Dynamic data exchange
(ii) Object linking and embedding
Also mention the usage of these with an example for each.
Q.5. (a) Consider the schema given below:
Branch-scheme (Branch-name, asset, Branch-city)
Customer-scheme (Customer name, street, customer-city)
Deposit-scheme (Branch-name, account-number, customer-name, balance)
Borrow-scheme (Branch-name. loan-number, customer-name, amount)
Client-scheme (Customer-name, banker-name).