Skip to content

💾 CS340 — Introduction to Database Systems

This course introduces the foundations of database systems, including data modeling, the relational model, SQL, normalization, and emerging database technologies. It focuses on how databases are designed, implemented, queried, and optimized using conceptual, logical, and physical modeling techniques.

This section contains structured study material including chapter notes, quizzes and practice questions, mind maps for selected chapters, a cheat sheet and symbols reference, and a full course summary in PDF format. The goal is a clear, practical resource for understanding database systems and preparing for exams and projects.

🧭 How to Use This Section

Depending on where you are in the course, use this section differently.

If you are following the course, start with the introduction and data modeling chapters, then continue in order. If you are revising, use the cheat sheet, symbols page, summaries, and quizzes. If you are working on the project, focus on the modeling, mapping, and SQL chapters.

🗂 Course Chapters

  • 1⃣ Chapters 1 & 2 — Introduction to Database Systems

    What databases are, characteristics and advantages of database systems, database users and roles, DBMS architecture, data models, schemas, and languages.

  • 2⃣ Chapters 3 & 4 — Data Modeling using ER & EER

    Entity-Relationship modeling, Enhanced ER including specialization and generalization, UML-based conceptual modeling, and designing complex database applications.

  • 3⃣ Chapter 5 — Relational Data Model & Constraints

    Relations, tuples, and attributes, keys and integrity constraints, entity integrity, and referential integrity.

  • 4⃣ Chapter 6 — Basic SQL

    SQL data definition, constraints and table creation, basic SELECT queries, and filtering.

  • 5⃣ Chapter 7 — Advanced SQL

    Nested queries, aggregation and grouping, views and virtual tables, and more complex SQL operations.

  • 6⃣ Chapter 8 — Relational Algebra

    Selection, projection, joins, and division — query formulation using algebraic operators.

  • 7⃣ Chapter 9 — ER to Relational Mapping

    Converting ER and EER diagrams into relational schemas, mapping entities, relationships, and constraints, and preparing designs for implementation.

  • 8⃣ Chapters 14 & 15 — Normalization

    Functional dependencies, first through third normal form and BCNF, decomposition, and schema optimization.

🌐 Emerging Database Topics

This section also covers topics beyond the traditional relational model — including an introduction to object-oriented databases, NoSQL concepts, and hands-on MongoDB CRUD operations through lab work.

🛠 Project & Applied Work

The final project brings the course together through database design and modeling, SQL implementation, team-based collaboration, and full demonstration and documentation. The modeling, mapping, and SQL chapters are the most directly relevant references for project work.

🗒 Study & Revision Material

In addition to the chapter notes, this section includes quizzes for multiple chapters, mind maps for selected topics, a cheat sheet and symbols reference, and a full course summary in PDF format. These are designed to support both deep understanding and efficient exam preparation.

Step Topic
1 Chapters 1 & 2 — Introduction and data modeling
2 Chapter 5 — Relational model and constraints
3 Chapter 8 — Relational algebra
4 Chapters 6 & 7 — Basic then advanced SQL
5 Chapter 9 — ER to relational mapping
6 Chapters 14 & 15 — Normalization
7 Mind maps, cheat sheet, and symbols page for revision
8 Quizzes to test understanding
9 Apply concepts in the final project

About This Material

These notes are based on my own coursework and personal study. The focus is on clarity, structure, and practical understanding. Content will continue to be refined and expanded over time.