| 1 |
Unit-1.1 Database system concept and Architecture |
|
| 2 |
Unit-1.2 Relational model and Relational database constraints |
|
| 3 |
Unit-1.3 Relational Algebra |
|
| 4 |
Unit-2 Conecptual Modeling and Database Design |
|
| 5 |
Unit-3 Database Design Theory and Normalization |
|
| 6 |
Unit-4.1 Introduction to SQL |
|
| 7 |
Unit-4.2 Complex queries, triggers, views, joining database tables and schema modification |
|
| 8 |
Unit-4.3 Query Processing and optimization |
|
| 9 |
Unit-4.4 File structure, hashing and indexing |
|
| 10 |
Unit-5 Transaction management and concurrency control and recovery |
|
