Syllabus - CS 9 : Database Management Systems

CS 9 :  Database Management  Systems 

( 6 Hours- 4 Credits)

UNIT – I

OVERVIEW OF DATABASE SYSTEMS: Managing Data – A Historical Perspective – File Systems Versus a DBMS – Advantages of a DBMS – Describing and Storing Data in a DBMS – Queries in a DBMS – Transaction Management – Structure of a DBMS – People Who Work with Databases.            

INTRODUCTION TO DATABASE DESIGN: Database Design and ER Diagrams – Entities,  Attributes,  and Entity Sets – Relationships and Relationship Sets – Additional Features of ER Model – Conceptual Design With the ER Model. 

UNIT – II

THE RELATIONAL MODEL: Introduction to the Relational Model – Integrity Constraints over Relations – Enforcing Integrity Constraints – Querying Relational Data – Logical Database Design: ER to Relational – Introduction to Views – Destroying / Altering Tables and Views.   

RELATIONAL ALGEBRA AND CALCULUS: Preliminaries – Relational Algebra: Selection and Projection – Set Operations –Renaming – Joins - Division  Relational Calculus: Tuple Relational Calculus – Domain Relational Calculus

UNIT – III

SQL:QUERIES,  CONSTRAINTS,  TRIGGERS: The Form of a Basic SQL Query -  UNION,  INTERSECT,  and EXCEPT – Nested Queries – Aggregate Operators – Null Values – Complex Integrity Constraints in SQL – Triggers and Active Databases – Designing Active Databases

UNIT – IV

SCHEMA REFINEMENT AND NORMAL FORMS: Introduction to Schema Refinement – Functional Dependencies – Reasoning about FD’s – Normal Forms – Properties of Decompositions – Normalization – Schema Refinement in Database Design – Other Kinds of Dependencies

           

UNIT - V

OVERVIEW OF TRANSACTION MANAGEMENT: The ACID Properties – Transactions and Schedules – Concurrent Execution of transactions – Lock Based Concurrency Control – Performance of Locking – Transaction Support in SQL – Introduction to Crash Recovery. 

SECURITY AND AUTHORIZATION: Intoduction to Database Security -  Access Control – Discretionary  Access Control – Mandatory Access Control – Security for Internet Applications – Additional Issues Related to Security. 

TEXT BOOK

Database Management Systems – Raghu Ramakrishnan & Johannes Gehrke,  McGraw Hill International Edition – Third Edition – 2003

CHAPTERS:

UNIT – I         : 1.  1 – 1.  9 ,  2.  1 – 2.  5

UNIT – II       : 3.  1 – 3.  7 ,  4.  1 – 4.  3

UNIT – III      : 5.  2 – 5.  9

UNIT – IV      : 19.  1 – 19.  8

UNIT – V       : 16.  1 – 16.  7 ,  21.  1 – 21.  6

REFERENCE BOOKS:

1.      Database Management Systems -  Alexis leon & mathews Leon,  “Leon Vikas Publishing,  Chennai,  2002. 

2.      Modern Database Management -  Frad R.   McFadden,  Jeffrey A.  Hoffer & Mary.   B.   Prescott,  5^th Edition,  Pearson Education Asia,  2001. 

3.      Database System Concepts – Abraham Silberschatz,  Henry F.  Korth,  S.  Sudarshan,  McGraw Hill,  2006