Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save nsbernstein52/c97c00f9b2c77563ef68da2ec8ba9a1e to your computer and use it in GitHub Desktop.
Save nsbernstein52/c97c00f9b2c77563ef68da2ec8ba9a1e to your computer and use it in GitHub Desktop.
SDC Engineering Journal

SDC Engineering Journal

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.

Goals

Achievements

Reflections

Daily Summary

Database Design and Creation

2019-07-26

July 26, 2019

Overview

Today was the first day of the project. I spent the morning reviewing expectations and diving into my work...

Log

8:00am - Designed Schema

Challenge/Motivation

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.

Actions Taken

I designed a schema with 6 tables to hold the needed data. The schema I decided on ended up being this:

Results Observed

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 _.

11:00am - 1st attempt loading data

Challenge/Motivation

I recieved the data for the application. It was very unlike my initial schema design.

Actions Taken

In order to insert the application data, I needed to transform it into my expected format. In order to do so...

Results Observed

I have a fantastic database that now contains ALL of my application's data!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment