1.Write the SQL command to change the season year for season number 3 to 2017.

2.Write SQL command(s) to create a derived attribute that represents a new surrogate primary key for the Game table. It should be comprised of character data, created from the location and date attributes.

3.Write SQL command(s) to create a new table called EventTypes that contains a single listing of all Event types from EventsDataView.

4.Write SQL command(s) to create a new table for player statistics. The table will contain the Players name or ID, and include a derived attribute which represents the average position played on the pitch. The attribute should accept null values.

5.Write SQL command(s) alter the TracksDataView table to include a derived attribute named DistanceFromBall which represents the Euclidean distance between each player and the ball.. The attribute should accept null values.

6.Alter the Game table to include attributes that represent the final score of the game, and update with some simulated values. 

7.Alter the EventsDataView  and TracksDataView tables to include an attribute named PitchArea to store character data up to ten characters long. The attribute should have a constraint to enforce the domain (“Area1,” “Area2,”, “Area3” and “Area4”) and have a default value of “Unknown.”

8.Write SQL command(s) to cerate a new table called TrackLogs and extract all tracklog data into this. The attributes will be the new primary key from Q2, and also Date, PlayerID, Xposition, Yposition, Time.

9.Write SQL command(s) to see if any particular players have been sent off (Type=”CARD”, Subtype=”RED”) more than once by a particular referee.

10.Alter the player statistics table to include attributes named “YellowCards” and “RedCards” which represent the count of these cards issued to a player. The attribute should not accept null values, and it should have a default value of 0.

Read less