---
title: "Database Management System"
source: https://www.bctengineer.com/subjects/semester_6/database_management_system
site: BCT Engineering
---
# Database Management System

## Syllabus & Important Questions
- **Syllabus** – [Download PDF](https://drive.google.com/file/d/122iP8NIFAy3tTnoEGSW9rZpl_UfKTkSA/view?usp=sharing)
- **Important Question Lists** – [Download PDF](https://drive.google.com/file/d/13otC61UbJBrMcUFvU9yomJpOiRFfSWX9/view)

---

## Chapters
- **Chapter 1** – [Introduction](https://drive.google.com/file/d/1-In8vtv6Z3pOJ0boiUXhxZJbbgn-gYCZ/view?usp=drivesdk)
- **Chapter 2** – [Data Models](https://drive.google.com/file/d/1-WPy0L0bWu6GI8zh0Cc3vd2kjJ5M5mlb/view?usp=drivesdk)
  - [Important ER diagrams & solutions](https://drive.google.com/file/d/14BhFBNzCH9qRufagRXAMxn9bIrOO0vPM/view?usp=drivesdk)
- **Chapter 3** – [Relational Languages & Relational Model](https://drive.google.com/file/d/1-zaZDxVK8INRAYEcmTJDsTeryV7IJ6nV/view?usp=drivesdk)
  - [Query examples](https://drive.google.com/file/d/14IuinHnzwRuj8lcNR_r_5W61ZEjnumIo/view?usp=drivesdk)
  - [Relational algebra examples](https://drive.google.com/file/d/14QyH5TWXYh5f1bnJ-3kPA5M2BY4aX9q0/view?usp=drivesdk)
  - [QBE (up to p. 14)](https://drive.google.com/file/d/16KjpwgHVZidkHrQl5NN3oxUiMiem2Mng/view?usp=drivesdk)
- **Chapter 4** – [Database Constraints & Normalization](https://drive.google.com/file/d/117n9EimiWLBGtaRim-vrgLLt77kjNOHJ/view?usp=drivesdk)
- **Chapter 5** – [Query Processing & Optimization](https://drive.google.com/file/d/119cG6N8Dn2DpxO7GJT7eMXEIkB1CqQPm/view?usp=sharing)
- **Chapter 6** – [File Structure & Hashing](https://drive.google.com/file/d/12_KQozyoIL5B2qovcuZhBfrH2s3fetM7/view?usp=drivesdk)
  - [RAID](https://drive.google.com/file/d/1l3_l_QYFmym-v7tAJv8i0PtA4zpifMcL/view?usp=sharing)
- **Chapter 7** – [Transaction Processing](https://drive.google.com/file/d/12XHcP6y5oSlSqWdJxIGqHJvYdeuwpfta/view?usp=drivesdk)
- **Chapter 8** – [Crash Recovery](https://drive.google.com/file/d/12YR9t377nIuKajvyw2gPmSkhX6S6Z-r-/view?usp=drivesdk)
- **Chapter 9** – [Advanced Database Concepts](https://drive.google.com/file/d/12gcWpUOGacPqwAMP0vZLv-tc-nroLDh9/view?usp=drivesdk)

---

## Notes & Solutions
- [Balkrishna Sir – All Chapter Notes](https://drive.google.com/file/d/1HDTp_AsOCHs5-ScVmmzCbRvc9QSQ8jXB/view?usp=drivesdk)
- [All Chapter Important Questions Only](https://drive.google.com/file/d/1k9av_eT96Z1qjlsOXBbrNH6ZVv2RfqU-/view?usp=sharing)

---

## SQL & ER Diagram Practice
- [ER Diagram Questions](https://drive.google.com/file/d/16jh9K-KKFQnZ4Gtd87kQu17QIyIQVjkG/view?usp=sharing)
- [ER Diagram Last-Moment Tuitions (YouTube)](https://www.youtube.com/watch?v=leMKD3okIMk&list=PLAXUYU7PbJhiK6OgoNifVFGj8yBro3-6s)
- [ER Diagram Videos](https://www.youtube.com/playlist?list=PLQwnNNzUErhZXXdzXoxsfsy3j0fsB3vQZ)
- [Basic SQL Queries](https://drive.google.com/file/d/1UT8b12Z0GPSW6TJ82cRBe2DHe6ohw4MQ/view?usp=drivesdk)

---

## YouTube Playlists (Core)
- **Ch 1:** [Introduction to DBMS](https://www.youtube.com/playlist?list=PLAXUYU7PbJhhjUo_Af82OqTPhdhTvWuRg)
- **Ch 2:** [Data Models](https://www.youtube.com/playlist?list=PLAXUYU7PbJhiRMD6Rzg0QVdt0JrVyKw4n), [ER Diagrams](https://www.youtube.com/playlist?list=PLAXUYU7PbJhjsxPafvUYww7Ou-5AiE632)
- **Ch 3:** [Relational Languages & Model](https://www.youtube.com/playlist?list=PLxCzCOWd7aiHqU4HKL7-SITyuSIcD93id), [SQL Query](https://www.youtube.com/playlist?list=PLAXUYU7PbJhib9Q8DdO_JiD7_byfA3g1F)
- **Ch 4:** [Constraints & Normalization](https://www.youtube.com/watch?v=76G4NAAXgYM&list=PLAXUYU7PbJhh3RoJqmjM7K9nvXA6GHe02)
- **Ch 5:** [Query Processing & Optimization](https://www.youtube.com/playlist?list=PLAXUYU7PbJhgPKs1D5fVz8mT9R_wUKabT)
- **Ch 6:** [File Structure & Hashing](https://www.youtube.com/watch?v=umlOEbXJ1oY&list=PLAXUYU7PbJhhAofZ_I0vNR1lAlpNNWVYG)
- **Ch 7:** [Transaction Processing](https://www.youtube.com/watch?v=s57648-bbOs&list=PLAXUYU7PbJhil36UAfGmYp-QJ4Qvi3smZ)
- **Ch 8:** [Crash Recovery](https://www.youtube.com/watch?v=0_DnBLn3nqg&list=PLAXUYU7PbJhiE9ygvMY8zmR1THO8_Dasr)
- **Ch 9:** [Advanced Database Systems](https://www.youtube.com/playlist?list=PLAXUYU7PbJhh6m7FH-P_YY95jaqRHZ-7W)

---

## Further Reading
- [Database Management System – Ramakrishnan & Gehrke](https://drive.google.com/file/d/1r2IchgfEw8OAJ_LAWmwynP4g_XnwIo27/view?usp=sharing)
- [DBMS Korth Solutions Manual](https://drive.google.com/file/d/1r2IchgfEw8OAJ_LAWmwynP4g_XnwIo27/view?usp=sharing)
- [Tutorials Point Notes (ER Diagram Intro)](https://drive.google.com/file/d/1McsRPXvn6uiAX1A8M91ZF5rLeReMFzEK/view?usp=sharing)