Poznan University of Technology – AI Specialization
Course: Database Systems
Instructor: Dr. Serhii Baraban
This project focuses on data modeling — transforming business rules into:
- Crow’s Foot Entity–Relationship Diagram (ERD)
- UML Class Diagram
- Relational Schema (SQL)
You will work individually on one of the predefined variants (1–80).
- Student Name: [Your Full Name]
- Student ID: [Your ID]
- Variant: [XX]
- Scenario Title: [see
/docs/variant_list.csv]
- Write business rules describing the scenario.
- Create a Crow’s Foot ERD (
/diagrams/ERD.png). - Draw the UML Class Diagram (
/diagrams/UML.png). - Build a Relational Schema in SQL (
/sql/schema.sql). - Add a short report or explanation (
/report/report.pdf).
Use any of the following:
- ERD: draw.io, Lucidchart, or Visual Paradigm
- UML: PlantUML, draw.io UML
- SQL: Oracle APEX, PostgreSQL, SQLite, or MySQL
/diagrams/
ERD.png
UML.png
/sql/
schema.sql
/report/
report.pdf
/docs/
variant_list.csv (provided by instructor)
| Aspect | Weight | Description |
|---|---|---|
| Business rules | 20% | Clarity, completeness, and correctness |
| ERD | 25% | Proper notation, cardinality, PK/FK design |
| UML diagram | 20% | Correct mapping from ERD |
| SQL schema | 25% | Normalization and implementation accuracy |
| GitHub usage | 10% | Commits, structure, and documentation |
Push all required files to your GitHub Classroom repository before the deadline.