Test Papers / Previous Question Papers of IGNOU CS06 Database Management System June 2006

Time: 3 hours
Maximum Marks: 75

Note: (1) Question no. 1 is compulsory. Attempt any three questions from the rest

1. (a) With the help of a suitable example, explain a hierarchical database model. (7)

(b) Whai are the advantages of index-sequential file organisation ? With the help of an example explain the structure of index-sequential file (5)

(c) Why are remote procedure calls used ? Why is a set of DDE mainiained at application level ? (5)

(d) Design an ER diagram for any of IGNOU's study centres. Clearly indicate the entities, attributes, relationships and the key constraints. (8)

(e) With the help of two examples for each, explain the use of multimedia databases and knowledge databases. (5)

2. (a) Consider an employee file with the details given below: (8)

(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. (7)

3. (a) Why is the administration of a database system required ? What are the various functions associated with database administration? (5)

(b) Define a data manipulation language.Write a syntax for the following and give an example for each: (10)

(i) Select statement
(ii) Update statement
(iii) Delete statement
(iv) Insert statement

4. (a) With the help of an example relation and the dependency diagram, explain ihe concept of functional dependency. (8)

(b) Explain the following tools with respect to client-server environment: (7)

(i) Dynamic data exchange
(ii) Object linking and embedding

Also mention the usage of these with an example for each.

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)

Write the SQL statements for the following : (8)

(i) Find all customers who have a balance of over Rs. 1000.
(ii) Write the query to find the clients of banker Patel, and the city they live in.
(iii) Write a statement o find all the customers who have a loan amount of more than Rs. 1200
(iv) Write a statement to find all the customers whose name starts with "R" and who have a balance of more than Rs. 10,000.

(b) With the help of an example, explain the properties of a Balanced sort tree. (7)