CS-06: Introduction to DBMS December, 2003 Question Paper

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

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 

December, 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). Construct an ER diagram (including important attributes) for a car insurance database that includes data about customer (car owners), cars accidents, drivers involved in accidents and injured drivers and/or passengers. Note that any customer can insure many cars, each car may have different drivers at different times and accidents typically involve one or more cars.

(b) Explain the 3 levels of the database architecture. Also discuss the advantages of having the 3 levels.

(c) What are functional dependencies? With a suitable example explain the importance of functional dependencies in database design and data modelling.

(d) Discuss the Boyce-Codd Normal Form (BCNF) with the help of an example.

Q.2(a). Consider the following Relational schema. An employee can work in more than one department:
Emp (Eid, Ename, Salary)
Works (Eid, did)
Dept (did, dname, managerid, floornum)

Write the following in SQL:

(i) Print the names of all employees who work on the 10th floor and earn salary less than Rs. 50,000.
(ii) Print the names of the departments that employee Santa works in.
(iii) Print the names of all managers who manage three or more departments on the same floor.
(iv) Print the names of all employees who work on floor(s) where Jane Donald works.
(v) Give every employee who works in the toys dept. a 10% raise in the salary.

(b) Compare and contrast primary key, candidate key and foreign key by giving a suitable example.

Q.3. Explain the following:

(i) Hashing
(ii) Indexing
(iii) B+ tree indexes
(iv) Specialization
(v) Generalization

Q.4(a). Discuss the features of OGDBMS. Also mention the advantages.
Four basic features of OODBMS:

(b) Discuss the following and also list the area of application:

(i) Multimedia Database
(ii) Knowledge Database

Q.5 Explain the following:

(i) Multithreaded Processes
(ii) Object Linking
(iii) Client/Server Computing

Q.6(a). Consider the relation R with 5 attributes A, B, C, D, E. You are given the following dependencies:
A->B
BC->E
ED-A

(i) List all keys of R.
(ii)IsRin3NForBCNF?
(iii) Design the normalised tables.

(b) Explain the trade offs in distributing the database in the context of Distributed database.