2023 2024 Student Forum > Management Forum > Entrance Exams

 
  #2  
14th August 2018, 03:31 PM
Unregistered
Guest
 
Re: Anna University Chennai DBMS Syllabus

Hi buddy here I am looking for Anna University CS6302 Database Management Systems paper syllabus so would you plz let me know from where I can do download it ??
  #3  
14th August 2018, 03:32 PM
Super Moderator
 
Join Date: Aug 2012
Re: Anna University Chennai DBMS Syllabus

As you want here I am giving bellow Anna University CS6302 Database Management Systems paper syllabus on your demand

Anna University CS6302 Database Management Systems paper syllabus on your demand:


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


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 06:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4