Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
liuk
Starting Member
5 Posts |
 Posted - 2007-03-16 : 07:21:43
|
| hi,in my database i have a situation similar to : Entity : EMPLOYEE - PROJECT - TOOLRelationship : Works_Using (ternary relationship)The problem is that Not necessary an employee use a tool on a project.I have been told that a better design should use an Aggregate entity that covers Emplooy-works-Project and a relationship between Tool as this one.The question is : how aggregate relationship are mapped in a db?It's only a way to represent relationship? or what?thanks |
|
|
VincentFrandsen
Starting Member
39 Posts |
Posted - 2007-03-18 : 08:28:19
|
| i'm not sure what your end goal is... i'd guess you want to asaign tools to a project and an employee on that project... do you need to keep records of what days the tool was on that project and records of what days the employee was on the projectweeks, days, minutes or seconds Give me a little more info please...Vincent Fradnsen |
 |
|
|
|
|
|
aggragate entity set