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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!