CS-06 June, 2004 Question Paper

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

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 

June, 2004

 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). What are the advantages of DBMS over a traditional file system?

(b) What is ISAM? How are records stored in ISAM? Show this with diagrams.

(c) Define BCNF. How does it differ from 3NF? Explain them through an example.

(d) What is a knowledge-base system? Differentiate between a knowledge base system and a database system.

Q.2(a). Make an ER diagram of a warehouse. The warehouse has two type of items: low risk items and high risk items. The low risk items are issued on receipt of a simple challan but the high risk items are issued only if the challan is verified and authenticated by proper authorities. The issues are made only to a valid employee of the company. Make necessary assumptions.

(b) Briefly explain three advantages and three disadvantages of distributed database.

(c) Describe data fragmentation.

Q.3(a). Consider the relation R which has attributes that hold schedules of courses and sections at a university; R = { Course No., Section No., Offering_dept Credit hrs, Course level, Semester, Instructor SSN, year, Days_hrs, Room No No. of students)

Suppose that the following functional dependencies hold on R
{Course No.} > {Offering dept, Credit hrs, Course level}
{Course No., Section No., Semester, year} >
{Days_hrs, Room No., No. of students, Instructor SSN}
{Room No., Days hrs, semester, year} >
{Instructor SSN, Course No., Section No.}

(i)Which sets of attributes form keys of R?
(ii)Show how you would normalize the relation above. Also give the final tables.

(b) Define the two principle integrity rule for the relational model. In which situations would you need to apply these rules?

Q.4(a). Consider the following relations:

supplier (sid, sname, add)
parts (pid, pname, color)
catalog (sid, pid, cost)

(i)Find the parts supplied by Acme Widgets supplier only.
(ii)Find all the supplied who supply red or green parts.
(iii)Find the supplier who charges the most for any part.

(b) Two relations Rl and R2 are given in the tables below.

Student _ ID Course _ Code Marks
I1 c1 70
I2 Q2 50
I3 c3 40
I4 c4 20
I5 Q5 75
I6 Q6 90

Course_ID Course _Name
C1 DBMS
C2 DS
C3 DCN
les.
Use the relational algebraic operation to answer the following quer

(i) Course taken by student Ir
(ii) List all the students who have got more than 40 marks in course C.

Q.5(a)- Explain five basic functions of a database administrator.

(b) Explain, witrra suitable example, generalization and specialization.

(c) Explain briefly about distributed computing environment

Q.6(a). Discuss 4 basic features of OODBMS. Give 4 advantages of OODBMS.

(b) Explain hashing. Show how it is used in direct file organization. Give two advantages and two disadvantages of hashing.