Thanks, Chris & Jochem... Yes, I believe I understand...I've just never run into a situation that forced the usage of the third table for me...such as multiple positions for single employees...or perhaps I've just worked around it. Now I'll have to figure out how to change my queries to reflect the use of this third table...
I guess I just run "regular" insert, add, delete queries on the Positions and Employees tables, then when the time comes to assign a position to an employee, I'd list the employees, select one to the get the Employee_ID, then use a drop down of Postions to insert the Employee_ID and Position_ID into the Employee_Positions table. I guess I'd need to add an "Employee_Position_ID" to the third table? So it would be: Employee_Postions Employee_Position_ID Position_ID Employee_ID Is this proper perspective? Rick > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 14, 2005 2:25 PM > To: CF-Talk > Subject: Re: Database Normalization Question > > > Rick Faircloth wrote: > > > > Positions (Yes, I like plural table names :o) > > > > Position_ID (Primary Key) > > Position_Title > > Position_Description > > etc > > > > Employees > > > > Employee_ID (Primary Key) > > Position_ID (Relational Key) > > Employee_FirstName > > Employee_LastName > > etc > > <or> > > > Employee_Positions > > > > Employee_ID > > Position_ID > > > > > > It seems like the third table is used to tie the Positions table and > > Employees table together, > > > This may be a poor example of what I'm talking about. > > It is an excellent example. Just answer the following questions > and it should all become clear :) > > How many positions can an employee have in your first example? > How many positions can an employee have in your second example? > How many positions can an employee have in your company? > > Jochem > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
