Dallas Bowling Inc Case Study - Report Writing - Business Assignment Help

Assignment Task:

Business scenario: 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 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 

teams’ information such as team captain, and bowler name, are recorded in ‘bowlers’ and ‘teams’ tables. The figure above shows the logical schema of Dallas Bowling Inc.’s OLTP database. 

Q1: 

The CEO of Dallas Bowling Inc. wants to build a data mart to keep track with bowler’s 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 (2 points) and create data mart solution in SQL for the dimension model that you propose (2 points). 

Q2: 

The CEO of Dallas Bowling Inc. wants to build two data marts to keep track with team’s performance. He is concerned with how effective each team win a home game and win a visiting game. To measure the effectiveness of each team, he wants to use home win match percentage and visiting win match percentage. In addition, he wants to know the best player(s) of the match who scored the highest handicap score. Provide 4-step dimensional model in the SQL comment section (2 points) and create data mart solution in SQL for the dimension model that you propose (4 points).

This Business Assignment has been solved by our Business Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & the US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.