Question: why do i keep getting thiserror how to solve it ? 2. 3 INSERT INTO TRIPLEG (TNUM, LEGNUM, DEPARTURE, DESTINATION) VALUE (10245, 28, Sydney Newcastle

why do i keep getting thiserror how to solve it ?  why do i keep getting thiserror how to solve it ?
2. 3 INSERT INTO TRIPLEG (TNUM, LEGNUM, DEPARTURE, DESTINATION) VALUE (10245, 28,

2. 3 INSERT INTO TRIPLEG (TNUM, LEGNUM, DEPARTURE, DESTINATION) VALUE (10245, 28, Sydney Newcastle INSERT INTO TRIP (TNUM, LNUM, REGNUM, TDATE) VALUE(10245, 104777, AOPAH 2821-12) 4. ocedures 5 6 7. DELETE FROM TRIP WHERE TNUM=61; DELETE FROM TRIPLEG WHERE TNUM=81; 8. 9 Action Output # Time 17:47:40 1 Action INSERT INTO TRIPLEG Message id Action: INSERT INTO TRIPLEG (TNUM, LEGNUM, DEPARTURE, DESTINATION) VALUE(10245,20, 'Sydney":"Newcastle") Response: Error Code: 1452. Cannot add or update a child row. a foreign key constraint fails (transport'. TRIPLEG, CONSTRAINT TRIPLEGFKEY ate FOREIGN KEY (TNUM) REFERENCES TRIP (TNUM)) Duration: 0.00061 sec Go to Settings apted LISTED BELOW NULL, CREATE TABLE STAFF ENUM DECIMAL (12) NOT NULL / Staft employee number FNAME VARCHAR(50) NOT NULL, 1. First se LNAME VARCHAR(50) NOT NULLA / Last name DOR DATE Date of birth CONSTRAINT STAFF_PKEY PRIMARY KEY (EUR): CREATE TABLE DRIVER ENUM DECIMAL (12) NOT NULL, Statt ployee number LNUM DECIMAL (8) NOT NULL. / Driving license number STATUS VARCHAR(10) NOT NULL Driver status CONSTRAINT DRIVER_PKEY PRIMARY KEY (ENUM). CONSTRAINT DRIVER_UNIQUE UNIQUE (LNUM). CONSTRAINT DRIVER FREY FOREIGN KEY CENTIM) REFERENCES STAFF LEBUH). CONSTRAINT DRIVER STATUS CHECK STATUS IN "AVAILABLE IN SERVICE", "ON LEAVE"> CREATE TABLE TRUCK REGNUM VARCHAR(10) NOT NULL, Registration number CAPACITY DECIMAL (7) NOT NULL Capacity WEIGHT DECIMAL (7) NOT NULL Weight STATUS VARCHAR(10) NOT NULL Present states CONSTRAINT TRUCK PKEY PRIMARY KEY (REGNUM), CONSTRAINT TRICK_STATUS CHECK STATUS IN "AVAILABLE. USED, MAINTAINED">). CONSTRAINT TRUCK WEIGHT CHECK (WEIGHT > 0.0 AND WEIGHT 0.0 AND CAPACITY

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!