ERD and Star Schema

Job ID: 35453585

Budget: $2 – $8 AUD

looking for a person who can do
Step 1:
You will use for me the dataset I have provided for you. The dataset is in the ‘Assessment Data.xlsx’ file.
Step 2:
You will submit to me your 3rd order normal form design of your dataset. I am expecting a Crow’s Foot diagram of your design in Visio. Please identify all of the partial and transitive dependencies in your design.
Step 3:
You will submit to me your star-schema design. I am expecting a Crow’s Foot diagram show me your star-schema of Dimension and Fact tables.