First page Back Continue Last page Image

ERD – Entity Relationship Diagram

How Tables are Joined Together

Sales
Key	Field	Type
PK	TID
	TDate
	TAmt
	TClrk
FK	CNumb
FK	PNumb

Product
Key	Field	Type
PK	PNumb
	PName
	PInvt
	PCost

Customer
Key	Field	Type
PK	CNumb
	CName