Your Guide to Database Management System

Course Duration: 12 weeks

Prerequisites: None

Week 1: Introduction to Databases and DBMS

• Data, Information, and Knowledge
• Need for Database Management Systems
• DBMS vs. File System
• Types of Databases: Hierarchical, Network, Relational, Object-Oriented
• Overview of Database Applications

Week 2: Database Architecture

• DBMS Architecture: 3-Tier and 2-Tier Architectures
• Data Models: Hierarchical, Network, Entity-Relationship (E-R), and Relational Models
• Data Independence: Physical and Logical
• Schema vs. Instance

Week 3: Entity-Relationship (E-R) Modeling

• E-R Model Basics: Entities, Attributes, and Relationships
• Primary Key, Foreign Key, and Constraints
• Enhanced E-R Models: Generalization, Specialization, Aggregation
• Mapping E-R Diagrams to Relational Models

Week 4: Relational Model and Relational Algebra

• Introduction to the Relational Model
• Relational Algebra: Selection, Projection, Union, Intersection, Cartesian Product, and Joins
• Relational Calculus: Tuple Relational Calculus and Domain Relational Calculus

Week 5: SQL – Structured Query Language

• Basics of SQL: Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL)
• SQL Queries: SELECT, INSERT, UPDATE, DELETE
• Aggregate Functions: COUNT, SUM, AVG, MAX, MIN
• Joins: INNER, OUTER (LEFT, RIGHT, FULL), SELF

Week 6: Advanced SQL Concepts

• Subqueries and Nested Queries
• Views and Indexes
• Triggers and Stored Procedures
• Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK

Week 7: Normalization

• Database Design Principles
• Functional Dependency and Anomalies
• Normal Forms: 1NF, 2NF, 3NF, BCNF
• Denormalization and Trade-offs

Week 8: Transaction Management and Concurrency Control

• ACID Properties
• Transaction States and Recovery
• Concurrency Issues: Dirty Reads, Lost Updates, and Phantom Reads
• Concurrency Control Techniques: Lock-Based, Timestamp-Based, Deadlocks

Week 9: Database Storage and Indexing

• File Organization: Sequential, Indexed, and Hashed Files
• Indexing: Single-Level, Multi-Level, B-Trees, and Hash Indexing
• Clustering and Partitioning
• RAID Levels

Week 10: NoSQL Databases

• Introduction to NoSQL Databases: Differences with SQL
• Types of NoSQL Databases: Document, Column-Family, Key-Value, Graph Databases
• Use Cases and Applications of NoSQL Databases
• Popular NoSQL Systems: MongoDB, Cassandra, and Redis

Week 11: Database Security and Performance

• Database Security Principles
• Authentication and Authorization
• Encryption Techniques for Databases
• Query Optimization Techniques
• Performance Tuning

• Design and Implement a Mini-Project Using a DBMS of Choice
• Create ER Diagrams, Normalize the Database, Write SQL Queries
• Demonstrate the Application’s Functionality and Database Interaction

Week 11: Database Security and Performance

• Design and Implement a Mini-Project Using a DBMS of Choice
• Create ER Diagrams, Normalize the Database, Write SQL Queries
• Demonstrate the Application’s Functionality and Database Interaction

Assessment

• Weekly Quizzes (20%)
• Midterm Exam (20%)
• Practical Assignments (30%)
• Capstone Project Presentation (30%)