Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

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

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter3: Table Creation And Management
Section: Chapter Questions
Problem 2MC
See similar textbooks
icon
Related questions
Question

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 Studio File Edit View Query Project Debug Tools Window Help New Query DM hourglass ! Execute Debug Object 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 Explorer Connect EInsert 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.sql E. SQLQuery11.sql B SQLQuery12.sql E SQLQuery13.sql OO DESKTOP-AVJKRDG\S DO Databases E- System Databases B0 hourglass O Database Diagra E SQLQuery14.sql B SQLQuery15.sql D Tables '2','3'), B. SQLQuery16.sql E SQLQuery17.sql B. SQLQuery18.sql B SQLQuery19.sql B SQLQuery2.sql B SQLQuery20.sql B SQLQuery21.sql E. SQLQuery22.sql E SQLQuery23.sql -System Tables O FileTables + Views Synonyms E- Programmability +- Service Broker Storage Security B- Security E SQLQuery24.sql E SQLQuery25.sql E SQLQuery26.sql E SQLQuery27.sql E- Server Objects 100 % Replication B Messages E- Management Msg 547, Level 16, State e, Line 1 The 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. Properties Current connection parameters Aggregate Status Connection failures Elapsed time 00:00:00.026 Finish time 3/13/2022 5:28:40 PM Name DESKTOP-AVJKRDG\S Rows returned Start time 3/13/2022 5:28:40 PM State Оpen Connection 70 % Connection name DESKTOP-AVJKRDG\S Connection Details A Query completed with errors. DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows Connection elapsec 00:00:00.026 Connection finish ti 3/13/2022 5:28:40 PM Output Connection rows re 0 Show output from: Connection start tir 3/13/2022 5:28:40 PM Connection state Оpen Name The name of the connection. Output Find Results 1 Find Results 2 Ready Ln 12 Col 1 Ch 1 OVR I HE
Transcribed Image Text:A SQLQuery14.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (63))* - Microsoft SQL Server Management Studio File Edit View Query Project Debug Tools Window Help New Query DM hourglass ! Execute Debug Object 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 Explorer Connect EInsert 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.sql E. SQLQuery11.sql B SQLQuery12.sql E SQLQuery13.sql OO DESKTOP-AVJKRDG\S DO Databases E- System Databases B0 hourglass O Database Diagra E SQLQuery14.sql B SQLQuery15.sql D Tables '2','3'), B. SQLQuery16.sql E SQLQuery17.sql B. SQLQuery18.sql B SQLQuery19.sql B SQLQuery2.sql B SQLQuery20.sql B SQLQuery21.sql E. SQLQuery22.sql E SQLQuery23.sql -System Tables O FileTables + Views Synonyms E- Programmability +- Service Broker Storage Security B- Security E SQLQuery24.sql E SQLQuery25.sql E SQLQuery26.sql E SQLQuery27.sql E- Server Objects 100 % Replication B Messages E- Management Msg 547, Level 16, State e, Line 1 The 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. Properties Current connection parameters Aggregate Status Connection failures Elapsed time 00:00:00.026 Finish time 3/13/2022 5:28:40 PM Name DESKTOP-AVJKRDG\S Rows returned Start time 3/13/2022 5:28:40 PM State Оpen Connection 70 % Connection name DESKTOP-AVJKRDG\S Connection Details A Query completed with errors. DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows Connection elapsec 00:00:00.026 Connection finish ti 3/13/2022 5:28:40 PM Output Connection rows re 0 Show output from: Connection start tir 3/13/2022 5:28:40 PM Connection state Оpen Name The name of the connection. Output Find Results 1 Find Results 2 Ready Ln 12 Col 1 Ch 1 OVR I HE
A SQLQuery13.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (62))* - Microsoft SQL Server Management Studio File Edit View Query Project Debug Tools Window Help New Query DM hourglass ! Execute Debug %3D Solution 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))* Connect E SQLQuery10.sql E SQLQuery11.sql B SQLQuery12.sql B. SQLQuery13.sql B SQLQuery14.sql B. SQLQuery15.sql B. SQLQuery16.sql E SQLQuery17.sql B SQLQuery18.sql B SQLQuery19.sql B SQLQuery2.sql B SQLQuery20.sql B SQLQuery21.sql E. SQLQuery22.sql E SQLQuery23.sql OO DESKTOP-AVJKRDG\S DO Databases E- System Databases B0 hourglass O Database Diagra Salary decimal(10, 2), OfficeID int not null, D Tables SupervisorID 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 Tables O FileTables + Views Synonyms ww E- Programmability SELECT*FROM Employees | exec sp_help Employees +- Service Broker Storage Security B- Security E SQLQuery24.sql E SQLQuery25.sql E SQLQuery26.sql E SQLQuery27.sql - Server Objects 100 % Replication B Messages E- Management Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Employees' in the database. Properties Current connection parameters Aggregate Status Connection failures Elapsed time 00:00:00.015 Finish time 3/12/2022 10:23:20 P Name DESKTOP-AVJKRDG\S Rows returned Start time 3/12/2022 10:23:20 P State Open Connection 100 % Connection name DESKTOP-AVJKRDG\S Connection Details A Query completed with errors. DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows Connection elapsec 00:00:00.015 Connection finish ti 3/12/2022 10:23:20 P Output Connection rows re 0 Show output from: Connection start tir 3/12/2022 10:23:20 P Connection state Оpen Name The name of the connection. Output Find Results 1 Find Results 2 Ready Ln 14 Col 1 Ch 1 OVR
Transcribed Image Text:A SQLQuery13.sql - DESKTOP-AVJKRDG\SQLEXPRESS.hourglass (DESKTOP-AVJKRDG\Julie (62))* - Microsoft SQL Server Management Studio File Edit View Query Project Debug Tools Window Help New Query DM hourglass ! Execute Debug %3D Solution 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))* Connect E SQLQuery10.sql E SQLQuery11.sql B SQLQuery12.sql B. SQLQuery13.sql B SQLQuery14.sql B. SQLQuery15.sql B. SQLQuery16.sql E SQLQuery17.sql B SQLQuery18.sql B SQLQuery19.sql B SQLQuery2.sql B SQLQuery20.sql B SQLQuery21.sql E. SQLQuery22.sql E SQLQuery23.sql OO DESKTOP-AVJKRDG\S DO Databases E- System Databases B0 hourglass O Database Diagra Salary decimal(10, 2), OfficeID int not null, D Tables SupervisorID 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 Tables O FileTables + Views Synonyms ww E- Programmability SELECT*FROM Employees | exec sp_help Employees +- Service Broker Storage Security B- Security E SQLQuery24.sql E SQLQuery25.sql E SQLQuery26.sql E SQLQuery27.sql - Server Objects 100 % Replication B Messages E- Management Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Employees' in the database. Properties Current connection parameters Aggregate Status Connection failures Elapsed time 00:00:00.015 Finish time 3/12/2022 10:23:20 P Name DESKTOP-AVJKRDG\S Rows returned Start time 3/12/2022 10:23:20 P State Open Connection 100 % Connection name DESKTOP-AVJKRDG\S Connection Details A Query completed with errors. DESKTOP-AVJKRDG\SQLEXPRESS . DESKTOP-AVJKRDG\Julie . hourglass 00:00:00 O rows Connection elapsec 00:00:00.015 Connection finish ti 3/12/2022 10:23:20 P Output Connection rows re 0 Show output from: Connection start tir 3/12/2022 10:23:20 P Connection state Оpen Name The name of the connection. Output Find Results 1 Find Results 2 Ready Ln 14 Col 1 Ch 1 OVR
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS