https://docs.google.com/document/d/1rlPBT5P8brkdVcKlRWdiBxEoZynJI-6R6IPopq052go/edit?usp=sharing
2) Here is the sql file extracted from our Conceptual Data Modeling (CDM) made with the looping software:
https://docs.google.com/document/d/1mbQ7tfw88NMtBxFCgN_0Lyj_NLVKi6_SQ5mWolCY0_w/edit?usp=sharing
Once you have created your database, go to the sql tab and paste in the entire file with the sql instructions I have linked above. Here is the result in phpmyadmin :
For this project all the tabs are not functional, if we had to spend more time on it, I think we should make the "Requête" tab not be displayed for visitors but only for administrators with the statistics that allow to get out. Also make some tabs or buttons functional, for example only the map "Lyon esport 2021" is functional because it allowed to understand how the site works. It would only be necessary to duplicate our work to all the cards.
Feedback is highly appreciated, thank you!