1 1 0 0 0 0 0 0 1 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 0 0 1091000000 1 32 1024 768 6401000000 0 5310000000 0 1091000000 10.000000 1.000000 2 4478 65 1 22050 0 49 0 Generalization Hierarchy 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 1 1091000000 1835000000 1 32 1024 768 6401000000 1091000000 4566000000 1091000000 1835000000 10.000000 1.000000 2 4478 65 1 22050 0 49 1 Process of Logical Data Modeling 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 2 1835000000 4443000000 1 32 1024 768 6401000000 1835000000 1958000000 1835000000 4443000000 10.000000 1.000000 2 4478 65 1 22050 0 49 2 Logical Model Development Stages 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 3 4443000000 4790000000 1 32 1024 768 6401000000 4443000000 1611000000 4443000000 4790000000 10.000000 1.000000 2 4478 65 1 22050 0 49 3 Entity Discovery 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 4 4790000000 4990000000 1 32 1024 768 6401000000 4790000000 1411000000 4790000000 4990000000 10.000000 1.000000 2 4478 65 1 22050 0 49 4 Data Analysis & Normalization 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 5 4990000000 5400000000 1 32 1024 768 6401000000 4990000000 1001000000 4990000000 5400000000 10.000000 1.000000 2 4478 65 1 22050 0 49 5 Normalization: 1NF, 2NF, 3NF 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 6 5400000000 5543000000 1 32 1024 768 6401000000 5400000000 858000000 5400000000 5543000000 10.000000 1.000000 2 4478 65 1 22050 0 49 6 First Normal Form Example 1 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 7 5543000000 5966000000 1 32 1024 768 6401000000 5543000000 435000000 5543000000 5966000000 10.000000 1.000000 2 4478 65 1 22050 0 49 7 Second Normal Form Example 2 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week3\Chap08cSummary\Chap08cSummary.avi 0 8 5966000000 6400000000 1 32 1024 768 6401000000 5966000000 1000000 5966000000 6400000000 10.000000 1.000000 2 4478 65 1 22050 0 49 8 Third Normal Form Example 1 1 0 Generalization Hierarchy 1 0 1091000000 Process of Logical Data Modeling 1 1 1835000000 Logical Model Development Stages 1 2 4443000000 Entity Discovery 1 3 4790000000 Data Analysis & Normalization 1 4 4990000000 Normalization: 1NF, 2NF, 3NF 1 5 5400000000 First Normal Form Example 1 1 6 5543000000 Second Normal Form Example 2 1 7 5966000000 Third Normal Form Example 1 1 8 32 0000 Teaching Notes Generalization can be multiple levels deep. 1091000000 Teaching Notes Data modeling may be performed during various types of 1277000000 projects and in multiple phases of projects. Data models are progressive and 1463000000 should be considered a living document that will change in response to changing business 1649000000 needs. 1835000000 Teaching Notes These are the steps that are followed in the case studies 3139000000 that accompany the text 4443000000 4790000000 No additional notes 4990000000 No additional notes 5400000000 Teaching Notes The repeating attributes are moved to a separate entity that 5471500000 has a one-to-many relationship to the original entity. 5543000000 Teaching Notes This could be a good time to bring out the old saw, “The 5754500000 key, the whole key, and nothing but the key.” 5966000000 Teaching Notes Some students also might see Purchased-Unit-Price as a 6020250000 derived attribute since it can be derived from Suggested-Retail-Price of the 6074500000 PRODUCT entity. This is a useful concept to discuss in class. 6128750000 The reason why Purchased-Unit-Price must exist in MEMBER ORDERED PRODUCT is 6183000000 that while it can initially be derived from the PRODUCT entity, one would not be able to derive 6237250000 it at a later time if there were a price change. So these two attributes have subtly 6291500000 different definitions. One is the current price, which may change. The other is the price 6345750000 use for that particular order, which should not change.