Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The CEO of Dallas Bowling Inc. wants to build a data mart to keep track with bowlers performance. Specifically, he wants to know each bowlers
The CEO of Dallas Bowling Inc. wants to build a data mart to keep track with bowlers performance. Specifically, he wants to know each bowlers number of won games and average handicap score by each tournament and by each week. Provide 4-step dimensional model in the SQL comment section and create data mart solution in SQL for the dimension model that you propose.
TOURNAMENTS TourneylD ToumeyDate TourneyLocation PK TOURNEY MATCHES MatchID TourneylD FK MATCH GAMES OddLane TeamiD FK EvenLane TeamID FK MatchlD GameNumber CPK WinningTeamD FHK TEAMS TeamiD TeamName CaptainID PK FK BOWLERS BoWLER SCORES Matchl D GameNumber CPK BowlerID RawScore HandicapScore CPK BowlerlD BowlerLastName BowlerFirstName BowlerMiddlelnit BowlerStreetAddress BowlerCity BowlerState BowlerZipCode BowlerPhone Number TeamID CPK Business scenario: Dallas Bowling Inc. has an OLTP database to record its tournament data. There are6 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 game 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 for that game. All bowlers' and TOURNAMENTS TourneylD ToumeyDate TourneyLocation PK TOURNEY MATCHES MatchID TourneylD FK MATCH GAMES OddLane TeamiD FK EvenLane TeamID FK MatchlD GameNumber CPK WinningTeamD FHK TEAMS TeamiD TeamName CaptainID PK FK BOWLERS BoWLER SCORES Matchl D GameNumber CPK BowlerID RawScore HandicapScore CPK BowlerlD BowlerLastName BowlerFirstName BowlerMiddlelnit BowlerStreetAddress BowlerCity BowlerState BowlerZipCode BowlerPhone Number TeamID CPK Business scenario: Dallas Bowling Inc. has an OLTP database to record its tournament data. There are6 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 game 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 for that game. All bowlers' andStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started