BACHELOR IN COMPUTER APPLICATIONS

Term-End Examination

June, 2006

CS-O6 : DATABASE MANAGEMENT SYSTEM

Time :3 hours Maximum Marks : 75

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

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

(b) What 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 maintained 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 (8)

below : -

Record E#    Name     Occup.   Degree    Sex     Location     Salary

A      800     Milind     Prog.        M.E.       M       Delhi       10,000

B      510     Adwet      Analyst    B.E.       M       Mumbai      15,000

c      200     Devendra   Analyst   B.E.       M       Delhi       72,OO0

D     300      Mukesh   Prog.        M.E.       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 ? Explain the 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 the 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 to 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)