Design a dimensional model and develop the ETL code to populate the dimensional model.

The objective of this assignment is to design
a dimensional model and develop the ETL code to populate the dimensional model.

part 1 need to download some files from my teacher website

https://www.comp.dit.ie/btierney/DataDM/

i want you describe each part before writing the script

you should make the date dimensional first

you should make diagram and write some lines about it