Schema

1. Structure
2. Datatypes
3. M-M, 1-1, 1-M

Foreign Key

1. What is it
2. Does it need to be constrained

Naming Convention

1. Naming convention
   • Snake Case

Discuss relationship

1. 1-M
2. M-M
3. 1-1

Progression of nastiness

1. one row with tons of columns
2. many rows with repeat data
3. Properly formatted db with multiple rows

class classid student teacher g 1 1 4 g 1 2 4 g 3 3 3 a 2 3 2

1. Student/Class/Teachers -
   • Progressing from grade to high school
   • What about lunch lady?
2. Nouns/adjectives/details
3. 1-M: k-6 class/students,
4. 1-1: Teachers to classes/ could include in class table but what about lunch lady?
5. Scale it up bad examples - Classes and students in high school
6. Scale it up again: M-M: Teacher_classes_role - college example
7. students-grades-/-assignments-classes

To do

• K6 Okay example
• High sclool less nasty example
• High school nasty example
• High school pretty example
• College okay example