Soccer league

Entity Relationship Diagram

Description

Project written because of Database systems classes taking place in the seventh semester in the field of study of "Automatics and robotics" at the AGH University of Science and Technology in Cracow.

Project structure

│   create.sql
│   drop.sql
│   insert.sql
│
└───queries:
        all-dutchmen.sql
        at-least-two-assists-in-one-match.sql
        attendance-less-than-half.sql
        best-assists.sql
        goals-of-teams.sql
        hungarias-poles-russians.sql
        psq-away.sql
        sum-assists.sql
        wisla-cracow-matches.sql
        won-home.sql

Features

create.sql creates 6 entities connected 9 relations [stadiums, teams, players, matches, results and scores].

insert.sql adds rows to these tables - 12 stadiums and teams, 11 players to each team and results of 24 matches with details.

drop.sql deletes all of data.

Remaining SQL scripts form the basis further work on the database.

How to run?

Enter into terminal: psql -U postgres -f create.sql to create tables.

Then: psql -U postgres -f insert.sql to add default data.

Comments

PDF report in Polish

License

MIT