Data models

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.