A one-stop Git repository for third year SPPU Computer Engineering students following the 2019 pattern. Access theory and practical resources covering E-R modeling, SQL/PL-SQL queries, NoSQL databases, database design, transaction management, and more for mastering Database Management System (DBMS) concepts.
| Notes | ||
| Practical | ||
| Question Papers | ||
| README.md | ||
Database Management Systems (DBMS)
A one-stop Git repository for third year SPPU Computer Engineering students following the 2019 pattern. Access theory and practical resources covering E-R modeling, SQL/PL-SQL queries, NoSQL databases, database design, transaction management, and more for mastering Database Management System (DBMS) concepts.
Index
Notes
- Unit 1 - Introduction to Database Management Systems and ER Model
- Unit 2 - SQL and PL/SQL
- Unit 3 - Relational Database Design
- Unit 4 - Database Transaction Management
- Unit 5 - NoSQL Databases
- Unit 6 - Advances in Databases
Practical
Important
Queries for all problem statements expected for practical examination (2024) are in the "Practical Exam" folder.
Each folder contains handout, write-up and database and softcopy (i.e. copy + output).
- Assignment-A2
- Assignment-A3
- Assignment-A4+A5
- Assignment-A6
- Assignment-A7
- Assignment-A8
- Assignment-B1
- Assignment-B2
- Assignment-B3
- Assignment-A9+B4+C1 (Mini Project)