From the relational schema above create a star schema and snowflake based model on the database structure. Create the dimensional models based on the following relational schema and the analytical requirements.

Analytical requirements:

1. The data warehouse needs to support the aggregated-level analysis of revenue and sales performance (ex. The total quantity of products sold), salesperson, product, date, customer, and store.

2. The data warehouse needs to support the line-item analysis of sales performance by the time of the day, day of the week, month, and customer.

3. The data warehouse needs to support the transaction-level analysis of revenue by quarter, year, product, store, and salesperson.

Salesperson TransactionDate Transaction Time CustomerID StorelD (FK) SalespersonID FirstName LastName PhoneNumber SalesOffice Customer CustomerlD FirstName LastName FK) Region Email Address Store egionID RegionName Size Layout Address ZipCode RegionCategory Transactionitem Transaction!0 FK) ? Discount O) ProductType Product ProductTypeCode ProductID ProductName ProductDescription PriceRange FK) SupplieriD FK Supplier SupplierName Address