June 2009 CS-06 DATABASE MANAGEMENT SYSTEM Question Paper

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

---

BACHELOR IN COMPUTER APPLICATIONS

Term-End Examination 

June, 2009

 CS-06:DATABASE MANAGEMENT SYSTEM

Time : 3 Hours

Max. Marks : 75

---

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

---

1. (a) A publishing company produces academic books on various subjects. Books are written by authors who specialise in one or more particular subjects. The company employs a number of editors who do not have particular specialisations but who take sole responsibility for editing one or more publications. A publication (i.e Book) covers a single subject area, but may be written by one or more authors- the contribution each author is recorded as a percentage for the purposes of calculating royalities.
On the basis of this case attempt the following questions:
(i) Design an ERD for the above case.
(ii)Assume the following changes to the specification:
An author can develop a publication covering more than one subject area and that the schema must be able to store the percentage of the pages concerned with each of the subjects.
Modify your ERD to reflect the above changes. [10 marks]
(b) What is a Knowledge Base System? Explain its various componenets. How does a KBS differ from Database System? Give at least five differences.[10 marks]
(c) Explain the process of normalization. What is the differences between Third Normal Form and BCNF. Consider the following database relation.
ClientRental(clientNo, propertyNo, CName, pAddress, rentstart, rentFinish, rent, ownerNo, Oname) with following functional dependencies
clientNo, property No→renstart, rentFinish
clientNo→Cname
property No→pAddress, rent, ownerNo, OName with the Primary Key(clientNo,PropertyNo)
Find the normal form in which the relation client Rental is.

2. (a) Explain "program-data-independence" in a DBMS. [4 marks]
(b) What are CODD's Rule? Explain "The View Updating Rule" and "The physical Independence Rule". [5 marks]
(c) Explain the advantages and disadvantages of data distribution in Distributed Databases. [6 marks]

3. (a) What is Index Sequential File Organisation? Explian the Primary, Clustering, Secondary and Multilevel Indexing Schemes. [10 marks]
(b) What are Views? What is the syntax for creating views? Explain the advantages and disadvantages of views. [5 marks]

4. (a) Consider the functioning of an institute where Director is the Head of Institute and Two Deans, one Administrative Dean, another academic Dean. The institute is organised into Departments, where each Department has an H.O.D who supervises the faculty memebers. Create a Hierarchial Database model for above specifications and show how data will be stored in it.
(b) Compare Network Model with Hierarchial Model. Mention atleast three differences. [3 marks]
(c) What is the difference between data and knowledge. How DBMS are different from Knowledge Based systems. [5 marks]

5. Consider the following three relations:
EMPLOYEE(Emp_name, Dept_no, Salary, Emp_id, Emp_supervise)
DEPARTMENT(Dept_no, Dept_name, Manager_id)
DEPENDENT(Dependent_name, Dependent-id, Emp_id)
Write Relational Algebra statements for the following:
(a) Select tuples for all employees who either work in Dept_no 10 and get annual salary of more than 80,000/- or work in Dept_no 12 and get annual salary more than 90,000/-.
(b) Retrieve the name salary of all employees who work in Dept-no 10.
(c) Retrieve the id of all employees who work in Dept-no 10 and whose supervisor is name is "John".
(d) Retrieve the name of the manager of each department.
(e) Retrive the name of employees who have no dependents.