Create a database system based on the information provided on all the programming problem sets on the site, all the contests it was used in divisions $1$ & $2,$ the users$/$teams who attempted them and their standings $($e$.$g$.$ Problem Set, Users, Contest$)$

Your database design should store all the information about the contests in Div$\mathrm{.}1$ and Div$\mathrm{.}2,$ including but not limited to: its name, date, writers, division, registered participants, final standing, and the problem sets used in it$.$ You should also store information about all the existing problem sets on the website, including the problem set name, the tags for the fields it is related to$,$ the time and memory limit per test, as well as all the users who attempted the problem set, including the user, the date$/$time of the attempt, the verdict, the language used, the time and memory spent for the solution, and all the contests it was used in$.$

The system should also keep track of the contestants $/$ users who participated in either a competition or attempted a problem set, including their screen names, city, country, organization they belong to$,$ contributions, number of friends, duration of the registration, number of problems solved and number of days in a row for all the time the users was registered on the site.