|
customer |
|||
|
customerid |
int(5) |
PK |
Not Null |
|
custnumber |
int(5) |
Not Null |
|
|
custfname |
vc() |
Null |
|
|
custmname |
vc() |
Null |
|
|
custlname |
vc() |
Null |
|
custstreet |
int(5) |
PK |
Not Null |
|
custcity |
int(5) |
Not Null |
|
|
custstate |
vc() |
Null |
|
|
custzip |
vc() |
Null |
|
|
custphone |
vc() |
Null |
|
|
custemail |
vc() |
Null |
When you add a field to a table you must ask yourself, “Can there be more than one of these?”
https://www.youtube.com/watch?v=IpbvtSQvgWM
Can a Customer have more than one….
Address?
Phone Number?
email?
If the answer is YES that data gets it’s own table or the database is not L1 Normalized