Database Systems (DBS) Course Project

This repository contains my progress and assignments for the Database Systems (DBS) course at the Czech Technical University in Prague (CVUT). The project focuses on the full lifecycle of database design, from conceptual modeling to complex SQL implementation.

🚀 Project Overview

The goal of this project is to design and implement a robust relational database for a E-shop.

Key Learning Objectives:

• Conceptual Modeling: Designing ER (Entity-Relationship) diagrams.
• Relational Algebra: Formulating queries using formal logic.
• SQL Development: Writing DDL (Data Definition Language) and DML (Data Manipulation Language) scripts.
• Database Normalization: Ensuring data integrity up to 3NF/BCNF.

📂 Repository Structure

• task1/ — Conceptual Model: ER Diagrams and description of business logic.
• task2/ — (Optional) Relational Schema and Functional Dependencies.
• task3/ — (Optional) SQL Scripts for table creation and data seeding.
• task4/ — (Optional) Advanced SQL queries (SELECT, JOINs, Procedures).

🛠 Tech Stack

• Database: PostgreSQL (or specify your DB)
• Modeling Tools: Draw.io / Database Workbench
• Language: SQL

---

Created by Kateryna Golyak as part of the DBS course at FEL CVUT.