I have been reading a lot of db normalization.
The question I have concerns mysql and joining and refrencing.

I realize that you can join a table to allow refrencing in other tables however I have just been reading through the devshed articals on normalization.


In this artical they use when creating the table a reference attrib so one column would be

category_id smallint unsigned not null references categories

categories being the other table. From this point forward you can reference anywhere within the multiple tables without any table joins.

I was wondering why this isn't a technique that is shown more often, or if I am interpreting the results incorrectly? This would seem to be a much easier and more efficient way to allow data portability throughout the db layout.