DATABASE MANAGEMENT SYSTEMS PSB1C MADRAS UNIVERSITY

 

NOVEMBER 2021    PSB1C

Time : Three hours                                        Maximum : 75 marks PART A (10 ´ 1 = 10 marks)

Answer any TEN questions.

1.              Define relational model.

2.              List out the set operations in SQL.

3.              Mention the problem of data redundancy.

4.              Why normalization is needed?

5.              Give the characteristics of relational database.

6.              What is file descriptor?

7.              List the properties of decomposition.

8.              Define hash indices.

9.              What is meant by query optimization?

10.          Define concurrency control.

11.          Write a note on transaction server.

12.          Compare LAN and WAN.

PART B (5 × 5 = 25 marks)

Answer any FIVE questions

13.          Describe the components of database system.

14.          What is multivalued dependency? Explain.

15.          Define functional dependency. List and discuss the various functional dependencies.

16.          List out the various kinds of file indexing? Explain any two.

17.          What      is      deadlock?      Discuss       about      deadlock detection methods.

18.          Compare        centralized        computer       system       and distributed computer system.

19.          Write short notes on Parallel System.

PART C (4 × 10 = 40 marks)

Answer any FOUR questions.

20.          Write short notes on :

(a)           Tuple relational calculus                                              (5)

(b)           Embedded   SQL.                                                              (5)

21.          Describe the Entity Relationship Model with examples.

22.          What      is     object-based      dataBase?       Explain       the feature of OORDBMS.

23.          What is RAID? Explain in detail.

24.          Describe about testing of Serializability.

25.          Describe shadow paging recovery techniques.

 

 

 

 

 

 

 

 

 

No comments:

Post a Comment