Annamalai University 2004 M.Phil Computer Science Master of Philosophy - - 120 - Advanced Database and Data Communication - Question Paper

M.Phil. DEGREE exam – May 2004
(COMPUTER SCIENCE)

(PAPER - II)
120 - Advanced Database and Data Communication

Time: three Hours
Maximum: 100 Marks

PART - A (5 x eight =40)

ans ALL ques..
All ques. carry equal marks.

1. (a) What do you mean by relational database ? explain the undesirable properties that a bad relational database design may have.

(OR)

(b) What is 3rd normal form? explain an algorithm for finding a dependency-preserving, loseless join decomposition into 3rd normal form.

2. (a) discuss the steps involved in processing a query.

(OR)

(b) What do you mean by distributed data bases? explain the advantages and disadvantages of distributed data bases

3. (a) What is world wide - web ? explain the basics of URL.

(OR)

(b) Write short notes on Browsers.

4. (a) provide a brief history on the evolution of ISDN.

(OR)

(b) explain the presentation layer design problems.

5. (a) What is client / server computing ? elaborate the benefits of client / server computing? - explain.

(OR)

(b) explain any 2 transaction processing monitor architectures.

PART – B (3 x 20 = 60)

ans any 3 ques..

All ques. carry equal marks.

6. (a) explain the theory of multi - valued dependencies.

(b) What is multiple inheritance? - explain.

(c) explain the mapping of relational data into files.

7. (a) explain the various schemes of con currency control.

(b) define the various security measures.

8. discuss the various internet services in detail.

9. explain the subsequent

(a) Data I ink layer in public networks,

(b) Design problems of transport layer

10. (a) Write short note notes on tile subsequent

(i) Downsizing.

(ii) ODBC.

(iii) Triggers.

b) provide an overview of client/server applications.

Earning:   Approval pending.