Relationships as a table
From: Vinodh Kumar P <vinodh_at_here.com>
Date: Tue, 30 Nov 2004 13:05:33 +0530
Message-ID: <coh7s7$6hm$1_at_news.mch.sbs.de>
I have the tables tblEmployees and tblProjects. tblProjects has one column called Percentagetime, to hold the percentage of time by an employee for a project.
Date: Tue, 30 Nov 2004 13:05:33 +0530
Message-ID: <coh7s7$6hm$1_at_news.mch.sbs.de>
I have the tables tblEmployees and tblProjects. tblProjects has one column called Percentagetime, to hold the percentage of time by an employee for a project.
My Question : Why should we introduce a 3rd table called
tblProjectsAndEmployees?
tblProjectsAndEmployees will have
1)EmployeeNumber(PrimaryKey in tblEmployees) 2)ProjectNumber(Primary key in tblProjects) 3)PercentageTime
Having only the tblEmployees and tblProjects is not sufficient?
Kind Regards,
Vinodh Kumar P
Received on Tue Nov 30 2004 - 08:35:33 CET