MCA205 - Data Base Management Systems |
UNIT I INTRODUCTION |
Database Systems vs. File Systems-View of Data- Data Models-Database Languages-Transaction
Management-Database Systems Structure-History of Database Systems-Database Systems
Applications-Entity Relationship Model |
UNIT II RELATIONAL DATABASES |
SQL-Basic Structure-Set Operations-Complex Queries-Joined Queries-DDLEmbedded SQLDynamic
SQL-Other SQL Functions-Query by Example-Integrity and Security of searching-
Relational Database Design - Normalization - 1NF,2NF,BCNF,3NF |
UNIT IIIDATA STORAGE AND INDEXING |
Storage & File Structure-Disks-RAID-File Organization-Indexing &Hashing-B+ TREE-B Tree-
Static Hashing-Dynamic Hashing-Multiple Key Access |
UNIT IVQUERY EVALUATION & OPTIMIZATION |
Query Processing-Selection Operation-Sorting-Join Operation-Evaluation of Expressions-Query
Optimization |
UNIT VTRANSACTION MANAGEMENT & RECENT TRENDS |
Transaction Concept-Static Implementation-Concurrency Control-ProtocolsDeadlock Handling-
Recovery Systems-Recovery with Concurrent TransactionsShadow Paging-Buffer Management -
Basic concepts: Distributed Databases, Parallel Databases. |
Reference Books |
1 Abraham Silberschatz, Hentry F.Korth and S.Sudharssan,”Database System
Concepts”, 4th Edition, Tata McGraw Hill, 2002
2. Raghu Ramakrishnan & Johannesgerhrke, ”Data Base Management Systems”,
Mc Graw Hill International Edition, 2000
3. Ramez Elmasri and Shamkant B.Navathe, “Fundamental Database Systems”,
Third Edition, Pearson Education, 2003. |