carolineartz
2/11/2014 - 12:25 AM

Solution for Database Drills: Designing Schemas

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!