CS6302 Database Management Systems Previous Year Question Papers


CS6302 Database Management Systems Previous Year Question Papers


B.E – Computer Science and Engineering, Second Year 3rd Semester CS6302 Database Management Systems Previous Year Question Papers For The Regulation 2013.

(Note:  This Is The Only Site, Where You Can Download The Previous Year Anna University Question Papers In PDF Format With Good Quality And With Out Any Water Marks.

   You Can Download The Files In A Single Click & No More Re-directs )


OBJECTIVES:
  • To expose the students to the fundamentals of Database Management Systems.
  • To make the students understand the relational model.
  • To familiarize the students with ER diagrams.
  • To expose the students to SQL.
  • To make the students understand the fundamentals of Transaction Processing and Query Processing.
  • To familiarize the students with the different types of databases.
  • To make the students understand the Security Issues in Databases.
UNIT I – INTRODUCTION TO DBMS
File Systems Organization – Sequential, Pointer, Indexed, Direct – Purpose of Database System-Database System Terminologies-Database characteristics- Data models – Types of data models – Components of DBMS- Relational Algebra. LOGICAL DATABASE DESIGN: Relational DBMS – Codd’s Rule – Entity-Relationship model – Extended ER Normalization – Functional Dependencies, Anomaly- 1NF to 5NF- Domain-Key Normal Form – Denormalization
UNIT II – SQL & QUERY OPTIMIZATION
SQL Standards – Data types – Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static Vs Dynamic SQL – QUERY OPTIMIZATION: Query Processing and Optimization – Heuristics and Cost Estimates in Query Optimization.
UNIT III – TRANSACTION PROCESSING AND CONCURRENCY CONTROL
Introduction-Properties of Transaction- Serializability- Concurrency Control – Locking Mechanisms-
Two-Phase Commit Protocol-Dead lock.
UNIT IV – TRENDS IN DATABASE TECHNOLOGY
Overview of Physical Storage Media – Magnetic Disks – RAID – Tertiary storage – File Organization – Organization of Records in Files – Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing – Introduction to Distributed Databases- Client server technology- Multidimensional and Parallel databases- Spatial and multimedia databases-Mobile and web databases- Data Warehouse-Mining- Data marts.
UNIT V – ADVANCED TOPICS
DATABASE SECURITY: Data Classification-Threats and risks – Database access Control – Types of Privileges –Cryptography- Statistical Databases.- Distributed Databases-Architecture-Transaction Processing-Data Warehousing and Mining-Classification-Association rules-Clustering-Information Retrieval- Relevance ranking-Crawling and Indexing the Web- Object Oriented Databases-XML Databases.

CS6302 Database Management Systems Previous Year Question Papers for the Regulation 2013



Other Useful Links:


Related searches: anna university, anna university examinations, anna university previous year question papers, question papers download, regulation 2013, BE Computer Science and Engineering, 2nd year, 3rd semester, pdf format, question bank, CSE questions, Nov/Dec 2017, Apr/May 2017,  Nov/Dec 2016, May/June 2016, Nov/Dec 2015, CS6302, Database Management Systems,


1
Leave a Reply

avatar
1 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
1 Comment authors
ASDASD Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
ASDASD
Guest
ASDASD

some of the question papers do not have some pages, they are missing. And the papers that you are providing are old the recent ones are not there.