Complete Syllabus
UNIT I: Introduction & Architecture
Introduction to Database
Hierarchical, Network and Relational database
CLO01CO01Database System Architecture
Data abstraction, Data independence, DDL, DML, DCL
CLO02CO01
UNIT II: Data Models & Query Languages
Data Models
Entity-relationship model, Network model, Relational and Object oriented data Models, Integrity constraints, Data manipulation operations
CLO03CO01Relational Query Languages
Relational algebra, Tuple and domain relational calculus, Open source and commercial DBMS
CLO04CO02
UNIT III: Relational Database Design
Relational Database Design
Domain and data dependency, Armstrong's axioms, Functional dependencies, Normal forms, Dependency preservation, Lossless design
CLO03CO03Query Processing and Optimization
Evaluation of relational algebra expressions, Query equivalence, Join strategies, Query optimization algorithms
CLO04CO04
UNIT IV: Storage & Transactions
Storage Strategies
Indices, B-trees, Hashing
CLO02CO03Transaction Processing
Concurrency control, ACID property, Serializability, Schedules, Locking and timestamp based schedules, Multi-version and optimistic concurrency control schemes, Database recovery
CLO05CO05
UNIT V: Security & Advanced Topics
Database Security
Authentication, Authorization and access control, DAC, MAC and RBAC models, Intrusion detection SQL injection
CLO01CO06Advanced Topics
Object oriented and object relational databases, Logical warehousing and data mining
CLO01CO06