CS-06 : DATABASE MANAGEMENT SYSTEM
Note : Question number 1 is compulsory. Attempt any three from the rest.
1(a) Draw E-R diagram for a departmental store, after determining the entities of interest and the relationships 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)
POSITION (Posting_No, Skill)
DUTY_ALLOCATION (Posting_No, 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 data 19860419 or 19860420.
(iii) Find the names and rate of pay of all employees who are not allocated a duty. 
2 Write short notes on : 
(i) Database administrator
(iii) 3-level architecture of DBMS
(iv) Data Independence
3(a) Explain with respect to Distributed Databases: 
(i) Data Replication
(ii) Data Fragmentation
(b) List all functional dependencies satisfied by the following relation r : 
4(a) Compare and contrast RDBMS and OODBMS. 
(b) Write short notes on : 
(i) Knowledge databases
(ii) Multimedia databases
(iii) Design databases
Suggest one application where each database is suited.
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. 
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.