A comprehensive academic resource for Database Management System (DBMS) and Database Management System Laboratory (DBMS Lab), covering database models, SQL queries, normalization, transaction management, and practical implementations.
Overview · Contents · Reference Books · Mega's Notes · Assignments · Quizzes · Laboratory · Mini-Project · Online Exam · Semester Exam · Question Papers · Submission Report · Syllabus · Usage Guidelines · License · About · Acknowledgments
Database Management System (CSC502) and Database Management System Laboratory (CSL503) are core subjects in the Third Year (Semester V) of the Computer Engineering curriculum at the University of Mumbai. These courses provide foundational knowledge of relational database systems, SQL programming, database design, and management.
The curriculum encompasses several key domains in Database Management System:
- Entity-Relationship Modeling: Conceptual design, ER diagrams, weak and strong entities.
- Relational Model: Relational algebra, tuple calculus, domain calculus.
- SQL Programming: DDL, DML, DCL, Joins, Views, Triggers, Functions, Procedures.
- Normalization: 1NF, 2NF, 3NF, BCNF to minimize redundancy.
- Transaction Management: ACID properties, serializability, concurrency control.
- Query Processing: Query optimization, evaluation of relational operators.
This repository represents a curated collection of study materials, reference books, lab experiments, and personal preparation notes compiled during my academic journey. The primary motivation for creating and maintaining this archive is simple yet profound: to preserve knowledge for continuous learning and future reference.
As a computer engineer, understanding data management is crucial for backend development, data analysis, and system architecture. This repository serves as my intellectual reference point: a resource I can return to for relearning concepts, reviewing methodologies, and strengthening understanding when needed.
Why this repository exists:
- Knowledge Preservation: To maintain organized access to comprehensive study materials beyond the classroom.
- Continuous Learning: To support lifelong learning by enabling easy revisitation of fundamental database concepts.
- Academic Documentation: To authentically document my learning journey through Database Management System and Database Management System Laboratory.
- Community Contribution: To share these resources with students and learners who may benefit from them.
Note
All materials in this repository were created, compiled, and organized by me throughout my undergraduate program (2018-2022) as part of my coursework, laboratory assignments, and project implementations.
This collection includes comprehensive reference materials covering all major topics:
| # | Resource | Focus Area |
|---|---|---|
| 1 | DBMS Techmax | Complete syllabus coverage |
| 2 | Database System Concepts (Korth) | Standard Textbook (Korth) |
| 3 | Database Management Systems | Standard Textbook (Raghu Ramakrishnan) |
| 4 | Introduction to DBMS | Reference Book |
| 5 | DBMS Easy Solutions | Solved questions and exam-oriented summaries |
| 6 | DBMS Easy Solution | Additional solved questions |
| 7 | DBMS Notes | Comprehensive subject notes |
| 8 | DBMS Lecture Notes | Quick revision notes |
| 9 | DBMS Question Bank | Practice questions for exam preparation |
| 10 | Database Management System | Key architectural diagrams |
| 11 | Semester 5 Books | Curated book recommendations |
Comprehensive module-wise notes curated by Mega Satish:
| Module | Resource | Topics Covered |
|---|---|---|
| 1 | DBMS Module - 1 | Introduction, Entity-Relationship (ER) Modeling, Extended ER Features |
| 2 | DBMS Module - 2 | Relational Model, Relational Algebra, Calculus, and Constraints |
| 3 | DBMS Module - 3 | SQL Programming, Views, Triggers, and Integrity Constraints |
| 4 | DBMS Module - 4 | Normalization (1NF-BCNF), Decomposition, and Functional Dependencies |
| 5 | DBMS Module - 5 | Transaction Management, ACID Properties, Concurrency Control |
| 6 | DBMS Module - 6 | Query Processing, Optimization, and Evaluation Techniques |
Important
COVID-19 Impact: This coursework was completed during the COVID-19 pandemic. While this section contains the complete set of comprehensive notes curated by Mega Satish, the signature "The Wall" collaborative study sessions (typically documented with photos) could not be conducted due to the nationwide lockdown. This section therefore focuses solely on the digitized study materials, as movement restrictions prevented the in-person collaboration required for "The Wall" sessions.
Academic assignments for comprehensive learning and practice:
| # | Assignment | Description | Date | Marks |
|---|---|---|---|---|
| 1 | Assignment 1 | ER Diagrams and Relational Model basics | September 08, 2020 | 57/60 |
| 2 | Assignment 2 | Normalization and Transaction Management | November 24, 2020 | 54/60 |
Topics Covered: Entity-Relationship Modeling (ER Diagrams, Weak/Strong Entities) · Relational Model (Schema Design) · Normalization (1NF, 2NF, 3NF, BCNF) · Transaction Management (ACID Properties, Serializability)
DBMS-specific quizzes conducted during the course:
| # | Quiz | Topics | Date | Marks |
|---|---|---|---|---|
| 1 | Quiz 1 | Modules 1, 2, 3 | November 30, 2020 | 6/6 |
| 2 | Quiz 2 | Modules 4, 5, 6 | November 30, 2020 | 6/6 |
The laboratory component (CSL503) focuses on hands-on implementation of SQL queries, procedures, triggers, and database management tasks using Oracle Database/MySQL.
Tip
Source Code: For the complete SQL source code and detailed documentation of each experiment, visit the Database Management System Lab directory.
| # | Experiment Name | Description | Date | Marks | Report |
|---|---|---|---|---|---|
| 1 | Introduction to SQL | DDL & DML Commands (Create, Insert, etc.) | July 14, 2020 | 08/10 | View |
| 2 | Constraints & Functions | Integrity Constraints & Built-in Functions | July 21, 2020 | 08/10 | View |
| 3 | Joins & Set Operations | Inner, Outer Joins & Union, Intersect, Minus | July 28, 2020 | 07/10 | View |
| 4 | Views & Subqueries | Creating Views & Nested Queries | August 04, 2020 | 07/10 | View |
| 5 | DDL and Constraints (Recreated) | Advanced DDL & Constraints Management | August 14, 2020 | 07/10 | View |
| 6 | DML and TCL (Recreated) | Data Manipulation & Transaction Control | August 21, 2020 | 08/10 | View |
| 7 | Subqueries (Recreated) | Single-row & Multi-row Subqueries | August 28, 2020 | 07/10 | View |
| 8 | PL/SQL Procedures | Stored Procedures Implementation | September 09, 2020 | 08/10 | View |
| 9 | Database Triggers | Row-Level Triggers (Insert, Update, Delete) | November 24, 2020 | 08/10 | View |
| 10 | PL/SQL Cursors | Explicit & Implicit Cursors | December 02, 2020 | 07/10 | View |
Experiment 1: Introduction to SQL (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
01_Basic_SQL_Queries.sql |
DDL / DML | Basic table creation and data insertion | View |
Experiment 2: Constraints & Functions (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
02_Restricting_and_Sorting_Data.sql |
Constraints | Primary Key, Foreign Key, Check, etc. | View |
Experiment 3: Joins & Set Operations (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
03_Joins_and_Relationships.sql |
Joins | Inner, Outer Joins & Set Operations | View |
Experiment 4: Views & Subqueries (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
04_Aggregate_Functions_and_Views.sql |
Views | Creating Virtual Tables and Queries | View |
Experiment 5: DDL and Constraints (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
05_DDL_and_Constraints.sql |
DDL | Advanced table alteration and constraints | View |
Experiment 6: DML and TCL (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
06_DML_and_TCL.sql |
DML / TCL | Transaction control with Commit/Rollback | View |
Experiment 7: Subqueries (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
07_Subqueries.sql |
Subqueries | Single-row and Multi-row subqueries | View |
Experiment 8: PL/SQL Procedures (1 Program)
| Program | Category | Description | Code |
|---|---|---|---|
08_PLSQL_Procedures.sql |
PL/SQL | Stored Procedures implementation | View |
Experiment 9: Database Triggers (4 Programs)
| Program | Category | Description | Code |
|---|---|---|---|
09_1_Table_Creation.sql |
Setup | Creating Employee and Projects tables | View |
09_2_Trigger_Insert.sql |
Trigger | Automating updates on Insertion | View |
09_3_Trigger_Update.sql |
Trigger | Automating updates on Updation | View |
09_4_Trigger_Delete.sql |
Trigger | Automating updates on Deletion | View |
Experiment 10: PL/SQL Cursors (2 Programs)
| Program | Category | Description | Code |
|---|---|---|---|
10_1_Explicit_Cursor.sql |
Cursor | Explicit Cursor implementation (Join) | View |
10_2_Implicit_Cursor.sql |
Cursor | Implicit Cursor implementation (Update) | View |
| # | Documentation | Description |
|---|---|---|
| 1 | Lab README | Detailed navigation guide with program descriptions |
This mini-project implements a Car Rental Database Management System using PHP and MySQL, showcasing principles of database design, normalization, and SQL query integration in a web-based application.
Note
Research Impact & Certification: This mini-project was published as an academic research paper in the International Journal for Research in Applied Science & Engineering Technology (IJRASET) (Volume 9, Issue 7), with a scholarly Preprint available on viXra. The project received an official Publication Certificate for its research contribution to database management systems.
| # | Resource | Description | Date | Marks |
|---|---|---|---|---|
| 1 | Car Rental System | Complete source code and documentation | - | - |
| 2 | Project Report | Detailed project documentation | November 28, 2020 | 09/10 |
| 3 | Published Paper | IJRASET (Vol 9 Issue 7) Publication | July 2021 | - |
| 4 | Certificate | Publication Certificate | July 2021 | - |
Important
COVID-19 Impact: This coursework was completed during the COVID-19 pandemic. All examinations and assessments were conducted in a digital format.
| # | Resource | Description | Date | Marks |
|---|---|---|---|---|
| 1 | DBMS UT-2 | Unit Test 2 Assessment | 2020 | — |
| 2 | DBMS Online Test | Subject-specific online test | July 11, 2020 | 10/10 |
| 3 | All Subjects Test 1 | Collective subject test 1 | July 18, 2020 | 40/40 |
| 4 | All Subjects Test 2 | Collective subject test 2 | July 25, 2020 | 50/50 |
| 5 | All Subjects Test 3 | Collective subject test 3 | August 03, 2020 | 50/50 |
| 6 | All Subjects Test 4 | Collective subject test 4 | August 08, 2020 | 50/50 |
Final semester examination submission:
| # | Resource | Description | Date |
|---|---|---|---|
| 1 | Answer Sheet Q2 | Final Semester Exam Submission (Q.2) | January 09, 2021 |
| 2 | Answer Sheet Q3 | Final Semester Exam Submission (Q.3) | January 09, 2021 |
University of Mumbai examination papers from 2018-2019:
| # | Exam Session | Syllabus | Resource |
|---|---|---|---|
| 1 | December 2018 | CBCGS | View |
| 2 | May 2019 | CBCGS | View |
| 3 | December 2019 | CBCGS | View |
Course completion documentation with exit survey:
| # | Document | Description |
|---|---|---|
| 1 | Submission Report | Final coursework submission report |
| 2 | Exit Survey (Theory) | Course outcome survey for DBMS Theory |
| 3 | Exit Survey (Lab) | Course outcome survey for Database Management System Laboratory |
Official CBCGS Syllabus
Complete Third Year Computer Engineering syllabus document from the University of Mumbai, including detailed course outcomes, assessment criteria, and module specifications for Database Management System and Database Management System Laboratory.
Important
Always verify the latest syllabus details with the official University of Mumbai website, as curriculum updates may occur after this repository's archival date.
This repository is openly shared to support learning and knowledge exchange across the academic community.
For Students
Use these resources as reference materials for understanding SQL queries, database design concepts, and preparing for examinations. All content is organized for self-paced learning.
For Educators
These materials may serve as curriculum references, lab examples, or supplementary teaching resources. Attribution is appreciated when utilizing content.
For Researchers
The documentation and organization may provide insights into academic resource curation and educational content structuring.
This repository and all linked academic content are made available under the Creative Commons Attribution 4.0 International License (CC BY 4.0). See the LICENSE file for complete terms.
Note
Summary: You are free to share and adapt this content for any purpose, even commercially, as long as you provide appropriate attribution to the original author.
Created & Maintained by: Amey Thakur
Academic Journey: Bachelor of Engineering in Computer Engineering (2018-2022)
Institution: Terna Engineering College, Navi Mumbai
University: University of Mumbai
This repository represents a comprehensive collection of study materials, reference books, assignments, and personal preparation notes curated during my academic journey. All content has been carefully organized and documented to serve as a valuable resource for students pursuing Database Management System & Database Management System Laboratory.
Connect: GitHub · LinkedIn · ORCID
Grateful acknowledgment to Mega Satish for her exceptional contribution to this repository through "Mega's Notes" - comprehensive module-wise notes that became an invaluable resource for understanding complex database concepts. Her constant support, patience, and clarity throughout this journey made a real difference. Learning alongside her was transformative, not only because she explained concepts so clearly, but because she truly cared about understanding them together. Her thoughtful approach to teaching, openness to discussion, and steady encouragement turned challenges into meaningful learning moments. This work reflects the growth that came from learning side by side. Thank you, Mega, for everything you shared and taught along the way.
Grateful acknowledgment to the faculty members of the Department of Computer Engineering at Terna Engineering College for their guidance and instruction in Database Management Systems. Their clear teaching and continued support helped develop a strong understanding of database architecture.
Special thanks to the mentors and peers whose encouragement, discussions, and support contributed meaningfully to this learning experience.
Overview · Contents · Reference Books · Mega's Notes · Assignments · Quizzes · Laboratory · Mini-Project · Online Exam · Semester Exam · Question Papers · Submission Report · Syllabus · Usage Guidelines · License · About · Acknowledgments
🔬 Database Management System Laboratory · 🚗 Car Rental System
Computer Engineering (B.E.) - University of Mumbai
Semester-wise curriculum, laboratories, projects, and academic notes.