Need some help designing the data dimension tables for this question, Please assist!

Dallas Bowling Inc. has an OLTP database to record its tournament data. There are 6 tables stored inside the database. When a tournament is announced, its date and location are stored in tournaments table. The information of tournament match is kept in tourney_matches table. When a match is played, the home team ID is classified as odd lane team ID, and the visiting team ID is classified as even lane team ID. For each bowling match, two teams will play 3 games to decide the winner of the match and the first team get two wins will win the match. The match_games table shows the winner of each game, and bowler_scores table shows the score of each bowler who played that game. All bowlers and teams information such as team captain, and bowlers name, are recorded in bowlers and teams tables. The figure above shows the logical schema of Dallas Bowling Inc.s OLTP database. The CEO of Dallas Bowling Inc. wants to build a data warehouse that consists of a data mart:

The data mart will keep track of bowlers performance. Specifically, he wants to know the total numbers of teams each bowler has been played until now. He also wants to know the average lifetime handicap score, average handicap score for each team the bowler played, highest lifetime handicap score, and handicap percentage for each team the bowler played (calculated by dividing team total handicap score to team total raw score).

TOURNAMENTS TourneylD TourneyDate TourneyLocation PK TOURNEY MATCHES MatchlD TourneylD Lanes OddLaneTeamID FK EvenLaneTeamlID FK PK Fk MATCH GAMES MatchID GameNumber CPK WinningTeamID FK CPK TEAMS PK TeamID TeamName CaptainlD FK BOWLERS BOWLER SCORES CPK MatchlD GameNumber CPK BowlerlD RawScore HandicapScore WonGame PK BowlerID BowlerLastName BowlerFirstName BowlerMiddlelnit BowlerStreetAddress BowlerCity BowlerState BowlerZipCode BowlerPhoneNumber TeamID CPK FK TOURNAMENTS TourneylD TourneyDate TourneyLocation PK TOURNEY MATCHES MatchlD TourneylD Lanes OddLaneTeamID FK EvenLaneTeamlID FK PK Fk MATCH GAMES MatchID GameNumber CPK WinningTeamID FK CPK TEAMS PK TeamID TeamName CaptainlD FK BOWLERS BOWLER SCORES CPK MatchlD GameNumber CPK BowlerlD RawScore HandicapScore WonGame PK BowlerID BowlerLastName BowlerFirstName BowlerMiddlelnit BowlerStreetAddress BowlerCity BowlerState BowlerZipCode BowlerPhoneNumber TeamID CPK FK