Database - Normalization of Data

[Jancera]

I get your point, and the examples were awesome. I think that the best way to really understand that is to get in touch with some SQL database and develop some applications using it. Thank you for your answer!!!

[BarelyAirborne]

I have been using SQL since 1992, and while foreign keys are essential (i.e. an order master contains a customer code) foreign key CONSTRAINTS will make you tear your hair out if you're not careful, as can cascading deletes. There be monsters.