Introduction to DBMS CS-06 Question Paper December, 2008

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2008 QUESTION PAPER

---

BACHELOR IN COMPUTER APPLICATIONS

Term-End Examination 

December, 2008

 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 chemical testing laboratory has several chemist who work on one or more projects. Chemists may have a varety of equipment on each project. The laboratory management wants to record the requipment issue date when given equipment item is assigned to a particular chemist working on a specified project. A chemist must assigned to atleast one project and one equipment item. A given equipment item need not be assigned and a given project need not be assigned either a cemist or an equipment item. Design and draw an ER diagrm, clearly indicating the entities, attriutes, keys, the cardinality and participation constraints.
Note: Make necessary assumptions. [10 marks]
(b) What is CODD's Rules ? Explain the Integrity Rule and the View Updating Rule. [5 marks]
(c) Describe the Client/Server Architecture and its main components. Explain its need and advantages. [5 marks]
(d) Write syntax of the following SQL commands. Provide an example of each:

* CREATE
* ALTER
* REPLACE
* DELETE
* INSERT

[10 marks]

2. (a) Draw and explain the three-level architecture of a Database Management System. [5 marks]
(b) Describe the JOIN operations and its various types with the help of examples. [5 marks]
(c) Compare Relational Database Management System with Object Oriented Database Management System. [5 marks]

3. (a) What is meant by Distributed Computing Environment ? What are the three possible metods by which we can integrate the disributed RDBMS applications. [5 marks]
(b) Explain the problems of database inconsistency and redundancy of data. How can this problem be solved in the relational model. Support your answer with an example. [5 marks]
(c) Explain atleast five responsibilities of a Database Manager. [5 marks]

4. (a) Explain the Hierarchical Model. How are following functions performed in this model:-

* Representation of many-to-many relationship.
* Accessing of data records.
* Implementing of the Hierarchical Data Model.

[9 marks]
(b) What are Database anomalies ? Explain the three types of anomalies that may exist in a database. [6 marks]

5. (a) What is Normalization ? Explain the conditions under which a relation needs to be normalised to 3NF to BCNF, with the help of suitable example. [9 marks]
(b) Explain any six reasons as to why organisations resist from using DBMS tools. [6 marks]