Cardinalities reference:

Actual Problems:

1) Does a record for A have a minimum of 0 or 1 related records in B? If O, the minimum cardinality from A's point of view is 0. If 1, the minimum cardinality from A's point of view is 1. 2) Does a record for A have a maximum of 1 or many related records in B? If 1, the maximum cardinality from A's point of view is 1. If many, the maximum cardinality from A's point of view is M. 3) Does a record for B have a minimum of 0 or 1 related records in A? If O, the minimum cardinality from B's point of view is 0. If 1, the minimum cardinality from B's point of view is 1. 4) Does a record for B have a maximum of 1 or many related records in A? If 1, the maximum cardinality from B's point of view is 1. If many, the maximum cardinality from B's point of view is M. Employee Project CE2 The purpose of this exercise is to practice determining cardinalities. Assigned to 21 DP2 Determine the cardinalities for each of the relationships in the following 10 problems. Use the 0, 1, and M notation that we used during class. Write your answers on this sheet above the numbers in the cardinality positions. During class Thursday, we will go over two of these problems determined by the class vote (see the extra-credit survey on Canvas). You can change your answers to these two problems before filling out a scantron with your answers during class Thursday 1 2 3 4 M Mas Min Max Problem #1 Some people possess a passport. Some people do not A person possesses at most one passport. Each passport is owned by one person (9.10) (11,12) School Bus Student 15,6) (78) Person Passport Problem 3 Some students ride a school bus to the Best Elementary School. Some students do not ride a school bus because they are within walking distance Students who ride a school bus are assigned to a specfic school bus. A school bus can be assigned up to 40 students. A few school buses are not assigned students because the only used if another bus souten Problem #2 1) Does a record for A have a minimum of 0 or 1 related records in B? If O, the minimum cardinality from A's point of view is 0. If 1, the minimum cardinality from A's point of view is 1. 2) Does a record for A have a maximum of 1 or many related records in B? If 1, the maximum cardinality from A's point of view is 1. If many, the maximum cardinality from A's point of view is M. 3) Does a record for B have a minimum of 0 or 1 related records in A? If O, the minimum cardinality from B's point of view is 0. If 1, the minimum cardinality from B's point of view is 1. 4) Does a record for B have a maximum of 1 or many related records in A? If 1, the maximum cardinality from B's point of view is 1. If many, the maximum cardinality from B's point of view is M. Employee Project CE2 The purpose of this exercise is to practice determining cardinalities. Assigned to 21 DP2 Determine the cardinalities for each of the relationships in the following 10 problems. Use the 0, 1, and M notation that we used during class. Write your answers on this sheet above the numbers in the cardinality positions. During class Thursday, we will go over two of these problems determined by the class vote (see the extra-credit survey on Canvas). You can change your answers to these two problems before filling out a scantron with your answers during class Thursday 1 2 3 4 M Mas Min Max Problem #1 Some people possess a passport. Some people do not A person possesses at most one passport. Each passport is owned by one person (9.10) (11,12) School Bus Student 15,6) (78) Person Passport Problem 3 Some students ride a school bus to the Best Elementary School. Some students do not ride a school bus because they are within walking distance Students who ride a school bus are assigned to a specfic school bus. A school bus can be assigned up to 40 students. A few school buses are not assigned students because the only used if another bus souten Problem #2