Database Reference
In-Depth Information
CUSTOMER
ORDER
.
.
.
.
PAYMENT
CHANNEL
.
.
.
.
GROWER
SHIPMENT
.
.
.
.
PRODUCT
FLOWER
.
.
.
.
ARRANGEMENT
.
.
Figure 11-6
Representing entities for florist business.
CUSTOMER
ORDER
CustNo
CustAddr CustName
OrdrNo
OrdrDate
OrdrAmt
.
.
.
.
PAYMENT
CHANNEL
OrdrNo
PmntNo
PmntDate
PmntAmt
ChnlID
ChnlName
.
.
.
GROWER
SHIPMENT
GrwrID
GrwrName
OrdrNo
ChnlID
GrwrID ShipDate ShipQty
.
.
.
PRODUCT
FLOWER
ProdID
ProdCost
ProdID
ProdCost FlwrName FlwrSize
.
.
.
ARRANGEMENT
ProdID
ArngeType
ProdCost
.
.
Figure 11-7
Representing attributes for florist business.
Previous Page
Next Page
Database Design and Development: An Essential Guide for IT Professionals
Search WWH ::




Custom Search
Home