CS1254 – DATABASE MANAGEMENT SYSTEMS

ANNA UNIVERSITY TIRUCHIRAPPALLI Regulations 2007 Syllabus

CS1254 – DATABASE MANAGEMENT SYSTEMS
L T P
3 1 0

UNIT I FUNDAMENTALS AND CONCEPTUAL MODELING 9
File and Database Systems – Database System Structure – Data Models – Introduction to Network and
Hierarchical Models – ER Model – Relational Model – Relational Algebra and Calculus.

UNIT II RELATIONAL MODEL 9
SQL – Data Definition – Queries in SQL – Updates – Views – Integrity and Security – Relational
Database Design – Functional Dependencies and Normalization for Relational Databases (Upto
BCNF).

UNIT III DATA STORAGE AND QUERY PROCESSING 9
Record Storage and Primary File Organization – Secondary Storage Devices – Operations on Files –
Heap File – Sorted Files – Hashing Techniques – Index Structure for Files – Different Types of Indexes
– B-Tree – B+
Tree– Query Processing.

UNIT IV TRANSACTION MANAGEMENT 9
Transaction Processing – Introduction – Need For Concurrency Control – Desirable Properties Of
Transaction – Schedule And Recoverability – Serializability And Schedules – Concurrency Control –
Types Of Locks – Two Phases Locking – Deadlock – Time Stamp Based Concurrency Control –
Recovery Techniques – Concepts – Immediate Update – Deferred Update – Shadow Paging.

UNIT V CURRENT TRENDS 9
Object Oriented Databases – Need For Complex Data Types – OO Data Model – Nested Relations –
Complex Types – Inheritance Reference Types – Distributed Databases – Homogenous and
Heterogenous – Distributed Data Storage – XML – Structure of XML – Data – XML Document –
Schema – Querying and Transformation – Data Mining and Data Warehousing.
L: 45 T: 15 Total: 60

TEXT BOOK
1. Abraham Silberschatz, Henry F.Korth and S.Sudarshan “Database System Concepts”, Fourth
Edition, McGraw-Hill, 2002.

REFERENCES
1. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition,
Pearson Education, 2003.
2. Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill, 2003.
3. Hector Garcia-Molina, Jeffrey D.Ullman and Jennifer Widom, “Database System
Implementation”, Pearson Education, 2000.
4. Peter Rob and Corlos Coronel, “Database System, Design, Implementation and Management”,
Fifth Edition,Thompson Learning Course Technology, 2003.

FEEL USEFUL PLEASE GIVE +1