Hello There, Guest! RegisterLogin with Facebook
Login with Facebook

New Anna University (UG / PG) Nov/Dec 2016 and Jan 2017 Theory , Practical Exam Timetable
>>> Anna University Sixth Semester Question Bank Collection (R2013) ECE,MECH,CSE,IT,EEE,CIVIL,EIE
>>> Anna University November/December 2015 Examination Question Papers
>>> Anna University Study Materials for all Departments
>>> Anna University Question Papers : April May June 2015 Question Papers | Nov Dec 2014 and Jan 2015 Question Papers

Register or Login to Submit Study Materials , Shoutbox and also to access Many Features !!

Vidyarthiplus Shop :: Handwritten Premium Lecture Notes
Share your Study Materials with us
Share your Study Materials with us : Click Here

CS2255 Database Management Systems - Nov / Dec 2013 Important Questions

Anna University

Department of Computer Science Engineering

Fourth Semester

CS2255 Database Management Systems 

Nov / Dec 2013 Important Questions

(Common to I.T)

(Regulation 2008) 

Unit 1
1. Explain the components of DBMS.
2.Describe in detail the architecture of DBMS.
3.Describe the Evolution of database system. Explain the advantages of having centralized control of data
4.Write the difference between File Processing System and Database Management System
5.Explain File Processing System in detail.
6.Discuss about Objectives of Database Management System

Unit 2
1. Briefly explain the various data models. 
2.Construct an ER diagram for hospital with a set of patients and a set of doctors.A log of various conducted test is associated with each patient.Also construct appropriate tables for each of the above ER diagram
3. Explain the various components of ER diagram
4. Explain Generalization and Specialization
5. Discuss in detail Conceptual Data Modeling
6. Discuss First,Second,Third Normal Forms
7. Define BCNF.How does it differ from 3NF?

Unit 3
1 .Explain SQL built-in functions
2. Explain the provisions in SQL to insert delete and modify tuples
3. Explain the two phase locking protocol and time stamp based protocols used for concurrency control
What is meant by concurrent execution of database transactions in a multi-user system? Discuss why concurrency control is needed.-
4.Explain Client-server architecture. What is the difference between centralized and client-server architectures?-
5. Explain File Server Architecture

Unit 4
1.Explain Homogenous and Heterogeneous Systems
2.Discuss Distributed Database
3.Explain how query is processed in distributed database
4.Explain the features of object oriented database
5.Discuss the concept of polymorphism/operator overloading
6.Explain UML

Unit 5
1.Explain what is knowledge base system?

2.Explain the difference between knowledge base and database management system.
3.Discuss visual databases in detail.
4.Mention the career scope for database professionals.

New Share your Study Materials with us : Click Here



Recommend on Google