I have created a table filght and i want to insert some values but… I have created a table filght and i want to insert some values but i am getting error.The table script is;CREATE TABLE FLIGHT ( TicketID INT NOT NULL, DipartureDate DATE, ArrivalDate DATE, TicketType VARCHAR(255), TicketPrice INT, AirplaneID INT NOT NULL, DepartureAirport VARCHAR(255) NOT NULL, ArrivalAirport VARCHAR(255) NOT NULL, Airlinecompany VARCHAR(255) NOT NULL, PRIMARY KEY (TicketID), FOREIGN KEY (AirplaneID) REFERENCES AIRPLANE(AirplaneID), FOREIGN KEY (DepartureAirport) REFERENCES AIRPORT(AirportName), FOREIGN KEY (ArrivalAirport) REFERENCES AIRPORT(AirportName), FOREIGN KEY (Airlinecompany) REFERENCES AIRLINE(Company)); I want to insert these values;INSERT INTO FLIGHTVALUES (12, TO_DATE(‘2021/09/20′,’YYYY/MM/DD’) , TO_DATE(‘2021/09/21′,’YYYY/MM/DD’), ‘Bis’, 800,233, ‘HA’, ‘CC’, ‘Azal’);INSERT INTO FLIGHTVALUES (45, TO_DATE(‘2021-06-10′,’YYYY-MM-DD’) ‘,TO_DATE(‘2021-06-11′,’YYYY-MM-DD’), ‘Ec’, 200,551, ‘IST’, ‘TA’, ‘Turkish’);INSERT INTO FLIGHTVALUES (67, TO_DATE(‘2021-08-07′,’YYYY-MM-DD’), TO_DATE(‘2021-08-08′,’YYYY-MM-DD’), ‘Bis’, 900,889, ‘ND’, ‘GE’, ‘Geo’);INSERT INTO FLIGHTVALUES (72, TO_DATE(‘2021-10-04′,’YYYY-MM-DD’), TO_DATE(‘2021-10-05′,’YYYY-MM-DD’), ‘Bis’, 1100,481, ‘CAN’, ‘DOM’, ‘Aeroflot’);INSERT INTO FLIGHTVALUES (55, TO_DATE(‘2021-05-19′,’YYYY-MM-DD’) ‘, TO_DATE(‘2021-05-20′,’YYYY-MM-DD’), ‘Ec’, 400,766, ‘BE’, ‘KC’, ‘Pekin’);INSERT INTO FLIGHTVALUES (96, TO_DATE(‘2021-05-21′,’YYYY-MM-DD’), TO_DATE(‘2021-05-22′,’YYYY-MM-DD’), ‘Ec’, 350,122, ‘ND’, ‘HA’, ‘Delhi’);INSERT INTO FLIGHTVALUES (03, TO_DATE(‘2021-11-19′,’YYYY-MM-DD’), TO_DATE(‘2021-11-20′,’YYYY-MM-DD’), ‘Ec’, 500,663, ‘CC’, ‘DOM’, ‘Aeroflot’);INSERT INTO FLIGHTVALUES (88, TO_DATE(‘2021-12-11′,’YYYY-MM-DD’), TO_DATE(‘2021-12-12′,’YYYY-MM-DD’), ‘Bis’, 700,334, ‘IST’, ‘KC’, ‘Ukr’);INSERT INTO FLIGHTVALUES (19, To_DATE(‘2021-07-07’,’YYYY-MM-DD ‘), ‘2021-07-07 ‘, ‘Ec’, 250,887, ‘TA’, ‘GE’, ‘IS’);INSERT INTO FLIGHTVALUES (31, TO_DATE(‘2021-11-11′,’YYYY-MM-DD’), TO_DATE(‘2021-11-12′,’YYYY-MM-DD’), ‘Bis’, 600,111, ‘BE’, ‘CC’, ‘Masr’);But i am geting error ;Error starting at line : 29 in command -INSERT INTO FLIGHTVALUES (31, TO_DATE(‘2021-11-11′,’YYYY-MM-DD’), TO_DATE(‘2021-11-12′,’YYYY-MM-DD’), ‘Bis’, 600,111, ‘BE’, ‘CC’, ‘Masr’)Error report -ORA-02291: integrity constraint (SYS_C002204284) violated – parent key not found please fix the error and write the correct script. Computer Science Engineering & Technology MYSQL DBS 211
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more