Searching for BE CSE Question Papers asked in previous years? CS8303 - Database Management Systems Old Question Paper is given here under. It belongs to third semester B.E CSE full time question paper asked in 2014 during April and May exam session. You can get this question paper in text format.
Anna University , Chennai
B.E / B.Tech { Full Time ) DEGREE END SEMESTER EXAMINATIONS, APRIL / MAY 2014
COMPUTER SCIENCE AND ENGINEERING
Third Semester
CS8303 - Database Management Systems
(Regulation 2012)
Time: 3 Hours
Answer ALL Questions
PART-A (10 x 2 = 20 Marks)
Part - B ( 5 x 16 = 80 marks)
11. (i) Explain the architecture of database systems with a neat diagram. (10)
(ii) Write short notes on data models. (6)
12. a) (i) A university registrar's office maintains data about the following entities: (a) courses, including number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number, year, semester, section number, instructor(s), timings, and classroom; (c) students, including student-id, name, and program; and (d) instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in
each course they are enrolled for must be appropriately modeled.
Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints. (10)
(ii) Convert the ER schema shown in figure (ii) into relational schema. Document all assumptions that you make about the mapping constraints.
14. a) (i) Explain 2PL and its variants with the advantages and disadvantages. (10)
(ii) Explain the properties of a transaction with suitable examples. (6)
(OR)
b) (i) What are deadlocks? How are they handled? (10)
(ii) Explain 2PC protocol. (6)
15. a) (i) Explain the different algorithms used for selection operation and their associated cost. (10),
(ii) Discuss the steps involved in query processing with a neat diagram. (6)
(OR)
b) (i) What are temporal databases? Explain insertion and deletion in temporal databases. (10)
(ii) Write notes on data mining. (6)
---------------
Anna University Previous Years Question Papers, Old Question Papers, Model Question Papers, Sample Question Papers, Exam Previous Years Papers, Important Question Papers.
Anna University , Chennai
B.E / B.Tech { Full Time ) DEGREE END SEMESTER EXAMINATIONS, APRIL / MAY 2014
COMPUTER SCIENCE AND ENGINEERING
Third Semester
CS8303 - Database Management Systems
(Regulation 2012)
Time: 3 Hours
Answer ALL Questions
PART-A (10 x 2 = 20 Marks)
- List the responsibilities of a database administrator.
- List four advantages of database systems over file systems:
- List the properties to be satisfied by a decomposition of relation.
- Define PJNF. Give an example.
- What is dynamic SQL?
- Can views be modified? Justify.
- What is savepoint?
- What is the advantage of indent locking?
- What are the two types of spatial queries? Give examples.
- What are the issues in mobile databases?
Part - B ( 5 x 16 = 80 marks)
11. (i) Explain the architecture of database systems with a neat diagram. (10)
(ii) Write short notes on data models. (6)
12. a) (i) A university registrar's office maintains data about the following entities: (a) courses, including number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number, year, semester, section number, instructor(s), timings, and classroom; (c) students, including student-id, name, and program; and (d) instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in
each course they are enrolled for must be appropriately modeled.
Construct an E-R diagram for the registrar's office. Document all assumptions that you make about the mapping constraints. (10)
(ii) Convert the ER schema shown in figure (ii) into relational schema. Document all assumptions that you make about the mapping constraints.
14. a) (i) Explain 2PL and its variants with the advantages and disadvantages. (10)
(ii) Explain the properties of a transaction with suitable examples. (6)
(OR)
b) (i) What are deadlocks? How are they handled? (10)
(ii) Explain 2PC protocol. (6)
15. a) (i) Explain the different algorithms used for selection operation and their associated cost. (10),
(ii) Discuss the steps involved in query processing with a neat diagram. (6)
(OR)
b) (i) What are temporal databases? Explain insertion and deletion in temporal databases. (10)
(ii) Write notes on data mining. (6)
---------------
Anna University Previous Years Question Papers, Old Question Papers, Model Question Papers, Sample Question Papers, Exam Previous Years Papers, Important Question Papers.
0 comments:
Pen down your valuable important comments below