Step 1: Identify the dimensions [first three only} from each table: You'll notice in bed_type there are only three variables, bed_id, bed_code, and bed_desc. Naturally just list these three as the dimensions, there are no other variables to select. It's ok to include the primary key (PK) as a dimension. For business, pay attention to the differences between afoct and a dimension variable as we discussed in class. In this table there are only three dimensions to select. See if you can correctly identify which ones they are {again the PK can be counted as one dimension}. Step 2: Identify the Facts [rst three only) from the single fact table. Consider what type of variable would be afact vs. a dimension and select three of those from the bed_fact table. Be aware, it is likely that some variables in a fact table are dimensions, for example a foreign key or anything of that sort is a dimension even if it's listed in the fact table. Step 3: Sketch out a Star Schema Include both the data tables of interest and the appropriate joins between the tables that can be used to answer the questions. Use MySQL to draw the star schema. Be sure to label the fact table and dimension tables accordingly (you can always add a text box above the tables if you need to] Step 4: Implement the schema as a database Name it "Hospital DB\" in MySQL