Texas Tire & Battery Inc. is a wholesaler of automotive products. Company executives have recruited your team as a consultant to design and document a data warehouse to support decision making. Company has a chain of depots from which it fulfills customers orders. The data warehouse design should enable order level and detailed analysis of product sales in terms of dollar amounts and order quantities by: a) Date, including: full date, day of week, month, quarter, and year. b) Product, including: product ID, product name, product type, and product supplier name. c) Customer, including: customer ID, customer name, customer type, and customer zip code. d) Depot, including: depot ID, depot size, and depot zip code. e) Order Clerk, including: order clerk employee ID, order clerk name, order clerk title, order clerk education level, and order clerk year of hire. The two available data sources are: Data Source 1: Texas Tire & Battery Inc. Human Resources Department table shown with sample data. Data Source 2: Texas Tire & Battery Inc. Orders Database shown with sample data.

Create a Dimensional model (Star Schema) for this business scenario to design data warehouse for Texas Tire & Battery Inc. Use the Crows Foot notation for the dimensional model. Clearly show all attributes, 3 relationships, primary keys, and foreign keys. You can define surrogate keys. Assign meaningful names to dimensions and facts.

Texas Tire \& Battery Inc. Human Resources Department Employee table: Tables in Texas Tire \& Battery Inc.'s Orders database: DEPOT table: PRODICT table: SUPPLIER table: ORDERCLERK table: ORDERLINE table: CTTTOMFR tahle