Given the OLTP Data Model on the next page, design a data mart to support the following analytical requirements:

Facts $($you will need more than one fact table because the facts listed have different grains$)$:

Tax Amount by any combination of Sales Tax Type, Jurisdiction, Product, Transaction, and Transaction Date

Sale Quantity, Amount Paid, and Discount Amount by any combination of Employee, Customer, Cash Register, Department, Store, Product, Supplier, Time of Day, Day of Week, and Transaction Date

Transaction Duration $($calculated from Transaction Start Timestamp and Transaction End Timestamp$)$ by any combination of Employee, Cash Register, Day of Week

Schema must be a strict star schema. Dimension tables cannot have relationships with other dimensions $$ such hierarchies must be either split or collapsed as shown in the Topic $8\mathrm{.}1$ commentary $$Star Schema Design$.$

Similarly, fact tables cannot have relationships with other fact tables.

Dimensions must be conformed as defined by Kimball.

I encourage one ERD with all the fact tables included because this fits current practice and is less work.

If you insist on a separate star schema for each fact table, any dimensions duplicated between the schemas must be identical $($otherwise$,$ they are not conformed$).$