SportTech – Database Project

SportTech is a relational database system designed to manage sports competitions, teams, players, and match results.

The project includes full conceptual and logical design, table creation scripts, complex SQL queries, views, and triggers to ensure data integrity and dynamic updates.

---

🌐 Project Overview

• Conceptual schema creation (Entity-Relationship diagram)
• Logical schema transformation (Relational model)
• Database implementation in SQL
• SQL queries for data retrieval and management
• Creation of dynamic views
• Triggers to enforce business rules and automatic updates

---

🛠️ Technologies & Tools

• DBMS: PostgreSQL
• Query Language: SQL
• Data Modeling: Conceptual and logical design principles

---

📁 Repository Structure

SportTech-Database-Project/
├── docs/             → Project documentation and original assignment
│   ├── traccia.pdf
│   ├── Relazione_Project_Gruppo_14_A-H.pdf
│
├── sql/              → All SQL scripts
│   ├── creazione_tabelle.sql
│   ├── query.sql
│   ├── viste.sql
│   ├── trigger.sql
└── README.md

---

🚀 How to Use

1. Open the SQL scripts inside the sql/ directory.
2. Execute creazione_tabelle.sql to create the database schema.
3. Run query.sql for standard operations and data retrieval.
4. Load viste.sql to create dynamic views.
5. Apply trigger.sql to add business logic enforcement.
6. Reference docs/Relazione_Project_Gruppo_14_A-H.pdf for full project explanation.

---

📄 Documentation

• Project Report (PDF)
• Assignment (PDF)

---

👥 Contributors

• Ambrosone Alessandro
• Ciancio Vittorio
• Cuomo Ferdinando
• Di Maio Marco

---

📄 License

This project is licensed under the CC BY-NC-SA 4.0 License

You may share and adapt this work for non-commercial purposes only, as long as you give appropriate credit and distribute your contributions under the same license.
For commercial use, explicit permission from the authors is required.