Database diagrams 4

Copyright © 2017 by University of Phoenix. All rights reserved.

CustomersInventory Order GDiamond Color CaratDiamond ClarityDiamond CutRetail StoreCustomerIDPKCustomerNameAddressInventoryIDPKCostCityStatePhone#PriceCaratClarityCutColorInventoryIDFKPKQuantityCutomerIDFKPKOrderIDPKOrderDateShippedDateColorIDPKColorless D,E,FNear Colorless G,H,I,J,KInventoryIDFKFaint Yellow K,L, and MCaratIDPKWeightInventoryIDFKClarityIDPKIFVVS1InventoryIDFKVVS2CutIDPKExcellentVery GoodVS1VS2InventoryIDFKStoreIDPKAddressStateCityZIPCustomerIDFKI1SI1SI2I3I2Good

Customers Inventory Order G Diamond Color Carat Diamond Clarity Diamond Cut Retail Store CustomerID int FK PK CustomerName int FK PK Address int FK PK InventoryID int FK PK Cost int FK PK City int FK PK State int FK PK Phone# int FK PK Price int FK PK Carat int FK PK Clarity int FK PK Cut int FK PK Color int FK PK InventoryID int FK PK Quantity int FK PK CutomerID int FK PK OrderID int FK PK OrderDate int FK PK ShippedDate int FK PK ColorID int FK PK Colorless D,E,F int FK PK Near Colorless G,H,I,J,K int FK PK InventoryID int FK PK Faint Yellow K,L, and M int FK PK CaratID int FK PK Weight int FK PK InventoryID int FK PK ClarityID int FK PK IF int FK PK VVS1 int FK PK InventoryID int FK PK VVS2 int FK PK CutID int FK PK Excellent int FK PK Very Good int FK PK VS1 int FK PK VS2 int FK PK InventoryID int FK PK M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 StoreID int FK PK Address int FK PK State int FK PK City int FK PK ZIP int FK PK int FK PK CustomerID int FK PK M1 M2 M3 M4 I1 int FK PK SI1 int FK PK SI2 int FK PK I3 int FK PK I2 int FK PK Good int FK PK M1 M2 M3 M4