Skip to content

Instantly share code, notes, and snippets.

@carolineartz

carolineartz/Database_Drills:_Designing_Schemas_solution.md

Last active August 29, 2015 13:56
Show Gist options
  • Save carolineartz/964f81e3ad6682b0159d to your computer and use it in GitHub Desktop.
Save carolineartz/964f81e3ad6682b0159d to your computer and use it in GitHub Desktop.
Download ZIP
Solution for Database Drills: Designing Schemas
Raw
Database_Drills:_Designing_Schemas_solution.md

Solution for Challenge: Database Drills: Designing Schemas. Started 2014-02-11T00:25:27+00:00

###Database Schema Diagrams student roster
student roster

One to many
one to many schema

one to one
one to one schema

many to many
many to many schema

###Reflection My past experience with relational database design was helpful on this challenge. I have always had a tough time with identifying the best datatypes for the attribute definitions. For this challenge I struggled both in terms of definition specifications for this sql implementation as well as from a database optimization standpoint. Further, I wonder what best practices are for NULL vs empty etc. I still need to do some additional browsing around others' gists!

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