PostgreSQL Exam - 14 October 2023

Problems

1.1. Database Design

Problem Description

Database

Author's Solution

2.2. Insert

2.3. Update

2.4. Delete

3.5. Players

3.6. Offensive Players without Team

3.7. Teams with Player Count and Fan Base

3.8. Coaches, Players Skills and Teams Overview

4.9. Stadium Teams Information

4.10. Player Team Finder