Syllabus of Andhra University BTech Information Technology - IT 3.2.3 - Database Management Systems

Third year - Second Semester

Instruction: 3 Periods & 1 Tut /week
Univ. Exam : 3 Hours

Sessional Marks: 30
Univ-Exam-Marks:70

Introduction to DBMS: Overview, File system vs DBMS, Advantages of DBMS, Storage data, queries, Transaction Management, DBMS structure

E-R model: Entities, Attributes and Entity sets, Relation ship and Relation ship sets, Features of ER model, Conceptual database design with ER model

Relational model: Integrity constraints over relations and enforcement, Querying relation data, Logical database design, views, destroying/altering tables and views

Relational Languages: algebra and calculus

SQL: Basic SQL, Query, union, interest, except, Nested Queries, Aggregated Operation, Null values, Embedded SQL, cursors, ODBC and JDBC, Triggers and Active database, designing active databases

Schema refinement and normal forms : Schema refinement, fds, reasoning normal forms, normalization up to 3rd & BC normal forms, lossless join & dependency preserving decomposition

Transaction management: Transaction concept, transactions and schedules, concurrent execution of transactions, lock – based concurrency control, crash recovery

Concurrency control : Lock management, specialized locking techniques, concurrency control without locking

Crash Recovery: Aries, recovering from a system crash, media recovery

Text Book:

Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill