Need to design Erwin and one one excel, data models.  1. star schema 2. Normali

Need to design Erwin and one one excel, data models. 
1. star schema
2. Normalised
3. denotmalised
i have attached two reports and I will need you to design the data models for  report A and report B.
the attachments talk about the file layout for report a and report b. So we will need to design a data models.