Using MySQL
TOURNAMENTS TourneylD P K Tourney Date Tourney Location MATCH_GAMES TOURNEY_MATCHES MatchID TourneylD Lanes Odd Lane TeamlD FK EvenLane TeamID FK MatchID CPK GameNumber CPK WinningTeamID FK TEAMS PK TeamlD TeamName Captain D FK РК на BOWLERS Bowlerid BowlerLastName BowlerFirstName BowlerMiddlelnit Bowler StreetAddress Bowler City Bowler State Bowler ZipCode Bowler Phone Number TeamlD BOWLER SCORES MatchID GameNumber CPK BowlerID CPK Raw Score Handicap Score WonGame Questions: 1. Create a function that can calculate maximum handicap score for a specific input bowler’s first name, and last name (2 points) 2. Create a function that can find a team name for a specific input capture’s first name, and last name (2 points). 3. Create a stored procedure to return name and address of bowler players for a specific input team name (2 output variables). 4. Create a stored procedure to return the bowlers who have a raw score greater than a specific number (input variable) (2 points). 5. Create a stored procedure to return the all the lowest raw score of bowlers for a specific input team name (2 points) Show transcribed image text TOURNAMENTS TourneylD P K Tourney Date Tourney Location MATCH_GAMES TOURNEY_MATCHES MatchID TourneylD Lanes Odd Lane TeamlD FK EvenLane TeamID FK MatchID CPK GameNumber CPK WinningTeamID FK TEAMS PK TeamlD TeamName Captain D FK РК на BOWLERS Bowlerid BowlerLastName BowlerFirstName BowlerMiddlelnit Bowler StreetAddress Bowler City Bowler State Bowler ZipCode Bowler Phone Number TeamlD BOWLER SCORES MatchID GameNumber CPK BowlerID CPK Raw Score Handicap Score WonGame Questions: 1. Create a function that can calculate maximum handicap score for a specific input bowler’s first name, and last name (2 points) 2. Create a function that can find a team name for a specific input capture’s first name, and last name (2 points). 3. Create a stored procedure to return name and address of bowler players for a specific input team name (2 output variables). 4. Create a stored procedure to return the bowlers who have a raw score greater than a specific number (input variable) (2 points). 5. Create a stored procedure to return the all the lowest raw score of bowlers for a specific input team name (2 points)
Expert Answer
Answer to TOURNAMENTS TourneylD P K Tourney Date Tourney Location MATCH_GAMES TOURNEY_MATCHES MatchID TourneylD Lanes Odd Lane Tea…