(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Question

Want to see the full answer?

Answer 1

Question

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Question

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Answer 6

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Answer 7

Chapter 2, Problem 2.35PAE

Program Plan Intro

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Answer 8

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Answer 9

Program Plan Intro

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

Answer 10

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Answer 11

Program Plan Intro

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

Answer 12

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Answer 13

Program Plan Intro

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 17

Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQ Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQ Ch. 2 - Prob. 2.5RQ Ch. 2 - Prob. 2.6RQ Ch. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQ Ch. 2 - Prob. 2.9RQ Ch. 2 - State three conditions that suggest the designer...

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

Concept explainers

Videos

(a) For the E-R diagram provided, you will notice that cardinalities are not included on the works for relationship. State a business rule for this relationship and then represent this rule with the cardinalities that match your rule.

(b) For the E-R diagram provided, state a business rule that would make the Located In relationship redundant (i.e. where the school in which a club is located can be summarized or derived in some way from other relationship)

(c) For the E-R diagram provided, suppose a student could work for only a school the students attend but might not work. Would the works for relationship still be necessary, or could you represent whether a student works for the school she attends in some other way?

(d) For the E-R diagram provided, based on the rules of the ERD in the given figure, is it possible for a student to belong to a club located in a school that the student does not attend. Provide explanation for same.

Want to see the full answer?

Chapter 2 Solutions