Warning: include(../../google_728x15b.php) [function.include]: failed to open stream: No such file or directory in /home/content/22/4814422/html/tamilnadu/university_syllabus/CS_2255_data_base_management_systems_anna_university_coimbatore_cse_syllabus_2008.php on line 51
Warning: include() [function.include]: Failed opening '../../google_728x15b.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php') in /home/content/22/4814422/html/tamilnadu/university_syllabus/CS_2255_data_base_management_systems_anna_university_coimbatore_cse_syllabus_2008.php on line 51
Introduction to DATABASE MANAGEMENT SYSTEMS – review of computer organization – operating system
structures – system calls – system programs – system structure – virtual machines.
Processes: Process concept – Process scheduling – Operations on processes –
Cooperating processes – Interprocess communication – Communication in client-server
systems. Case study: IPC in Linux. Threads: Multi-threading models – Threading issues.
Case Study: Pthreads library
UNIT II RELATIONAL MODEL
The relational Model – The catalog- Types– Keys - Relational Algebra – Domain
Relational Calculus – Tuple Relational Calculus - Fundamental operations – Additional
Operations- SQL fundamentals - Integrity – Triggers - Security – Advanced SQL
features –Embedded SQL– Dynamic SQL- Missing Information– Views – Introduction
to Distributed Databases and Client/Server Databases
UNIT IIIDATABASE DESIGN
Functional Dependencies – Non-loss Decomposition – Functional Dependencies – First,
Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form-
Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth
Transaction Concepts - Transaction Recovery – ACID Properties – System Recovery –
Media Recovery – Two Phase Commit - Save Points – SQL Facilities for recovery –
Concurrency – Need for Concurrency – Locking Protocols – Two Phase Locking –
Intent Locking – Deadlock- Serializability – Recovery Isolation Levels – SQL Facilities
UNIT VIMPLEMENTATION TECHNIQUES
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 –
Query Processing Overview – Catalog Information for Cost Estimation – Selection
Operation – Sorting – Join Operation – Database Tuning.
1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System
Concepts”, Fifth Edition, Tata McGraw Hill, 2006 (Unit I and Unit-V) .
2. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”,
Eighth Edition, Pearson Education, 2006.( Unit II, III and IV)
1. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”,
FourthEdition , Pearson / Addision wesley, 2007.
2. Raghu Ramakrishnan, “Database Management Systems”, Third Edition, McGraw
3. S.K.Singh, “Database Systems Concepts, Design and Applications”, First Edition,
Pearson Education, 2006.
Warning: include(../../google_160x600.php) [function.include]: failed to open stream: No such file or directory in /home/content/22/4814422/html/tamilnadu/university_syllabus/CS_2255_data_base_management_systems_anna_university_coimbatore_cse_syllabus_2008.php on line 141
Warning: include() [function.include]: Failed opening '../../google_160x600.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php') in /home/content/22/4814422/html/tamilnadu/university_syllabus/CS_2255_data_base_management_systems_anna_university_coimbatore_cse_syllabus_2008.php on line 141