QUESTION PAPER » CS-06 QUESTION PAPER OF JUNE 2000

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

---

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2000
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). List all functional dependencies and multi-valued dependencies satisfied by the relation of the figure below:

A B C D
a1 b1 c1 d1
a1 b2 c1 d1
a2 b2 c2 d2
a2 b3 c2 d3
a3 b3 c2 d4

(b) When designing an E-R diagram for a particular enterprise, there exist several alternative designs.
(i) What criteria should you consider in deciding on the appropriate choice?

(ii) Come up with several alternative E-R diagrams to represent an enterprise. [jst the merits of each alternative and argue in favour of one of the alternatives.

(c) Given the EMPLOYEE and SALARY relations.
Find the natural Join(EMPLOYEE[X] SALARY)

Q.2(a) (i). Explain how each view is defined by a schema. Discuss the different views. Views by Schema:

(ii) Discuss levels of architecture for a DBMS.

(b)Design a Relational Database corresponding to the E-R diagram given below:
--DIAGRAM IS NOT AVAILABLE--

Q.3(a). Compare and contrast Sequential and Indexed Sequential file organisations

(b)Why is a B tree a better structure than a B-tree for implementation of an indexed sequential file? Discuss

Q.4. Consider the following tables A, B and AB in which S# is supplier code. P# is product code and QTY is quantity and ethers carry their respective meaning.

A
S# SNAME SCITY TURNOVER
110 XXX BHOPAL 50
111 YYY MUMBAI 100
112 ZZZ DEHRADUN 70
113 sss HYDERABAD 20

B
P# WEIGHT COLOUR COST SELLING PRICE
1 25 VIOLET 10 30
2 30 BROWN 15 55
3 35 VIOLET 17 55

AB
S# P# QTY
100 1 100
11 1 15
110 2 50
111 2 30
110 3 10
112 3 100
113 1 20

Write appropriate SQL statements for the following:

(i) Get the part numbers for the parts being supplied with no duplicates.

(ii) Get the supplier number and part number in ascending order of supplier number and descending order for the part supplied for each supplier.

(iii) Get the details of suppliers who operate from MUMBAI with turnover > 50.

(iv) Get the part numbers weighing between 25 and 35.

(v) Get the names and cities of suppliers whose names begin with XXX.

Q.5(a). Describe HISAM as the internal access methods for a hierarchical data base illustrating their features and implications thereof in database performance.

(b) Discuss the 3 most important Code’s commandments through examples.

Q.6(a). Compare and contrast knowledge database and DBMS. Give any two examples of knowledge database applications and explain.

(b)Compare and contrast production rule system and frame base representation with appropriate examples.