Question: I want the solution because I have a test please I want help. The solution is in simple sql language . Only I have an

I want the solution because I have a test please I want help. The solution is in simple sql language. Only I have an hour

Given the following relational schema where primary keys are underlined and foreign keys are marked with #: COUNTRY(countryID, countryName, countryDialingCode) TEAM(teamID, teamName, countryId) PLAYER(playerID, playerFname, playerLname, playerDoB, #teamID) Game(gameID, gameName, gameLevel, year) a) Express the following queries in SQL: i. Add the column gameID of type Integer as a foreign key in table TEAM.[1.5] ii. Find the details of players whose first names start with S. [1] iii. Find the number of players in each team. [1] iv. Change the gameName of the game with id = 5 to Ping Pong. [1] v. Display the name of the country having the highest number of teams.[1.5] vi. List the details of games played by teams from Oman. [1.5] b) Create view lessThan20 that contains player last name, player ID, player country ID, game name of players who are less than 20 years old. [2.5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!