Error starting at line : 235 in command -
INSERT INTO car (id_car, model, fuel, millage_berfore, millage_after, car_id)
VALUES (103,'Toyota', 0.3, 26, 100, 17264)
Error report -
ORA-00001: unique constraint (JPACALOVA.CAR_PK) violated


Error starting at line : 239 in command -
INSERT INTO contract (id_contract, period, amount, bill_amount, millage, rent, sales_sales_id)
VALUES (101,'01-JUN-2018', 20000, 30000,1000,'05-JUN-2018', 102)
Error report -
ORA-02291: integrity constraint (JPACALOVA.CONTRACT_SALES_FK) violated - parent key not found



-- Generated by Oracle SQL Developer Data Modeler 18.3.0.268.1156
-- at: 2019-10-31 14:30:17 GMT
-- site: Oracle Database 11g
-- type: Oracle Database 11g



-- Generated by Oracle SQL Developer Data Modeler 19.1.0.081.0911
-- at: 2019-11-26 15:14:40 GMT
-- site: Oracle Database 11g
-- type: Oracle Database 11g



CREATE TABLE car (
id_car NUMBER,
model VARCHAR2(30),
fuel NUMBER CHECK(fuel==0.30),
millage_berfore NUMBER,
millage_after NUMBER,
car_id NUMBER NOT NULL
);

ALTER TABLE car ADD CONSTRAINT car_id PRIMARY KEY ( car_id );

CREATE TABLE category (
saloon VARCHAR2(30),
hatchback VARCHAR2(30),
car_car_id NUMBER NOT NULL
);

CREATE UNIQUE INDEX category__idx ON
category (
car_car_id
ASC );

CREATE TABLE contract (
id_contract NUMBER,
period DATE,
amount NUMBER,
bill_amount NUMBER,
millage NUMBER CHECK(millage<=3000),
rent DATE,
sales_sales_id NUMBER NOT NULL
);

CREATE TABLE customer (
id_customer NUMBER,
name VARCHAR2(20),
phone_numbers NUMBER,
address VARCHAR2(30),
email_address VARCHAR2(20),
age NUMBER CHECK(age>=18),
customer_number NUMBER,
customer_id NUMBER NOT NULL,
speedy_rental_speedy_rental_id NUMBER NOT NULL
);

ALTER TABLE customer ADD CONSTRAINT customer_pk PRIMARY KEY ( customer_id );

CREATE TABLE sales (
name VARCHAR2(20),
address CLOB,
phone_number NUMBER,
email_address VARCHAR2(20),
date_of_birthday DATE,
employment DATE,
company_email VARCHAR2(20),
"online" NUMBER,
sales_id NUMBER NOT NULL,
customer_customer_id NUMBER NOT NULL
);

ALTER TABLE sales ADD CONSTRAINT sales_pk PRIMARY KEY ( sales_id );

CREATE TABLE speedy_rental_branch (
id_car NUMBER,
address VARCHAR2(20),
phone_number NUMBER,
emloyment DATE,
speedy_rental_id NUMBER NOT NULL
);

ALTER TABLE speedy_rental_branch ADD CONSTRAINT speedy_rental_pk PRIMARY KEY ( speedy_rental_id );

ALTER TABLE category
ADD CONSTRAINT category_car_fk FOREIGN KEY ( car_car_id )
REFERENCES car ( car_id );

ALTER TABLE contract
ADD CONSTRAINT contract_sales_fk FOREIGN KEY ( sales_sales_id )
REFERENCES sales ( sales_id );

ALTER TABLE customer
ADD CONSTRAINT customer_speedy_rental_fk FOREIGN KEY ( speedy_rental_speedy_rental_id )
REFERENCES speedy_rental_branch ( speedy_rental_id );

ALTER TABLE sales
ADD CONSTRAINT sales_customer_fk FOREIGN KEY ( customer_customer_id )
REFERENCES customer ( customer_id );

CREATE SEQUENCE car_car_id_seq START WITH 1 NOCACHE ORDER;

CREATE OR REPLACE TRIGGER car_car_id_trg BEFORE
INSERT ON car
FOR EACH ROW
WHEN ( new.car_id IS NULL )
BEGIN
:new.car_id := car_car_id_seq.nextval;
END;
/

CREATE SEQUENCE customer_customer_id_seq START WITH 1 NOCACHE ORDER;

CREATE OR REPLACE TRIGGER customer_customer_id_trg BEFORE
INSERT ON customer
FOR EACH ROW
WHEN ( new.customer_id IS NULL )
BEGIN
:new.customer_id := customer_customer_id_seq.nextval;
END;
/

CREATE SEQUENCE sales_sales_id_seq START WITH 1 NOCACHE ORDER;

CREATE OR REPLACE TRIGGER sales_sales_id_trg BEFORE
INSERT ON sales
FOR EACH ROW
WHEN ( new.sales_id IS NULL )
BEGIN
:new.sales_id := sales_sales_id_seq.nextval;
END;
/

CREATE SEQUENCE speedy_rental_branch_speedy_re START WITH 1 NOCACHE ORDER;

CREATE OR REPLACE TRIGGER speedy_rental_branch_speedy_re BEFORE
INSERT ON speedy_rental_branch
FOR EACH ROW
WHEN ( new.speedy_rental_id IS NULL )
BEGIN
:new.speedy_rental_id := speedy_rental_branch_speedy_re.nextval;
END;
/



-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE 6
-- CREATE INDEX 1
-- ALTER TABLE 8
-- CREATE VIEW 0
-- ALTER VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 4
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 4
-- CREATE MATERIALIZED VIEW 0
-- CREATE MATERIALIZED VIEW LOG 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ORDS DROP SCHEMA 0
-- ORDS ENABLE SCHEMA 0
-- ORDS ENABLE OBJECT 0
--
-- ERRORS 0
-- WARNINGS 0

-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE 1
-- CREATE INDEX 0
-- ALTER TABLE 0
-- CREATE VIEW 0
-- ALTER VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- CREATE MATERIALIZED VIEW LOG 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ORDS DROP SCHEMA 0
-- ORDS ENABLE SCHEMA 0
-- ORDS ENABLE OBJECT 0
--
-- ERRORS 0
-- WARNINGS 0

-- car table insert
INSERT INTO car (id_car, model, fuel, millage_berfore, millage_after, car_id)
VALUES (103,'Toyota', 0.3, 26, 100, 17264);

-- insert into contract
INSERT INTO contract (id_contract, period, amount, bill_amount, millage, rent, sales_sales_id)
VALUES (101,'01-JUN-2018', 20000, 30000,1000,'05-JUN-2018', 102);


-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE 6
-- CREATE INDEX 1
-- ALTER TABLE 8
-- CREATE VIEW 0
-- ALTER VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 4
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 4
-- CREATE MATERIALIZED VIEW 0
-- CREATE MATERIALIZED VIEW LOG 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ORDS DROP SCHEMA 0
-- ORDS ENABLE SCHEMA 0
-- ORDS ENABLE OBJECT 0
--
-- ERRORS 0
-- WARNINGS 0