|
|
|
A refers to relationship indicates that an instance of one entity stores the key value of one or more instances of another entity. In the application you are building, this is represented by assigning employees to tasks; the task stores the primary key value of the employee. An employee can be assigned to more than one task, even to more than one task in more than one project, but a task can have only one employee assigned to it.
A refers to relationship differs from an owned by relationship in that you do not want employee records to be deleted when a task is deleted, as an employee can be assigned to other tasks. However, a task should be deleted when its owning project is deleted, as a task is merely a subset of a project.
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |