CS5151 – DATA BASE TECHNOLOGY

Anna University Tiruchirappalli - 620 024
Regulations 2007 Sylllabus
M.E. COMPUTER SCIENCE AND ENGINEERING
SEMESTER II

CS5151 – DATA BASE TECHNOLOGY

UNIT I DATA BASE SYSTEM CONCEPT 10

File Systems – Database Systems – Database Systems Architecture – Data Models – Relational Model – Hierarchical Model – Network Model – Entity–Relationship Model – Data Dictionary – Database Administration and Control.

UNIT II RELATIONAL DATABASES 9
Codd's Rules – Base tables – Views – Domains and Key Concept – Integrity Rules – Relational Algebra – Relational Calculus – Commercial Query Languages – Embedded SQL – Normalization and Database Design.

UNIT III DATABASE SYSTEM DESIGN 8
File and Storage Structures – Indexing and Hashing – Query processing – Database Recovery –
Concurrency Control – Transaction Processing – Security and Integrity – Triggers.

UNIT IV DISTRIBUTED DATABASES 9
Centralized versus Distributed databases – Fragmentation – Distributed database architecture – Client / Server databases – Distributed transactions – Locking and Commit protocols – Distributed concurrency Control – Security and reliability – Parallel databases.

UNIT V ADVANCED DATABASES 9
The World Wide Web – Object Oriented Database – Object Relational Database – XML – XML/QL – Data Analysis and OLAP – Data mining – Data warehousing.

Total: 45

TEXT BOOKS
1. Abraham Silberschatz, Henry F. Korth, S. Sudharsan, “Database System Concepts”, 4th
Edition, Tata McGraw Hill, 2002.
2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, 3rd Edition,
Addison Wesley, 2004.

REFERENCES
1. Jim Buyens, “Step by Step Web Database Development”, PHI, 2001.
2. Stefano Ceri & Giuesppe Pelagatti, “Distributed Databases Principles and Systems”,
McGraw Hill Book Company– 1987.
3. C.J. Date- “An Introduction to Database system”- Pearson Education- 7th Edition- 2003.