UNIT 1:
introduction to database systems
purpose of database system
data base management system -building blocks
three schema architecture of DBMS
data base management system -building blocks
UNIT 2:
DCL, structure – creation, alteration
defining constraints – Primary key, foreign key, unique, not null, check
IN operator, Functions - aggregate functions
Built-in functions – numeric, date, string functions
set operations, sub-queries, correlated sub-queries
transaction control commands – Commit, Rollback
stored procedures, Triggers
UNIT 3:
ER Diagrams - Entities, Attributes, Relationships
Constraints, keys, extended ER features, Generalization
Specialization, Aggregation, Conceptual design with the E-R model
Dependencies and Normal forms
E-R Issues- weak entity set, code rules
Normalizations: 1NF,2NF,3NF
UNIT 4:
Transaction Concepts – ACID Properties
serializability and its types Schedules
Serializability – Concurrency Control
Need for Concurrency – Locking Protocols
Save Points – Isolation Levels
SQL Facilities for Concurrency and Recovery.
UNIT 5:
Concurrency control, lock based protocols
Concurrency control, lock based protocols
multiple granularity. Recovery system
failure classification, storage structure
log- based recovery, shadow paging
buffer management, failure with loss of non-volatile storage
advanced recovery techniques