Project Focus: Develop a database and write queries for that database.
Contribution/Role: Database Administrator
Technology/Skills: SQL and ERD
Description: Use an ERD to create a database using SQL. Once the database is created use SQL queries to access information within the database. Join together different tables and organize tables by categories.
Challenges: The first challenge was deciding what the primary and foreign keys were in the ERD. The next challenge was using SQL to create the database and add in the data. The last challenge was figuring out the correct way to join tables together even when the primary keys were different data types.
Reflections: I never realized how hard it can be getting one type of data to relate to another through primary and foreign keys. Working with databases made me think that a database administrator might be a good career choice.