Periods/week : 3 Periods & 1 Tut /week.                                                                  Ses. : 30 Exam : 70 Examination (Practical): 3hrs.                                                                                   Credits: 4

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

tejus mahiCSE 3.2 SyllabusIT 3.2 SyllabusCSE,CSE Syllabus,Database Management Systems Syllabus,IT,IT Syllabus
Periods/week : 3 Periods & 1 Tut /week.                                                                  Ses. : 30 Exam : 70 Examination (Practical): 3hrs.                                                                                   Credits: 4 Introduction to DBMS:  Overview, File system vs DBMS, Advantages of DBMS, Storage data, queries, Transaction  Management,...