Results 1 to 4 of 4
Thread: Joining vs referencing
Nov 16, 2001, 18:14 #1
- Join Date
- Oct 2001
- Whistler BC originally from Guelph Ontario
- 0 Post(s)
- 0 Thread(s)
Joining vs referencing
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.