B.E./B.Tech. DEGREE EXAMINATION, APRIL/MAY 2010.
Fourth Semester
Computer Science and Engineering
CS2251 - DATABASE MANAGEMENT SYSTEMS
(Common to Information Technology)
(Regulation 2008)
Time: Three hours Maximum:100 marks
Answer ALL Questions.
PART A- (10 X 2= 20 marks)
1. Explain the basic structure of a relational database with an example.
2. What are the functions of a DBA?
3. Give the usage of the rename operation with an example.
4. What do you mean by weak entity set?
5. What is normalization?
6. Write a note on functional dependencies.
7. What do you mean by a transaction?
8. Define the term ACID properties.
9. Describe flash memory.
10. List out the physical storage media.
PART B- (5 X 16 = 80 Marks)
11. (a) (i) Discuss the various disadvantages in the file system and explain how it can be overcome by the database system. (6 Marks)
(ii) What are the different Data models present? Explain in detail. (10 Marks)
(Or)
(b) (i) Explain the Database system structure with a neat diagram. (10 Marks)
(ii) Construct an ER diagram for an employee payroll system. (6 Marks)
12. (a) (i) Explain the use trigger with your own example. (8 Marks)
(ii) Discuss the terms Distributed databases and client/ server databases. (8 Marks)
(Or)
(b) (i) What is a view? How can it be created? Explain with an example. (7 Marks)
(ii) Discuss in detail the operators SELECT, PROJECT, UNION with suitable examples. (9 Marks)
13. (a) Explain 1NF, 2NF and 3NF with an example. (16 Marks)
(Or)
(b) Explain the Boyce- Codd normal form with an example. Also state how it differs from that of 3NF. (16 Marks)
14. (a) (i) How can you implement atomicity in transactions? Explain. (8 Marks)
(ii) Describe the concept of serializability with suitable example. (8 Marks)
(Or)
(b) How concurrency is performed? Explain the protocol that is used to maintain the concurrency concept. (16 Marks)
15. (a) What is RAID? Explain it in detail. (16 Marks)
(Or)
(b) Mention the purpose of indexing. How this can be done by B+ tree? Explain. (16 Marks)
KEYWORDS:2010 ANNA UNIVERSITY CHENNAI B.E COMPUTER SCIENCE AND ENGINEERING B.E./B.TECH DEGREE EXAMINATION, APRIL/MAY 2010, CS2251 - DATABASE MANAGEMENT SYSTEM,ANNA UNIVERSITY QUESTION PAPER,ANNA UNIVERSITY,ANNA UNIVERSITY CHENNAI,ANNA UNIVERSITY COIMBATORE,ANNA UNIVERSITY TRICHY,ANNA UNIVERSITY TIRUNELVELI,ANNA UNIVERSITY MADURAI,ANNA UNIVERSITY SYLLABUS,ANNA-UNIVERSITY RESULTS,ANNA UNIVERSITY DISTANCE EDUCATION,ANNA UNIVERSITY MBA-CENTRE FOR DISTANCE EDUCATION,ANNA UNIVERSITY SCHEDULE OF EXAMINATIONS,ANNA UNIVERSITY ADMISSION,ANNA UNIVERSITY COURSES,ANNA UNIVERSITY ACADEMIC,ANNA UNIVERSITY DEPARTMENTS,ANNA UNIVERSITY RESEARCH,ANNA UNIVERSITY MAIL,ANNA UNIVERSITY QUESTION PAPERS,ANNA UNIVERSITY COUNSELLING DATES,ANNA UNIVERSITY RE-EVALUATION RESULTS
Fourth Semester
Computer Science and Engineering
CS2251 - DATABASE MANAGEMENT SYSTEMS
(Common to Information Technology)
(Regulation 2008)
Time: Three hours Maximum:100 marks
Answer ALL Questions.
PART A- (10 X 2= 20 marks)
1. Explain the basic structure of a relational database with an example.
2. What are the functions of a DBA?
3. Give the usage of the rename operation with an example.
4. What do you mean by weak entity set?
5. What is normalization?
6. Write a note on functional dependencies.
7. What do you mean by a transaction?
8. Define the term ACID properties.
9. Describe flash memory.
10. List out the physical storage media.
PART B- (5 X 16 = 80 Marks)
11. (a) (i) Discuss the various disadvantages in the file system and explain how it can be overcome by the database system. (6 Marks)
(ii) What are the different Data models present? Explain in detail. (10 Marks)
(Or)
(b) (i) Explain the Database system structure with a neat diagram. (10 Marks)
(ii) Construct an ER diagram for an employee payroll system. (6 Marks)
12. (a) (i) Explain the use trigger with your own example. (8 Marks)
(ii) Discuss the terms Distributed databases and client/ server databases. (8 Marks)
(Or)
(b) (i) What is a view? How can it be created? Explain with an example. (7 Marks)
(ii) Discuss in detail the operators SELECT, PROJECT, UNION with suitable examples. (9 Marks)
13. (a) Explain 1NF, 2NF and 3NF with an example. (16 Marks)
(Or)
(b) Explain the Boyce- Codd normal form with an example. Also state how it differs from that of 3NF. (16 Marks)
14. (a) (i) How can you implement atomicity in transactions? Explain. (8 Marks)
(ii) Describe the concept of serializability with suitable example. (8 Marks)
(Or)
(b) How concurrency is performed? Explain the protocol that is used to maintain the concurrency concept. (16 Marks)
15. (a) What is RAID? Explain it in detail. (16 Marks)
(Or)
(b) Mention the purpose of indexing. How this can be done by B+ tree? Explain. (16 Marks)
KEYWORDS:2010 ANNA UNIVERSITY CHENNAI B.E COMPUTER SCIENCE AND ENGINEERING B.E./B.TECH DEGREE EXAMINATION, APRIL/MAY 2010, CS2251 - DATABASE MANAGEMENT SYSTEM,ANNA UNIVERSITY QUESTION PAPER,ANNA UNIVERSITY,ANNA UNIVERSITY CHENNAI,ANNA UNIVERSITY COIMBATORE,ANNA UNIVERSITY TRICHY,ANNA UNIVERSITY TIRUNELVELI,ANNA UNIVERSITY MADURAI,ANNA UNIVERSITY SYLLABUS,ANNA-UNIVERSITY RESULTS,ANNA UNIVERSITY DISTANCE EDUCATION,ANNA UNIVERSITY MBA-CENTRE FOR DISTANCE EDUCATION,ANNA UNIVERSITY SCHEDULE OF EXAMINATIONS,ANNA UNIVERSITY ADMISSION,ANNA UNIVERSITY COURSES,ANNA UNIVERSITY ACADEMIC,ANNA UNIVERSITY DEPARTMENTS,ANNA UNIVERSITY RESEARCH,ANNA UNIVERSITY MAIL,ANNA UNIVERSITY QUESTION PAPERS,ANNA UNIVERSITY COUNSELLING DATES,ANNA UNIVERSITY RE-EVALUATION RESULTS