Working in a team, I developed a database from the ground up. I was one of four members of a group to build a database using MariaDB to create the table structures using SQL, and PHP to create a dynamic website. The database aggregated information about Austin’s Farmer’s Markets. To collect the data, we collected information on site at every market, spoke with farmers who regularly attended markets, and collected information from various farms’ websites.
Click here to view the database!
Here is the slideshow created to present our farmer’s market database. In this presentation, we give an overview of the coding aspects of this project, as well as the inspiration for creating a database to aggregate the information.
This team also developed training material for using PHP to extract information from SQL Tables. Below is the slideshow: