|
CS30202: Database Management Systems | |
| Topic/Slide |
Text Book Chapter (SKS Book) |
Practice Problems |
| Introduction |
Chapter 1 |
|
| Entity Relationship Diagram |
Chapter 6 |
|
| Rekational Algebra |
Chapter 2 |
Set 1 |
| SQL |
Chapter 3, 4 |
Set 2 |
| Relational Calculus |
Chapter 27 |
Set 3 |
| Functional Dependencies |
Chapter 7 |
|
| Normal Forms |
Chapter 7 |
Set 4 |
| Disk Storage System |
Chapter 12 |
|
| Data Storage Structure |
Chapter 13 |
|
| Indexing |
Chapter 14 |
Set 5 |
| Query Processing |
Chapter 18 |
|
| Query Optimization |
Chapter 19 |
Set 6 |
| Transactions |
Chapter 17 |
|
| Concurrency Control |
Chapter 18 |
Set 7 |
| Recovery System |
Chapter 19 |
Set 8 |
| Assignment |
Problem Statement |
Reference Material |
| Assignment 1: ER Diagram |
2026 2025 2016 |
ER Diagram |
| Assignment 2: SQL |
2026 2025 2016 |
PostgresQL Tutorial |
| Assignment 3: Database Connectivity |
2026 2025 2016 |
JDBC ODBC Psycopg2 |
| Assignment 4: Web Application Development |
2026 2025 2016 |
Web Application Development Full Stack Development |
| Term Project |
Guidelines and Suggested Topics |