|
|
|
Avoiding data reduncancy and Saving Time,
Reducing Errors |
|
|
|
|
One to One |
|
One to Many |
|
Many to One |
|
Many to Many |
|
|
|
|
One to One |
|
One customer to One shipping Address |
|
One Employee to Spouse Address |
|
One Vendor to Payment Method |
|
|
|
|
One vendor to Many Products |
|
One Customer to Many Invoices |
|
|
|
|
|
|
Many customers are from the same state, which
has a state code and Tax Amount |
|
|
|
|
|
|
Pets versus Visits…
One Pet ID per Pet ID Visit, but many pets on any day, and one pet may
make many visits |
|
|
|
|
|
|
|
Notes
