Creation of a database with PostgreSQL
L3
PostgreSQL
RDBMS
Relational model
Subject: As an artists agent, you have to create a database to keep track of all your clients.
We decided (in pair) to create a database of French rappers and regroupep informations such as the type of contracts, our artists commitmments, their salary, royalties, their agenda as well as the time, date, and location of their concerts, showcases and other events.
The project was carried out in 4 steps : a - Database modelling; b - Creation and filling of the tables; c - Commom operations and mandatory requests; d - Other requests database specific.