This gist details the decisions I made, the tests I conducted, the observations recorded, and the directions I took while building out an API for Project Greenfield.
-
-
Save nsbernstein52/c97c00f9b2c77563ef68da2ec8ba9a1e to your computer and use it in GitHub Desktop.
Today was the first day of the project. I spent the morning reviewing expectations and diving into my work...
Given the challenge of rebuilding the API for the project, I started by identifying what data needed to be stored. From there, I worked to design how this could fit within my RDBMS.
I designed a schema with 6 tables to hold the needed data. The schema I decided on ended up being this:
It was interesting to note the number of different ways I could design my schema for the same data set. Ultimately my decision to go with _ was based on _.
I recieved the data for the application. It was very unlike my initial schema design.
In order to insert the application data, I needed to transform it into my expected format. In order to do so...
I have a fantastic database that now contains ALL of my application's data!!!