Transcript ERD Solution - Premier Database
ERD Solution - Premier Products Crow’s Foot notation Customer Rep Customernum(PK) Customername Street City State Zip Balance CreditLimit Repnum (FK) Repnum (PK) Firstname Lastname Commission Rate Orders Ordernum (PK) Orderdate Customernum (FK) Orderline Ordernum (PK) (FK) Partnum (PK) (FK) NumOrdered QuotedPrice 2 Part Partnum (PK) Description OnHand Class Warehouse Price