10 UMLClass 20 40 150 110 Products_Dim -- ProductID (PK) ProductName QuantityPerunit UnitPrice Discontinued UMLClass 20 160 150 220 Suppliers_Dim -- SupplierID (PK) CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax HomePage UMLClass 20 390 150 100 Categories_Dim -- CategoryID (PK) CategoryName Description Picture UMLClass 310 140 160 370 Orders_Fact bg=pink -- OrdersID (PK) ProductID CustomerID SuppierID EmployeeID CategoryID OrderDateID RequiredDateID ShipperID ShippedDateID ShippingAddressID Freight UnitPrice Quantity TotalCost Discount TotalCostDiscount VATID VATRate TotalCostVAT TotalCostVATDiscount UMLClass 610 30 160 210 Customers_Dim -- CustomerID (PK) CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax UMLClass 610 250 160 300 Employees_Dim -- EmployeeID (PK) LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes ReportsTo UMLClass 610 560 160 80 Shippers_Dim -- ShipperID (PK) CompanyName Phone UMLClass 20 500 150 130 Date_Dim -- DateID (PK) Day Week Month Quarter Year Relation 160 70 170 150 lt=- m1=1 m2=n 10.0;10.0;60.0;10.0;60.0;120.0;150.0;120.0 Relation 460 60 170 170 lt=- m1=n m2=1 10.0;140.0;100.0;140.0;100.0;10.0;150.0;10.0 Relation 460 230 170 80 lt=- m1=n m2=1 10.0;10.0;100.0;10.0;100.0;50.0;150.0;50.0 Relation 460 290 170 330 lt=- m1=n m2=1 10.0;10.0;100.0;10.0;100.0;300.0;150.0;300.0 Relation 160 180 170 70 lt=- m1=1 m2=n 10.0;10.0;40.0;10.0;40.0;40.0;150.0;40.0 Relation 160 240 170 210 lt=- m1=1 m2=n 10.0;180.0;60.0;180.0;60.0;10.0;150.0;10.0 UMLClass 610 650 160 140 ShippingAddress_Dim -- ShippingAddressID (PK) ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Relation 460 320 170 390 lt=- m1=n m2=1 10.0;10.0;60.0;10.0;60.0;360.0;150.0;360.0 Relation 160 280 170 290 lt=- m1=1 m2=n 10.0;260.0;90.0;260.0;90.0;10.0;150.0;10.0 Relation 160 310 170 260 lt=- m1=1 m2=n 10.0;230.0;90.0;230.0;90.0;10.0;150.0;10.0 Relation 160 260 170 310 lt=- m1=1 m2=n 10.0;280.0;90.0;280.0;90.0;10.0;150.0;10.0 UMLClass 20 640 150 80 VATRates_Dim -- VATID (PK) VATClassification VATRate Relation 160 430 170 280 lt=- m1=1 m2=n 10.0;250.0;110.0;250.0;110.0;10.0;150.0;10.0