I need new and unique answers, please. (Use your own words, don't copy and paste), Please Use your keyboard (Don't use handwriting) Thank you..

Q1. Suppose that a data warehouse for Cancer hospital consists of the four dimensions patient, cancer, habits, and risk_factors, and two measures Disease diagnostic status and District of the patient. Draw a star schema diagram for the above data warehouse. Create the appropriate dimension table(s) and fact table(s) for the data warehouse. Consider primary key and foreign key along with important attributes. Underline the primary key column(s) in each table and italicize the foreign key column(s) in each table. Note: Use Microsoft Access/Word / neatly drawing with hands.

Q2. In data warehouse technology, a multiple dimensional view can be implemented by a relational database technique (ROLAP), by a multidimensional database technique (MOLAP), or by a hybrid database technique (HOLAP). Briefly describe each implementation technique. Which implementation techniques do you prefer, and why?

Q3. Construct a data cube from the given below Fact Table.

Location ID Number Sold Product ID PI Time ID Q2 10 04 25 100 2 03