My Professor created the needed tables and my job is to add the information to the tables. But i do not understand what is going wrong that my insert statement isnt working with the provided table information.. A SQLQuery14.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (63))* - Microsoft SQL Server Management StudioFileEditView Query Project Debug ToolsWindow HelpNew QueryDMhourglass! ExecuteDebugObject Explo..4 X SQLQuery27.sql - D..VJKRDG\Julie (76))*SQLQuery 13.sql - D...VJKRDG\Julie (62))*SQLQuery14.sql - D...VJKRDG\Julie (63))* X SQLQuery17.sql - D..VJKRDG\Julie (66))*SQLQuery26.sql - D...VJKRDG\Julie (75))*Solution ExplorerConnectEInsert into dbo. Employees (EmpID, FirstName, LastName, Email, Salary, OfficeID, SupervisorID) values('1','Matthew', 'Smith','msmith@cms.com','45000','1',''),('2', 'Mark','Jones', 'mjones@cms.com ','94000','1','1'),('3','Luke','Rice','lrice@cms.com','65000','4','1'),('4','John', 'Rich','jrich@cms.com','74000', '5','1'),('5','James', 'Bolt','jbolt@cms.com','40000','6','2'),('6','Peter', 'Pride','ppride@cms.com','60000','3','3'),('7','Eric', 'Potter','epotter@cms.com','81000',('8','Paul', 'Davis','pdavis@cms.com','103000', '1','7'),('9','David', 'Baxter','dbaxter@cms.com','75000', '7','4'),('10','Andrew', 'Lemmons','alemmons@cms.com','53000','3','4')B SQLQuery10.sqlE. SQLQuery11.sqlB SQLQuery12.sqlE SQLQuery13.sqlOO DESKTOP-AVJKRDG\SDO DatabasesE- System DatabasesB0 hourglassO Database DiagraE SQLQuery14.sqlB SQLQuery15.sqlD Tables'2','3'),B. SQLQuery16.sqlE SQLQuery17.sqlB. SQLQuery18.sqlB SQLQuery19.sqlB SQLQuery2.sqlB SQLQuery20.sqlB SQLQuery21.sqlE. SQLQuery22.sqlE SQLQuery23.sql-System TablesO FileTables+ ViewsSynonymsE- Programmability+- Service BrokerStorageSecurityB- SecurityE SQLQuery24.sqlE SQLQuery25.sqlE SQLQuery26.sqlE SQLQuery27.sqlE- Server Objects100 %ReplicationB MessagesE- ManagementMsg 547, Level 16, State e, Line 1The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "fk_Employees_Employees". The conflict occurred in database "hourglass", table "dbo. Employees", column 'EmpID'.The statement has been terminated.PropertiesCurrent connection parametersAggregate StatusConnection failuresElapsed time00:00:00.026Finish time3/13/2022 5:28:40 PMNameDESKTOP-AVJKRDG\SRows returnedStart time3/13/2022 5:28:40 PMStateОpenConnection70 %Connection name DESKTOP-AVJKRDG\SConnection DetailsA Query completed with errors.DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rowsConnection elapsec 00:00:00.026Connection finish ti 3/13/2022 5:28:40 PMOutputConnection rows re 0Show output from:Connection start tir 3/13/2022 5:28:40 PMConnection stateОpenNameThe name of the connection.OutputFind Results 1Find Results 2ReadyLn 12Col 1Ch 1OVRI HE A SQLQuery13.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (62))* - Microsoft SQL Server Management StudioFileEditView Query Project Debug ToolsWindow HelpNew QueryDMhourglass! ExecuteDebug%3DSolution Explorer+ X SQLQuery27.sql - D...VJKRDG\Julie (76))*ECREATE TABLE Employees(EmpID int,FirstName varchar(30),LastName varchar(50),Email varchar(50),Object Explo..SQLQuery13.sql - D...VJKRDG\Julie (62))* X SQLQuery14.sql - D..VJKRDG\Julie (63))*SQLQuery17.sql - D...VJKRDG\Julie (66))*SQLQuery26.sql - D...VJKRDG\Julie (75))*ConnectE SQLQuery10.sqlE SQLQuery11.sqlB SQLQuery12.sqlB. SQLQuery13.sqlB SQLQuery14.sqlB. SQLQuery15.sqlB. SQLQuery16.sqlE SQLQuery17.sqlB SQLQuery18.sqlB SQLQuery19.sqlB SQLQuery2.sqlB SQLQuery20.sqlB SQLQuery21.sqlE. SQLQuery22.sqlE SQLQuery23.sqlOO DESKTOP-AVJKRDG\SDO DatabasesE- System DatabasesB0 hourglassO Database DiagraSalary decimal(10, 2),OfficeID int not null,D TablesSupervisorID int,CONSTRAINT pk_Employees PRIMARY KEY (EmpID),CONSTRAINT fk_Employees_Offices FOREIGN KEY (OfficeID) REFERENCES Offices,CONSTRAINT fk_Employees_Employees FOREIGN KEY (SupervisorID) REFERENCES Employees)System TablesO FileTables+ ViewsSynonymswwE- ProgrammabilitySELECT*FROM Employees|exec sp_help Employees+- Service BrokerStorageSecurityB- SecurityE SQLQuery24.sqlE SQLQuery25.sqlE SQLQuery26.sqlE SQLQuery27.sql- Server Objects100 %ReplicationB MessagesE- ManagementMsg 2714, Level 16, State 6, Line 1There is already an object named 'Employees' in the database.PropertiesCurrent connection parametersAggregate StatusConnection failuresElapsed time00:00:00.015Finish time3/12/2022 10:23:20 PNameDESKTOP-AVJKRDG\SRows returnedStart time3/12/2022 10:23:20 PStateOpenConnection100 %Connection name DESKTOP-AVJKRDG\SConnection DetailsA Query completed with errors.DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rowsConnection elapsec 00:00:00.015Connection finish ti 3/12/2022 10:23:20 POutputConnection rows re 0Show output from:Connection start tir 3/12/2022 10:23:20 PConnection stateОpenNameThe name of the connection.OutputFind Results 1Find Results 2ReadyLn 14Col 1Ch 1OVR

By analysing the above I found out the below solutions: For the first error : The EmpID column is a…

Edit View Query Project Debug Tools Window Help |4x口, .- New Query D & 9 . 3 hourglass ! Execute Debug のニ2课 A bject Explo. x SQLQuery27.sql - D.VIKRDGUulie (76)" SQLQuery13.sgl -D..VIKRDGUulie (62) SQLQuery14.sql - D.VJKRDGUulie (63)) x SQLQuery17.sql - D. VIKRDGVulie (66) SOLQuery26.sql - D.VIKRDGVulie (75)) - Solution Explorer Connect 3 DESKTOP-AVJKRDG Insert into dbo. Employees (EmpID, FirstName, LastName, Email, Salary, OfficeID, SupervisorID) values ('1', 'Matthew', 'Smith', "msmithệcms.com', '4500e','1',"), SQLQuery 10.sgl SQLQuery11.sql SQLQuery12.sql SOLQuery13.sgl SQLQuery14.sql SQLQuery15.sql a SQLQuery16.sql l ','940e0','1','1'), ','4','1'), ('2', 'Mark','Jones', 'mjonescms.com ('3', 'Luke', Rice','lrice@cms.com', '65000 ('4','John', "Rich', 'jrich@cms.com', '74000' ,'s', '1'), ,'James', 'Bolt', jbolt@cms.com', 40000 Databases a System Databases a hourglass Database Diagra ('5' e', '6', '2'), ('6', 'Peter', 'Pride', ppride@cms.com', '60000','3','3'), ('7', 'Eric', 'Potter', 'epotter@cms.com', '81000', 2','3'), ('8', 'Paul', "Davis', 'pdavis@cms.com', '103000','1','7'), ('9', 'David','Baxter', 'dbaxter@cms.com','75000','7','4'), ('10', 'Andrew', 'Lemmons', 'alemmons@cms.com, '53000','3', '4') Tables System Tables FileTables a SQLQuery17.sql aSQLQuery 18.sql Views a Synonyms a Programmability Ra Service Broker Storage Ha Security Security a Server Objects Replication Management a SQLQuery19.sql SQLQuery2.sql SQLQuery20.sql SQLQuery21.sql SQLQuery22.sql SQLQuery23.sql a SQLQuery24.sql SQLQuery25.sql SOLQuery26.sql SOLQuery27.sql 100 % a Messages nag 547, Level as, state e, Line 1 The INSERT statenent confaicted with the FOREION KEY SAME TABLE constraint " fnployees Enployees". The contiiet occurred in database "hourglass", tabe "ebo.Enployees", column EnpID. . The statenent has been terninated. Properties Current connection para Aggregate Status Connection failures

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE