A database to manage concert venues in Brussels
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
schemas
sql
LICENSE.md
README.md

README.md

Concert Database Creation

A database to manage concert venues in Brussels.

Preview

Alt text

Content

Example query

-- Show all future Lady Gaga concerts
SELECT
    Nom_Scene,
    Partie,
    S.Nom_Lieu,
    Nom_Salle,
    Date,
    Heure_Debut,
    HEURE_Fin
FROM PRESTATION P
INNER JOIN ARTISTE A ON P.ID_Artiste = A.ID_Artiste
INNER JOIN CONCERT C ON P.ID_Concert = C.ID_Concert
INNER JOIN SALLE S ON C.ID_Salle = S.ID_Salle
WHERE Nom_Scene LIKE '%lady gaga%'
ORDER BY Date;

Purpose

This database is meant to be used by all stakeholders involved with concerts in Brussels to facilitate management, updating and information sharing.

This database could help with numerous stakeholders, notably:

  • customers, who would benefit from a more streamlined search;
  • resellers, thanks to a common ticket format;
  • artists and their teams, who could quickly compare venues (based on capacity for instance).

License

This project is licensed under the MIT License - see the LICENSE.md file for details.