car-centre schema

Tables

CAR

CREATE TABLE CAR(
	CHESIS_NUMBER BIGINT AUTO_INCREMENT PRIMARY KEY,
	MODEL VARCHAR(10),
	COLOR VARCHAR(10),
	MILEAGE DECIMAL,
	MAX_SPEED NUMBER(3)
);

CUSTOMER

EMPLOYEE