CS-06: Database Management System June 2003 Question Paper

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

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 

June, 2003
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). XYZ Bank offers 5 types of accounts, namely Savings, Recurring, Loan, Current and Money market It operates a number of branches and a client of the Bank can have any number of accounts, can be individual and joint Identify the entities of your interest and show their attributes. What relationships exist among these entities? Draw the corresponding E-R diagram. Also design a relation data base to the relational database to the above E-R diagram.

(b) Discuss the differences between the following file organisations:
(i) Sequential
(ii) Indexed sequential
(iii) Relative file organisation
(iv) Multikey file organisation

Compare their storage and access efficiencies. Also mention what kind of application is best suited for the above file organisations.

(c) Define 3NF. Explain why the “employee” relation in the following database does not satisfy 3NF and decompose it into relations that satisfy 3NF. What ait the advantages gained by this decomposition .

Q2. Write short notes on:

(i) Updation, Insertion, Deletion anomalies

(ii) Views

(b) A view can be created for a subset of the tuples of a relation, as in this example. For assigning employees to particular jobs, the manager requires a list of the employees who have not been assigned to any jobs.

(iii) Boyce-Code Normal Form (BCNF)

Q.3(a). What is Data Replication? Explain with the help of example. Discuss the advantages/disadvantages of data replication in the distributed data base system.

(b) Discuss the different approaches to design of object oriented database system.

Q.4(a). What is client/server computing ? Why do we need it ? Discuss its advantages.

(b) Discuss the various components involved in the client/server computing.

Q.5(a). Discuss key features of B-Trees and B+ Trees. Also comment on the relative advantages and disadvantages. Mention the use of them by giving an example for each.

(b) List 4 responsibilities of Database Manager. For each responsibility, explain those problems that would arise if the responsibilities were not met.

Q.6. Discuss the following knowledge Representation Schemes:
-- This question (Q.6) is not complete --