A database to manage concert venues in Brussels.

• Conceptual schema
• Logical schema

• SQL DDL
• SQL checks
• SQL triggers
• SQL access control
• SQL views

-- 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;

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).

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