Data Base And Management System

UNIT - 1

DATABASE SYSTEM ARCHITECTURE

• INTRODUCTION TO DBMS
• DATA ABSTRACTION
• DATA INDEPENDENCE
• DDL and DML 

DATA MODELS

• ENTITY-RELATIONSHIP MODEL
• NETWORK MODEL
• RELATIONAL AND OBJECT-ORIENTED DATA MODELS
• INTEGRITY CONSTRAINTS
• DATA MANIPULATION OPERATIONS

UNIT - 2

RELATIONAL QUERY LANGUAGES

• RELATIONAL ALGEBRA
• TUPLE and DOMAIN RELATIONAL CALCULUS
• DDL and DML CONSTRUCTS
• OPEN SOURCE and COMMERCIAL DBMS

RELATIONAL DATABASE DESIGN

• DOMAIN and DATA DEPENDENCY
• ARMSTRONG'S AXIOMS
• DEPENDENCY PRESERVATION and LOSSLESS DESIGN

QUERY PROCESSING AND OPTIMIZATION

• EVALUATION OF RELATIONAL ALGEBRA EXPRESSIONS
• QUERY EQUIVALENCE
• JOIN STRATEGIES

UNIT - 3

STORAGE STRATEGIES

• INDICES
• B-TREES
• HASHING

TRANSACTION PROCESSING 

• CONCURRENCY CONTROL
• SERIALIZABILITY OF SCHEDULING
• MULTI-VERSION and OPTIMISTIC CONCURRENCY CONTROL SCHEMES
• DATABASE RECOVERY

UNIT - 4

DATABASE SECURITY

• AUTHENTICATION
• AUTHORIZATION and ACCESS CONTROL

NOTE:- DAC, MAC, AND RBAC MODELS ARE COVERED UNDER ACCESS CONTROL SCHEMES.

• INTRUSION DETECTION
• SQL INJECTION

ADVANCED TOPICS

• OBJECT ORIENTED  and OBJECT RELATIONAL DATABASES
• LOGICAL DATABASES
• WEB DATABASES
• DISTRIBUTED DATABASES
• DATA WAREHOUSING and DATA MINING