Table Relationships

	Avoiding data reduncancy and Saving Time, Reducing Errors

Types of Relationships

	One to One
	One to Many
	Many to One
	Many to Many

Relationships: One to One

	One to One
	One customer to One shipping Address
	One Employee to Spouse Address
	One Vendor to Payment Method

One to Many

	One vendor to Many Products
	One Customer to Many Invoices

Many to One

	Many customers are from the same state, which has a state code and Tax Amount

Many to Many

	Pets versus Visits… One Pet ID per Pet ID Visit, but many pets on any day, and one pet may make many visits

Return to Home

Return to Classes

Return to Access Classes