Skip to content

Instantly share code, notes, and snippets.

@ya-liu
Forked from trentgoing/001 - Journal Homepage.md
Last active September 12, 2021 06:39
Show Gist options
  • Save ya-liu/614848f8aa294057d075138a17d3dffd to your computer and use it in GitHub Desktop.
Save ya-liu/614848f8aa294057d075138a17d3dffd to your computer and use it in GitHub Desktop.
FEC Engineering Journal

FEC 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 Catwalk.

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