CS-06 June, 2005 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2005 QUESTION PAPER

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 

June, 2005

 CS-06:DATABASE MANAGEMENT SYSTEM

Time : 3 Hours

Max. Marks : 75

---

Note : Question one is compulsory. Answer any three from the rest.

---

Q.1 (a) Suppose you have been designated as a database administrator of an organization. Describe the responsibilities that may be generally assigned to you in order to maintain the centralised database efficiently. Also include at least 2 responsibilities with respect to the Database security.

(b) Create an ER diagram for the loan management system of a finance company. Loans are given on the purchase of various items with different interest rates. The company keeps track of defaulters and takes appropriate steps against them. Make, and state, suitable assumptions (if any).

(c) Explain the three-level architecture of DBMS, including the diagram. How is the mapping between these levels achieved?

(d) Explain the evolution of Client/Server Architecture. List the components and the usage in Client/Server computing. Mention any two applications of this model.

Q.2(a) What is a knowledge based system? Mention any two advantages and disadvantages of it. Give any two examples where a knowledge based system is used. Discuss the rule based knowledge representation scheme with the help of an example.

(b) What are the problems caused by data redundancies? Can data redundancies be completely eliminated when a database approach is used? Explain this with the help of an example.

Q.3(a) Write the significance of the evaluation of a database management system. List the technical and administrative issues respectively, required to be taken care of by the evaluation team.

(b) Draw a diagram to illustrate the relationship of different file organizations based on an access key. What is direct file organization? Explain the role of hashing in direct file organization with the help of an example.

Q.4(a) Consider the following schema :

employee (eno, ename, address, city, basic_sal, jobstatus)
projects (p_no, pname, pcategory)
work_in (P_no e _no p_duration)

Write appropriate SQL queries for the following :

(i) Display the names of employees who are working in a project on “DBMS".
(ii) Find the employer number of all employees who are working on at least one project.
(iii) Find the average salary of all employees working in a project “based in Delhi".

(b) Descrihe any three differences between the object oriented data model and the relational data model. In what ways is the object oriented data model similar to the hierarchical and network data models? Mention any two examples in which we can use the object oriented databases and relational databases, with the proper justification.

Q.5(a) Explain the trade-offs in distributing the database. List the issues involved in storing the relations in the distributed databases.

(b) What are the different relational operators used in relational algebra? Consider the following relations A and B, and perform A u B, A n B and A-B.

A-Flight No. Airways
IC 2715 Indian Airlines
IC 1007 Jet Airways
IC 9119 Sahara
IC 3849 Indian Airlines

B-Flight No. Airways
IC 1007 Jet Airways
IC 5187 Cathay Pacific
IC 1003 Singapore Airlines

Relational operators used in relational algebra:-