Solution for Database Drills: Designing Schemas
Solution for Challenge: Database Drills: Designing Schemas. Started 2014-02-11T00:25:27+00:00
###Database Schema Diagrams
student roster
One to many
one to one
many to many
###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!