Question 1: Write single, syntactically correct, T-SQL statements for each of the following:
a. Delete a database named "SportingFC"
b. Create a database named "SportingFC"
c. Make a database named "SportingFC" the currently active database
Question 2: Write the T-SQL statement that would create a table named "Team". The table should contain 3 attributes -TeamID, TeamName and Established. Give these attributes appropriate data types and assign a Primary Key.
Established refers to the date that the team was established.
Question 3: Write the T-SQL statement that would display all records and all fields from a table named "Team". The data should be presented such that teams are grouped based on the Established year and within each group, the data should be presented in ascending order of the Team Name.
Questions 4 to 6 are based on the following table:
A table named "Player" contains details about every player belonging to a sporting club. It contains 4 fields - PlayerID, GivenName, FamilyName and Phone. PlayerID is a number that is auto-generated by the DBMS.
Question 4: Write the T-SQL statement that would insert 2 records into the table Player,assuming that none of the fields can be left "NULL".
Question 5: Write the T-SQL statement that would display all players that have a PlayerID greater than or equal to 1000
Question 6: Write the T-SQL statement that would delete all players named "Smith" from the Player table.