Database System Concepts and Architecture:

Data Models FREE

Schemas and Instances FREE

Three-Schema Architecture and Data Independence

Database Languages and Interfaces

Centralized and Client/Server Architectures for DBMS

Data Modeling:

Entity Relationship Diagrams, Relational Model

Constraints

Languages

Design and Programming

Relational Database Schemas

Relational Algebra and Relational Calculus

Codd Rules

Normalization for Relational Databases:

Functional Dependencies and Normalization

Algorithms for Query Processing and Optimization

Transaction Processing

Concurrency Control Techniques

Database Recovery Techniques

Object and Object-Relational Databases

Database Security and Authorization

Constraints and Views:

Constraints and its types

Integrity constraints

Check constraints

Referential constraints

Introduction to views

updates on views

comparison between tables and views

Transaction management and Concurrency control:

Transaction management

ACID properties

serializability and concurrency control

Lock based concurrency control (2PL, Deadlocks)

Time stamping methods

optimistic methods

database recovery management

UNIT – 2 FULL TEST