IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2001 QUESTION PAPER
BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2001
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). Name the major advantages of a Database Management System (DBMS) over a File Management System.
(b) Define the following concepts in the context of DBMS:
(i) Bit Map
(ii) Candidate Key
(iii) Referential integrity
(c) What does VSAM stand for? Briefly describe VSAM.
(d) Discuss briefly the possible problem with an unnormalized database.
(e)We are given the following record-types (relation types):
Express the following commands in SQL:
(i) Get P# for the parts for which weight of the part is 5 kg and colour is black,
(ii) Give the details of all suppliers from the city of Bombay and turnover of more than Rs. 50 lacs.
(f) Compare object oriented and Relational approaches to Database design.
(g) Explain briefly what do you understand by Distributed computing environment.
This also includes the following :
1. Global Dictionary
2. Two Phase Commit (2Pc)
3. Replicated Server/Table
2(a). Describe the problems that are caused by data redundancies. Can data redundancies be completely eliminated, when database approach is used? Give reasons in support of your answer.
(b) Draw E-R diagram for any one of the following two organisations: (i) University, (ii) Hospital, after determining the entities of interest and the relationships that exist between these entities.
(c) Define the following terms:
(i) Association
(ii) Relationship
(iii) Aggregation
Q.3(a). The People’s Bank others five types of accounts: loan, checking, premium savings, daily interest saving and money market It operates a number Of branches, and a client of the bank can have any number of accounts. Accounts can be joint; i.e. more than one client may be able to operate a given account Draw a diagrammatic representation of the Network model of the bank, after identifying the relevant concepts.
(b) In respect of project we are given the following record-types for the relational model of the database:
EMPLOYEE: with fields as ‘Emp#’ and ‘Name’
ASSIGNEDJTO: with fields as ‘Projects and ‘Emp#’
PROJECT: with fields and ‘Projects, ‘Project_Name’, ‘Chief_Architect’.
Where ‘Chief_Architect’ is a three-digit code and all other fields have obvious meanings. Then express the following queries in relational algebra:
(i) ‘Get Emp# of employees working on project COMP353′
(ii) ‘Get details of employees (both number and name 3) working on project COMP353′
(iii) ‘Gather details of employees working on both COMP353 and COMP354′
(c) Briefly describe the various possible problems with a (not normalised) database.
Q4(a). Is the following relation in Third Normal Form?
Roll No. Name Department Year Hostel Name
2101 Raman Physics I Ganga
2102 Krishna Chemistry I Ganga
2103 Abdul Mathematics U Kaveri
2104 John Botany S Kaveri
Justify your answer, if it is in Third Normal Form. If it is not, then bring it in Third Normal Form.
(b)Again consider the. record-types given in Question No. l(e):
Where S# and P# are keys respectively for SUPPLIER and PARTS.
Express the following in SQL:
(i) Get the part numbers that cost 20,30 or 40 rupees.
(ii) Get the supplier names who do not supply part
(iii) Get the part numbers whose cost is greater than average cost
(c) Discuss the issue of Data Replication or the issue of Data Fragmentation in respect of distributed database.
Q.6. Discuss the following with reference to File organization for conventional DBMS:
(i) List the key features of B-tree and how it is different from B+ - tree
(ii) Why do we need multilist file organisation?
(iii) Explain comparison and trade-off in the design of a multikey file.
No comments :
Post a Comment