DBMS: 100 Days 100 Learning Challenge 🚀

Welcome to the DBMS: 100 Days 100 Learning Challenge! This repository is dedicated to helping us master Database Management Systems (DBMS) from beginner to advanced levels over the course of 100 days. Each day, a new concept or topic will be covered with explanations, examples, and exercises.

📚 About the Challenge

The goal of this challenge is to provide a structured learning path for DBMS enthusiasts. Whether we're a complete beginner or looking to deepen your knowledge, this challenge will guide us through the essential concepts of DBMS.

• Duration: 100 Days
• Difficulty: Beginner to Advanced
• Topics Covered: Basic Introduction (2 Tier, 3 Tier, 3 Schema), ER Diagrams, Basic of Keys, Normalization, Transactions Control and Concurrency, SQL and Relational Algebra and more.

🚀 Getting Started

Prerequisites

• Basic understanding of programming.
• Familiarity with databases (helpful but not required).

How to Use This Repository

1. Clone the Repository:

   git clone https://github.com/Rupayan20/DBMS-Learn.git

2. Follow the Daily Lessons: Each day's lesson will be available in a separate folder named dayXX. The lesson includes:

   • Concept Explanation: A brief overview of the topic.
   • Examples: Practical examples to help us understand the concept.
   • Exercises: Practice problems to test our understanding.

3. Contribute and Share: You're encouraged to contribute by sharing your knowledge, fixing issues, or adding new exercises.

Directory Structure

📅 Week 01 ➕

📅 Day 01

• 📘 Introduction to DBMS
• 📂 Example of Database
• 📂 Example of DBMS

📅 Day 02

• 🗂️ File System vs DBMS
• ⚠️ Disadvantages of File System
• ✅ DBMS Advantages over File System

📅 Day 03

• 🏗️ 2 Tier Architecture with real life examples
• 🏛️ 3 Tier Architecture with real life examples

📅 Day 04

• 📜 What is Schema?
• 🛠️ How to Define Schemas

📅 Day 05

• 🗂️ Three Schema Architecture
• 🎚️ Three Levels of Abstraction

📅 Day 06

• 🔍 What is Data Independence
• ⚖️ Logical vs Physical Independence

📅 Day 07

• 📏 Integrity Constraints in Database with example

📅 Week 02 ➕

📅 Day 08

• 🔑 What is Candidate Key with Suitable Example
• 🔑 What is Primary Key with Suitable Example

📅 Day 09

• 🔑 What is Primary Key in DBMS
• 📚 Primary Key with examples

📅 Day 10

• 🔗 Foreign Key in DBMS
• 📚 Full Content with examples

📅 Day 11

• 🛠️ Insert, Update & Delete from Foreign Key Table
• ⚖️ Referential Integrity

📅 Day 12

• ❓ Question on Foreign Key

📅 Day 14

• 🗂️ Introduction to E-R Model

📅 Week 03 ➕

📅 Day 15

• 🔍 Types of Attributes in E-R Model | Full Concept

📅 Day 16

• 🔗 One to One Relationship in DBMS

📅 Day 17

• 🔗 One to Many Relationship in DBMS

📅 Day 18

• 🔗 Many to Many Relationship in DBMS
• 🔗 M-N Relationship

📅 Day 19

• ❓ Question to Minimize Tables in E-R

📅 Day 20

• 📚 Introduction to Normalization
• 🔗 Insertion, Deletion & Update Anomaly

📅 Day 21

• 🔍 First Normal Form in DBMS

📅 Week 04 ➕

📅 Day 22

• 🔍 Finding Closure of Functional Dependency in DBMS
• ✏️ Easiest & Simplest Way

📅 Day 23

• 🧩 Functional Dependencies & Its Properties in DBMS

📅 Day 24: Coming Soon

• 🗃️ Second Normal Form
• 📚 2NF | Database Management System

📅 Day 25: Coming Soon

• 🗃️ Third Normal Form in DBMS with Examples
• 📊 Normalization

📅 Day 26: Coming Soon

• 🏛️ Boyce Codd Normal Form
• 📘 BCNF Normalization with Best Example

📅 Day 27: Coming Soon

• 🧩 BCNF Always Ensure Dependency Preserving Decomposition?
• 📊 Normalization Example

📅 Day 28: Coming Soon

• 🔍 Lossless and Lossy Decomposition
• 🗂️ Fifth Normal Form in DBMS

Contributing

We welcome contributions from the community! If you have notes, examples, or improvements to share, please submit a pull request or open an issue.

Project Contributors

• Rupayan Dutta

Learn SQL

If you want to know more about SQL, please visit my SQL Practice Repository.