FewqXK0U

1
2DROP DATABASE IF EXISTS transport;
3CREATE DATABASE transport;
4
5USE transport;
6
7CREATE TABLE Vehicles(
8
9	vin varchar(10) NOT NULL,
10    color varchar(10),
11
12	CONSTRAINT pk_vehicles PRIMARY KEY (vin)
13);
14
15CREATE TABLE Cars(
16
17	vin varchar(10) NOT NULL,
18    mileage varchar(7),
19    capacity int,
20    
21    CONSTRAINT fk_vehicles_cars_vi FOREIGN KEY (vin) REFERENCES Vehicles(vin)
22    
23);
24
25INSERT INTO Vehicles (vin,color) VALUES ("01","red");
26INSERT INTO Vehicles (vin,color) VALUES ("02","white");
27INSERT INTO Vehicles (vin,color) VALUES ("03","blue");
28
29INSERT INTO Cars (vin. mileage, capacity) VALUES ("01","100000",2);
30INSERT INTO Cars (vin, mileage, capacity) VALUES ("02", "90000",4);
31INSERT INTO Cars (vin, mileage, capacity) VALUES ("03", "80000",4);