The third table allows for a many to many relationship. So a person can have more then one position in your example.
----- Original Message ----- From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, April 14, 2005 2:08 PM Subject: Database Normalization Question > Greetings, all... > > Instead of two tables like this: > > 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 > > > > I've seen many use examples of three tables, a third table > which seems to be the way of creating relationships between tables. > I just typically do it with two tables and what I always thought of as a > "Foreign Key", which may not be the accurate term anyway. Here's > a probably poor example of the three table scheme I've seen: > > Positions > > Position_ID (Primary Key) > Position_Title > Position_Description > etc > > Employees > > Employee_ID (Primary Key) > Employee_FirstName > Employee_LastName > etc > > Employee_Positions > > Employee_ID > Position_ID > > > It seems like the third table is used to tie the Positions table and > Employees > table together, but I don't see the benefit of creating that third table > when I can just put the Position_ID in the Employees Table... > > This may be a poor example of what I'm talking about. I can't think of an > exact example I've seen, but those of you who do this will know, probably, > what I've referring to. I thought I've been doing correct normalization. > Using the third table seems to cause the use of repeated data and more > tables than the first example...so why is it done? What am I missing in > my database design, which, of course, would determine how I have to code in > CF > and SQL... > > Rick > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:202811 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54