Using the normalized diagram attached, answer the following questions:

1. Create a Dimensional Model (STAR SCHEMA) (7pts)

Include two FACT tables, and necessary DIMENSION tables.

At least one table should be a TIME DIMENSION.

Identify (and draw) PRIMARY and FOREIGN KEYS.

Note: It may not be necessary to represent all data fields in your dimensional model.

2. Do your FACT tables share one or more CONFORMED DIMENSION tables? If so, which ones? (1pts)

3. How and why did you pick your FACT TABLES? (2pts)

order order item order id INT ine no INT product, d INT qty NT sale price FLOAT id INT first name VARCHAR(100 last-name VARCHAR(100) d INT customer_id INT | placed by order-placed DATETIME order shipped DATETIME tracking no VARCHAR(100] Shp-employee_id INT tax rate FLOAT email VARCHAR(200) part of refers to password CHARI32) address-street VARCHARI200) address state VARCHARI5 Oaddress 7p VARCHAR(15) inventory-count d INT uct shipped by i INT name VARCHAR(200 product_id INT verify empkoyee id INT qty-inventory INT qty-counted INT ci lective DATETIME stock-no CHAR(10) refersto1 description VARCHAR( 10001 ORst-price FLOAT stock.ry INT O sku VARCHAR(20 ventied oname last VARCHARI100) name-list VARCHARI 100 vendo reters to employment date DATE title VARCHAR(100) inventory purchase id INT name VARCHARI200) tax-id VARCHAR (45) cotad, name VARCHAR( 100 contact phone VARCHAR(1 5) ocontact email VARCHAR200) address street VARCHAR(200) address state VARCHARI5) address zip VARCHAR(15) bonded ENUMIY, 'N o use-tax ENUM(MM department VARCHARI 100) vendorid INT vendor-Product d VARCHA. order placed DATE TIME o order-received DATETI ME O tax rate FLOAT inventory_ item id INT ? ine no INT - purchased by I is part t l iventory.purchase-id INT supplied by product, d INT gty INT unit pnce FLOAT ist prioe FLOAT rchase, mplyee id INT received employee id INT