CREATE TABLE `car_information` (
`id` INT NOT NULL PRIMARY KEY,
`car_make` VARCHAR(50) NOT NULL,
`car_color` VARCHAR(50) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE `car_images` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`car_id` INT NOT NULL,
`image` VARCHAR(100)
) ENGINE=InnoDB;
INSERT INTO `car_information` (`id`, `car_make`, `car_color`) VALUES
(2, 'Fiat', 'Blue'),
(3, 'BMW', 'White'),
(4, 'Volvo', 'White'),
(5, 'Ford', 'Red');
INSERT INTO `car_images` (`car_id`, `image`) VALUES
(2, 'img1'),
(2, 'img2'),
(2, 'img3'),
(3, 'img4'),
(5, NULL),
(5, 'img5'),
(5, NULL);