Total and partial participation in ERD
Let's say that works-in is a relationship between entity types Employee and Department and the cardinality is many to one. Does total participation of Employee in the works-in relationship in other words mean that if I ever put an employee in my database, I must provide a Department that the employee works in? In mathematical terms: Employee is put in a table <=> Employee has associated Department. Can someone explain this in simple terms involving the sets of the entities and that of the relationship? Thanks.
database erd
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
add a comment |
Let's say that works-in is a relationship between entity types Employee and Department and the cardinality is many to one. Does total participation of Employee in the works-in relationship in other words mean that if I ever put an employee in my database, I must provide a Department that the employee works in? In mathematical terms: Employee is put in a table <=> Employee has associated Department. Can someone explain this in simple terms involving the sets of the entities and that of the relationship? Thanks.
database erd
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
add a comment |
Let's say that works-in is a relationship between entity types Employee and Department and the cardinality is many to one. Does total participation of Employee in the works-in relationship in other words mean that if I ever put an employee in my database, I must provide a Department that the employee works in? In mathematical terms: Employee is put in a table <=> Employee has associated Department. Can someone explain this in simple terms involving the sets of the entities and that of the relationship? Thanks.
database erd
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
Let's say that works-in is a relationship between entity types Employee and Department and the cardinality is many to one. Does total participation of Employee in the works-in relationship in other words mean that if I ever put an employee in my database, I must provide a Department that the employee works in? In mathematical terms: Employee is put in a table <=> Employee has associated Department. Can someone explain this in simple terms involving the sets of the entities and that of the relationship? Thanks.
database erd
database erd
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
edited Nov 26 '18 at 11:04
Thomas Kilian
23.9k63864
23.9k63864
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
asked Nov 26 '18 at 3:08
LearningMathLearningMath
403422
403422
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You're question isn't entirely clear based on the information you gave.
For example: if an employee must have a department and each department must have an employee then it's total participation on both sides. (You cannot delete a department if it has an employee. And cannot delete an employee if it has a department with no other employees). Basically this means that those foreign keys cannot be null
However, if a department must have an employee but an employee doesnt have to have a department then the department has total participation and the employee has partial participation. Basically this means these foreign keys can be set to null.
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53474302%2ftotal-and-partial-participation-in-erd%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You're question isn't entirely clear based on the information you gave.
For example: if an employee must have a department and each department must have an employee then it's total participation on both sides. (You cannot delete a department if it has an employee. And cannot delete an employee if it has a department with no other employees). Basically this means that those foreign keys cannot be null
However, if a department must have an employee but an employee doesnt have to have a department then the department has total participation and the employee has partial participation. Basically this means these foreign keys can be set to null.
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
add a comment |
You're question isn't entirely clear based on the information you gave.
For example: if an employee must have a department and each department must have an employee then it's total participation on both sides. (You cannot delete a department if it has an employee. And cannot delete an employee if it has a department with no other employees). Basically this means that those foreign keys cannot be null
However, if a department must have an employee but an employee doesnt have to have a department then the department has total participation and the employee has partial participation. Basically this means these foreign keys can be set to null.
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
add a comment |
You're question isn't entirely clear based on the information you gave.
For example: if an employee must have a department and each department must have an employee then it's total participation on both sides. (You cannot delete a department if it has an employee. And cannot delete an employee if it has a department with no other employees). Basically this means that those foreign keys cannot be null
However, if a department must have an employee but an employee doesnt have to have a department then the department has total participation and the employee has partial participation. Basically this means these foreign keys can be set to null.
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
You're question isn't entirely clear based on the information you gave.
For example: if an employee must have a department and each department must have an employee then it's total participation on both sides. (You cannot delete a department if it has an employee. And cannot delete an employee if it has a department with no other employees). Basically this means that those foreign keys cannot be null
However, if a department must have an employee but an employee doesnt have to have a department then the department has total participation and the employee has partial participation. Basically this means these foreign keys can be set to null.
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
answered Nov 26 '18 at 3:29
Sarah HarberSarah Harber
212
212
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
add a comment |
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
I was referring to the situation where Employee works-in Department, and the employee has total participation meaning that for every employee i must have an associated department (every employee must participate in some pair (employee, department)). And the relationship is many to one, meaning that many employees can work in one department. Also, the department has a partial participation, meaning that a department may or may not participate in a pair (employee,department)). Does this mean: I add an employee in a table <=> Employee is connected to a Department (I must add department too)?
– LearningMath
Nov 26 '18 at 3:35
1
1
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
@LearningMath, please update your question instead of putting the clarification in a comment.
– Geert Bellekens
Nov 26 '18 at 6:42
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53474302%2ftotal-and-partial-participation-in-erd%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
