$4\mathrm{.}6$ Given an e$-$commerce source database schema with an underlined primary key attribute and foreign

key constraints as follows:

CustomerCode. FullName Email.Address.RegistrationTime$)$

Product$($ProductCode$,$Name,type,Origin,SellingPrice,ActualPrice,Quantity$)$

Order$($OrderCode$.$CustomerCode.QuantityValue$)$

transationItem$($ProductCode$,$OrderCode,QuantityValue$)$

Discount$($DiscountCode$,$ Value, ReleaseDate, ExpirationDate, OrderCode$)$

Foreign key constraints:

Order CustomerCode references to Customer CustomerCode

TransactionItem.ProductCode references to Product Product Code

transactionItem OrderCode references to Order OrderCode

DiscountorderCode references to Order$\_$orderCode

Let's design a star schema to support analysis of the time frame of the day$/$week$/$month$/$quarter$/$year in

which each product of each product type is most traded by the customer different geographical regions. In

which, the time dimension has a hierarchy of: TransactionTime $$ Hour $$ Day $$ Week $$ Month $$ Quarter $$

Year, the Product dimension has a hierarchy of ProductCode $$ Type, and the Customer dimension has a

geographic hierarchy created from the Customer Address: CustomerCode $$ Address $$ Geographical Area