Re: Relationships as a table

"Vinodh Kumar P" <vinodh_at_here.com> wrote in message news: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
>
>
>

Please don't cross-post. As for the answer, look in your textbook. Received on Tue Nov 30 2004 - 16:02:07 CET