Create SQL query records to insert into these tables. Please attach queries to r
ID: 3596744 • Letter: C
Question
Create SQL query records to insert into these tables. Please attach queries to response.
Thanks!
CREATE TABLE team (teamID. int NOT NULL PRIMARY KEY, Team.name varchax(20) NOT NULL, Team shortname varchar(10) UNIQUE NOT NULL Team owaer archar(25) CREATE TABLE positioning ( Position ID int NOT NULL PRIMARY KEY, Eield positionarcha(20) NOT NULL (Ctrl) CREATE TABLE player (player. id int NOT NULL PRIMARY KEY, Plaver name varcha(30) NOT NULL, TeamID int FOREIGN KEY references team (team. Position.it FOREEIGN KEY references positioning (position D) .Select Plaver name Team Name. Field position. Positioning Position ID From Player inner join Team on PlaversTeam ID Team Team ID inner join Positioning on Players.Position ID-PositioningPosition Inner join on 3 tables is required to extract data from the tables based on common fields ·Explanation / Answer
Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_SHORTNAME,TEAM_OWNER) values ('1234','BRAZIL','BRA','Rob');
Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_SHORTNAME,TEAM_OWNER) values ('1235','CHINA','CHN','JACK');
Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_SHORTNAME,TEAM_OWNER) values ('1236','AUSTRALIA','AUS','MICHAEL');
Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_SHORTNAME,TEAM_OWNER) values ('1237','GERMANY','GER','KENT');
Insert into POSITIONING (POSITION_ID,FIELD_POSITION) values ('9999','MIDDLE');
Insert into POSITIONING (POSITION_ID,FIELD_POSITION) values ('8888','LEFT');
Insert into POSITIONING (POSITION_ID,FIELD_POSITION) values ('7777','RIGHT');
Insert into POSITIONING (POSITION_ID,FIELD_POSITION) values ('5555','CORNER');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('99','Peter Shilton','1234','8888');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('77','David Beckham','1234','7777');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('44','Billy Wright','1235','5555');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('22','Bryan Robson','1234','5555');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('12','Michael Owen','1237','8888');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('90','Gary Neville','1234','8888');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('55','Ray Wilkins','1236','5555');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('67','Rio Ferdinand','1234','7777');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('43','Terry Butcher','1235','5555');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('23','David Seaman','1236','5555');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('87','Gordon Banks','1236','7777');
Insert into PLAYER (PLAYER_ID,PLAYER_NAME,TEAM_ID,POSITION_ID) values ('52','Gary Neville','1236','8888');
commit;
Please run commit after inserting each insert script.