CREATE TABLE TB_SCOOTERS
   (	V_NAME    VARCHAR2(20), 
	V_ID      NUMBER(4) NOT NULL ENABLE, 
	V_YEAR    NUMBER(4), 
	V_TYPE    VARCHAR2(20), 
	V_MILEAGE NUMBER(4), 
	  CONSTRAINT TB_SCOOTERS_PK PRIMARY KEY (V_ID)
   );
 /

 CREATE TABLE TB_BIKES
   (	V_NAME   VARCHAR2(20), 
	V_ID     NUMBER(4) NOT NULL ENABLE, 
	V_YEAR   NUMBER(4), 
	V_TYPE   VARCHAR2(20), 
	V_ENGINE NUMBER(4), 
	  CONSTRAINT TB_BIKES_PK PRIMARY KEY (V_ID)
   );
 /

 CREATE TABLE TB_CARS
   (	V_NAME     VARCHAR2(20), 
	V_ID       NUMBER(4) NOT NULL ENABLE, 
	V_YEAR     NUMBER(4), 
	V_TYPE     VARCHAR2(20), 
	V_CAR_TYPE VARCHAR2(20), 
	  CONSTRAINT TB_CARS_PK PRIMARY KEY (V_ID)
   );
 /

 CREATE TABLE TB_VEHICLES
   (	V_NAME      VARCHAR2(20), 
	V_ID        NUMBER(4) NOT NULL ENABLE, 
	V_YEAR      NUMBER(4), 
	V_TYPE      VARCHAR2(20), 
	V_COLOR     VARCHAR2(20), 
	V_AVAILABLE VARCHAR2(20), 
	  CONSTRAINT TB_VECHILES_PK PRIMARY KEY (V_ID)
   );
 /


INSERT INTO TB_SCOOTERS (V_NAME, V_ID, V_YEAR, V_TYPE, V_MILEAGE)            VALUES ('Activa', '10', '2003', 'Scooter', '45');
INSERT INTO TB_SCOOTERS (V_NAME, V_ID, V_YEAR, V_TYPE, V_MILEAGE)            VALUES ('Access', '20', '2004', 'Scooter', '50');

INSERT INTO TB_BIKES    ("V_NAME ", V_ID, V_YEAR, V_TYPE, V_ENGINE)          VALUES ('Karizma', '30', '2001', 'Bike', '180');
INSERT INTO TB_BIKES    ("V_NAME ", V_ID, V_YEAR, V_TYPE, V_ENGINE)          VALUES ('Pulsar', '40', '2008', 'Bike', '150');

INSERT INTO TB_CARS     (V_NAME, V_ID, V_YEAR, "V_TYPE ", V_CAR_TYPE)        VALUES ('Linea', '50', '2011', 'Car', 'Sedan');
INSERT INTO TB_CARS     (V_NAME, V_ID, V_YEAR, "V_TYPE ", V_CAR_TYPE)        VALUES ('i20', '60', '2012', 'Car', 'Sedan');

INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('Activa', '10', '2003', 'Scooter', 'Black', 'Yes');
INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('Access', '20', '2004', 'Scooter', 'Black', 'No');
INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('Karizma', '30', '2001', 'Bike', 'Red', 'Yes');
INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('Pulsar', '40', '2008', 'Bike', 'Red', 'Yes');
INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('Linea', '50', '2011', 'Car', 'White', 'No');
INSERT INTO TB_VECHILES (V_NAME, V_ID, V_YEAR, V_TYPE, V_COLOR, V_AVAILABLE) VALUES ('i20', '60', '2012', 'Car', 'Red', 'Yes');


COMMIT;