1 1 0 0 0 0 0 0 1 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 0 0 423000000 1 32 1024 768 2989000000 0 2566000000 0 423000000 10.000000 1.000000 2 4478 65 1 22050 0 49 0 Data Modeling Concepts: Degree 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 1 423000000 903000000 1 32 1024 768 2989000000 423000000 2086000000 423000000 903000000 10.000000 1.000000 2 4478 65 1 22050 0 49 1 Data Modeling Concepts: Degree 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 2 903000000 1167000000 1 32 1024 768 2989000000 903000000 1822000000 903000000 1167000000 10.000000 1.000000 2 4478 65 1 22050 0 49 2 Data Modeling Concepts: Recursive Relationship 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 3 1167000000 1720000000 1 32 1024 768 2989000000 1167000000 1269000000 1167000000 1720000000 10.000000 1.000000 2 4478 65 1 22050 0 49 3 Data Modeling Concepts: Foreign Keys 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 4 1720000000 2052000000 1 32 1024 768 2989000000 1720000000 937000000 1720000000 2052000000 10.000000 1.000000 2 4478 65 1 22050 0 49 4 Data Modeling Concepts: Nonspecific Relationships 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 5 2052000000 2356000000 1 32 1024 768 2989000000 2052000000 633000000 2052000000 2356000000 10.000000 1.000000 2 4478 65 1 22050 0 49 5 Resolving Nonspecific Relationships 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08bSummary\Chap08bSummary.avi 0 6 2356000000 2988000000 1 32 1024 768 2989000000 2356000000 1000000 2356000000 2988000000 10.000000 1.000000 2 4478 65 1 22050 0 49 6 Resolving Nonspecific Relationships (continued) 1 0 Data Modeling Concepts: Degree 1 0 423000000 Data Modeling Concepts: Degree 1 1 903000000 Data Modeling Concepts: Recursive Relationship 1 2 1167000000 Data Modeling Concepts: Foreign Keys 1 3 1720000000 Data Modeling Concepts: Nonspecific Relationships 1 4 2052000000 Resolving Nonspecific Relationships 1 5 2356000000 Resolving Nonspecific Relationships (continued) 1 6 32 000 Teaching Notes The example also depicts an associative entity for the first time…as explained on the next slide. No additional notes Teaching Notes Ask the students to read (or write) declarative sentences to reflect the bidirectional meaning of the relationship. We created a composite key in this example. Be sure to point out the notation. Another classic example of a recursive relationship is in an Employee entity with a Supervisor attribute that holds the identifier of the supervisor’s instance of that same Employee entity. Teaching Notes Have students identity which is the parent entity (Major) and which is the child (Student). Additional examples should be given to test the student’s ability to recognize the parent entity. We suggest you also provide an example of a one-to-one relationship! Teaching Notes You may need to refer to the earlier slide that defines an associative entity In the bottom diagram we see that a student can declare multiple majors and that a curriculum can offer multiple majors. Note that for associative entities the cardinality from child to parent is always one and only one. An instance of MAJOR must correspond to one and only one STUDENT and to one and only one CURRICULUM. Teaching Notes Part (c) of Figure 8-9 is on the next slide No additional notes