CS-06 Data Base Management System Question Paper June-2002

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

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 

June, 2002
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). Draw E-R diagram for a departmental store, after determining the entities of interest and the relationship that exist between these entities. Also construct a tabular representation of the entities and relationships. Are there any attributes (or collections of attributes) in each entity set that would uniquely identify an instance of the entity set?

(b) What problems are caused by data redundancies? Can data redundancies be completely eliminated when the database approach is used? Explain.

(c) Explain why first normal form is acceptable for data processing applications.

(d)Consider the relational database:

EMPLOYEE (ENO, EName, Skill, Pay-Rate, Date)
POSITION (Posting_No, Skill)
DUTY_ALLOCATION (PostingJVo, ENO, Shift)
Give expressions in SQL for the following:

(i) Find the names of employees who are assigned to all positions that require a clerk’s skill.
(ii) Get employees who are working either on the date 19860419 or 19860420.
(iii) Find the names and rate of pay of all employees who are not allocated a duty.

Q2. Write short notes on :
(i) Database administrator
(ii) Metadata
(iii) 3-Ievel architecture of DBMS
(iv) Data Independence
(v) Abstraction

Q.3(a). Explain with respect to Distributed Databases:
(b) List all functional dependencies satisfied by the following relation r:

Q.5(a). Compare and contrast index sequential file with B+ tree file.
(b) What is normalization? What is its purpose? Mention different types of normal forms define them.

Q.6(a). Discuss rule based representation and Frame based representation schemes.
(b) Discuss the components of client/server computing. Also mention the advantages of client/server computing.