For the following data model and sample data, create a star schema diagram that will enable FIT-WORLD GYM INC. to analyze their revenue.

Also, explain the process to go from an ER diagram to a star schema (relational).

MembName Membld MshpPrice Date MshpName MembZip MEMBER Pays OH MEMBERSHIP Mship D Buys Passld Buy Via Date O4 SALETRANSACT PassDate STrid ONEDAYPASS SoldVia Quantity Is Of PASSCATEGORY MERCHANDISE Mrchld MrchPrice PassCatld Price CatName MrchName MEMBER Membld 111 222 333 MembName Joe Mary Sue MembZip 60611 60640 60611 MshpID M1 M3 M3 MsDate Payed 1-Jan-04 1-Jan-04 1-Jan-04 MEMBERSHIP MshpID M1 M2 M3 MshpName MshpPrice Platinum $1,000 Gold $800 Value $300 ** ONE DAY PASS CATEGORY Pass Catld CatName PSA Adult PSS Senior PSK Kid Price $20 $10 $3 MERCHANDISE MrchID AP1 AP2 EQ1 Mrch Name Mrch Price T-shirt $11 Hat $9 Jump Rope $12 * ONE DAY GUEST PASS Passld PassDate 1-001 1-Jan-04 1-002 1-Jan-04 1-003 2-Jan-04 PassCatid PSA PSA PSK Membld 111 333 333 SALE TRANSACTION STrid Date 11111 1-Jan-04 11112 2-Jan-04 11113 3-Jan-04 Membid 333 222 111 * Quantity SOLD VIA STrid 11111 11111 11112 11113 Mrchid AP1 AP2 AP2 EQ1 Members can bring in non-member guests. For each non-member guest, a member buys a one-day-guest-pass of a certain pass category. 1 1 3 Event Type Event Date FIT-WORLD GYM Special Events Table Corporate Corporate Customer Customer ID Name and Location cc1 Sears, Chicago 60640 CC2 Boeing, Chicago 60611 Event Type Code L-A L-H Amount Charged $3500 $2200 All Day Rental, Half Day Rental, January 4, 2004 January 5, 2004