Witam. Baza dancyh to wypożyczalnia samochodów, tabela główna "CAR_RENTAL". Przy wstawianiu do tabeli głównej wyskakuje mi błąd "... naruszono więzy spójności (GRZECHU.ID_CAR_FK) - nie znaleziono klucza nadrzędnego ". Da sie tylko dodac rekord do tabeli glownej gdy wszystkie komórki id = 1.
Schemat bazy:
```CREATE TABLE employeers
(id_employee number(9) NOT NULL,
name varchar(20) NOT NULL,
surname varchar(20) NOT NULL,
address varchar(30) NOT NULL,
tel number(6) NOT NULL,
pesel number(11) NOT NULL,
date_of_employmen date NOT NULL,
CONSTRAINT id_employee_pk PRIMARY KEY (id_employee)
);
CREATE TABLE customer
(id_customer number(9) NOT NULL,
name varchar(20) NOT NULL,
surname varchar(20) NOT NULL,
address varchar(30) NOT NULL,
tel number(6) NOT NULL,
pesel number(11) NOT NULL,
training_drive date NOT NULL,
CONSTRAINT id_customer_pk PRIMARY KEY (id_customer)
);
CREATE TABLE car
(
id_car number(9)NOT NULL,
brand_car varchar(20) NOT NULL,
model_car varchar(20) NOT NULL,
year_of_production number(4) NOT NULL,
engine_capacity number(4) NOT NULL,
power number(3) NOT NULL,
mileage_car number(6) NOT NULL,
type_of_drive varchar(10),
engine_type varchar(10) NOT NULL,
number_of_seats number(2) NOT NULL,
combsuntion_of_fuel number(2),
CONSTRAINT id_car_pk PRIMARY KEY (id_car)
);
CREATE TABLE data_hire
(id_data number(9) NOT NULL,
day number(3) NOT NULL,
price number(5,2) NOT NULL,
rebate number (2) NOT NULL,
CONSTRAINT id_data_pk PRIMARY KEY (id_data)
);
CREATE TABLE car_rental
(
id_hire number(9) NOT NULL,
id_customer number(9) NOT NULL,
id_car number(9) NOT NULL,
id_employee number(9) NOT NULL,
id_data number(9) NOT NULL,
CONSTRAINT id_hire_pk PRIMARY KEY (id_hire),
CONSTRAINT id_customer_fk FOREIGN KEY (id_customer) REFERENCES customer(id_customer),
CONSTRAINT id_car_fk FOREIGN KEY (id_car) REFERENCES car(id_car),
CONSTRAINT id_employee_fk FOREIGN KEY (id_employee) REFERENCES employeers(id_employee),
CONSTRAINT id_data_fk FOREIGN KEY (id_data) REFERENCES data_hire(id_data)
);