ERD Solution - Premier Database

Download Report

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