Diners, Drive-ins, and Dives
Creating tables and query in SQL
September 2021 - December 2021
Diners, Drive-ins, and Dives is a very famous show hosted by Guy Fiery that has been running for 43 seasons. Many people have used the show as a guide whenever they visit a new city. Thus, websites like this were created to help people look up restaurants that have appeared on the show. We were tasked to look at the website and reverse-engineer using SQL to understand the back end of the website. This includes creating tables using raw data, importing data into said tables, and querying specific information.
Phase 1: Entity Relationship Diagram
In order to understand how the website pulls the information based on categories, filters, and topics, I had to understand how each variable or column relates to the other. Thus, an ERD was created to better visualize the relationships.
Phase 2/3: Creating and Populating Tables
Using the ERD, our team was able to create the tables and populate them using the following codes: tables and populate tables, which produce the following results:
Phase 4: Query
Using the tables created, our team used this code to answer some questions querying information.
What I Learned
Technical Tools
This project was my first exposure to SQL. I learned the basics of SQL code, created and populated my first tables, and queried for information based on specific requests.
