Question: 3. Factless fact table Design a factless fact table and the associated dimension tables to meet the following requirement: 1) The university annually holds a
3. Factless fact table Design a factless fact table and the associated dimension tables to meet the following requirement: 1) The university annually holds a three-day orientation program for incoming freshmen 2) Seniors are encouraged to participate in the orientation program, along with the university administration personnel 3) Each senior can participate in part or all of the orientation program...e.g., all three days, or just the 1st day, or just the 2nd and 3rd days, etc. 4) To help plan activities, each senior signs up in an online survey system for which day(s) he/she will be participating 5) The online survey system sends this information into the university data warehouse, where it is stored for analysis in a factless fact table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
