insert into Vehicle values ('11122658483411431', insert into Vehicle values ('11122658483411432', insert into Vehicle values ('11122658483411433', insert into Vehicle values ('11122658483411434', insert into Vehicle values ('11122658483411435', insert into Vehicle values ('11122658483411436', insert into Vehicle values ('11122658483411437', insert into Vehicle values ('11122658483411438', insert into Vehicle values ('11122658483411439', insert into Vehicle values ('11122658483411411', S '001','111','1134' ); '002', '162', '1234' ); '003', '163', '1334' ); '004','164','1434' ); '005', '165', '1534' ); '006', '166', '1634' ); '007', '167', '1734' ); '008', '168', '1834' ); '009', '169', '1934' ); '011','122', '1114' );

Database System Concepts
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
icon
Related questions
icon
Concept explainers
Question

This code got error when i m trying to execute it.

 

67 --insert data to Vehicle table
'001', '111','1134' );
'002', '162', '1234' );
'003', '163', '1334' );
'004','164', '1434' );
'005', '165', '1534' );
68 insert into Vehicle values ('11122658483411431',
69 insert into Vehicle values ('11122658483411432',
70 insert into Vehicle values ('11122658483411433',
71 insert into Vehicle values ('11122658483411434',
72 insert into Vehicle values ('11122658483411435',
73 insert into Vehicle values ('11122658483411436',
74 insert into Vehicle values ('11122658483411437', '007', '167', '1734' );
75 insert into Vehicle values ('11122658483411438', '008'
'008', '168', '1834' );
insert into Vehicle values ('11122658483411439', '009', '169', '1934' );
insert into Vehicle values ('11122658483411411', '011','122', '1114' );
'006', '166', '1634' );
76
77
% ▾
Messages
Msg 547, Level 16, State 0, Line 68
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle_modelid_412EBOB6". The conflict occurred in database "final", table "dbo.Model", column 'id'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 69
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle_modelid_412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 70
The INSERT statement conflicted with the FOREIGN KEY constraint "FK Vehicle modelid _412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 71
The INSERT statement conflicted with the FOREIGN KEY constraint
FOREIGN KEY constraint "FK__Vehicle__modelid 412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'.
"FK
The statement has been terminated.
Msg 547, Level 16, State 0, Line 72
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle__modelid__412EBOB6". The conflict occurred in database "final", table "dbo.Model", column 'id'.
The statement has been terminated.
Transcribed Image Text:67 --insert data to Vehicle table '001', '111','1134' ); '002', '162', '1234' ); '003', '163', '1334' ); '004','164', '1434' ); '005', '165', '1534' ); 68 insert into Vehicle values ('11122658483411431', 69 insert into Vehicle values ('11122658483411432', 70 insert into Vehicle values ('11122658483411433', 71 insert into Vehicle values ('11122658483411434', 72 insert into Vehicle values ('11122658483411435', 73 insert into Vehicle values ('11122658483411436', 74 insert into Vehicle values ('11122658483411437', '007', '167', '1734' ); 75 insert into Vehicle values ('11122658483411438', '008' '008', '168', '1834' ); insert into Vehicle values ('11122658483411439', '009', '169', '1934' ); insert into Vehicle values ('11122658483411411', '011','122', '1114' ); '006', '166', '1634' ); 76 77 % ▾ Messages Msg 547, Level 16, State 0, Line 68 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle_modelid_412EBOB6". The conflict occurred in database "final", table "dbo.Model", column 'id'. The statement has been terminated. Msg 547, Level 16, State 0, Line 69 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle_modelid_412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'. The statement has been terminated. Msg 547, Level 16, State 0, Line 70 The INSERT statement conflicted with the FOREIGN KEY constraint "FK Vehicle modelid _412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'. The statement has been terminated. Msg 547, Level 16, State 0, Line 71 The INSERT statement conflicted with the FOREIGN KEY constraint FOREIGN KEY constraint "FK__Vehicle__modelid 412EB0B6". The conflict occurred in database "final", table "dbo.Model", column 'id'. "FK The statement has been terminated. Msg 547, Level 16, State 0, Line 72 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Vehicle__modelid__412EBOB6". The conflict occurred in database "final", table "dbo.Model", column 'id'. The statement has been terminated.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Query Syntax
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education