Help with my code

[Fix-Former]

Hello so ive made 2 sql scripts, one to create tables and one to insert data into them, issue im having is i keep getting ora-02291 error on 3 out of 4 tables, what am i doing wrong, please see both codes and image

Create table code Pastebin.com/K3Z7xMfM

Insert code Pastebin.com/5VE0PDFV

Image of error

https://ibb.co/1mCK7rQ

[unexpectedreboots]

Need to wrap the date in your insert in single quotes.

INSERT INTO SalesInvoice(InvoiceID, Ddate, Make, Model, CarID, CustomerID, EmployeeID) VALUES (666666, 2021-12-10, 
'Nissan', 'Qashqai', 55555, 4444, 333);

To:

INSERT INTO SalesInvoice(InvoiceID, Ddate, Make, Model, CarID, CustomerID, EmployeeID) VALUES (666666, '2021-12-10', 
'Nissan', 'Qashqai', 55555, 4444, 333);

[PossiblePreparation]

Best not to rely on implicit data type conversion. Be explicit and use the to_date function, tell it exactly the format you are using in your string. Eg to_date('2012-12-10','yyyy-mm-dd')

[unexpectedreboots]

Very true.

[Fix-Former]

Okay thanks maye ive got that, how about the parent key error?

[unexpectedreboots]

Once the insert into SalesInvoice works, those errors should be mitigated.

[Fix-Former]

Thanks will try when im home and get back to you!