(Answered): Please use the sql_practice ER model shown below to develop alogical star- or snowflake-schema dimen ...

Figure 1. SQL Practice Database ER Model orderdetails PK/EK Orderin PK/FK ProductID UnitPrice Quantity Discount orders PK OrderID FK Customer FK Employeeld Order Date Required Date ShippedDate FK ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode Ship Country customers PK Customerid CompanyName ContactName Contact Title Address City Region PostalCode Country Phone Fax AN shipppers PK Shipperi CompanyName Phone + products PK ProductID ProductName FK Supplier D FK CategoryID Quantity PerUnit UnitPrice UnitsInStock Units OnOrder Reorderlevel Discontinued suppliers PK Supplier Company Name ContactName Contact Title Address City Region PostalCode Country Phone Fax HomePage employees PK Employeeld LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region Postal Code Country Home Phone Extension Photo Notes FK Reports To PhotoPath categories PK CategoryID CategoryName Description Picture