I spent six months learning database structures and SQL. At the end of my course we created a database from scratch.
I started by creating a data dictionary that described each table and its columns. I then used the dictionary as a jumping off point to create the entity relationship diagram.
After the foundations of the database were created, I forward engineered the entity relationship diagram into functional queries that could then be executed to form the database. Below is an example of the queries. All queries that generated the database are available at the button below.
We created a system in PHP Storm that took in unnormalized data and sorted it into the database. (see below and on Google Drive)
After importing data from PHP Storm, We also used PHP storm to run queries from outside MYSQL workbench. Using these queries we made reports on html pages to visualize the tables.
Creating this database taught me the fundamentals of formatting, managing, and querying a database.