UNIT 1:
Introduction to Database System,
Purpose of Database System
Database Management system –Basic building blocks
Purpose of Database System
Database Management system –Basic building blocks
Evaluation of Data models
Three-schema architecture of DBMS
Three-schema architecture of DBMS
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
Save point, cursors, stored procedures
UNIT 3:
DATABASE DESIGN: Database Design Process
ER Diagrams - Entities, Attributes, Relationships
Constraints, keys, extended ER features, Generalization
Specialization, Aggregation, Conceptual design with the E-R model
E-R Issues- weak entity set, code rules
Dependencies and Normal forms
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
