MOMIS: VOLKSWAGEN data source definition

Schema E/R

Data structure

CAR
NAME CHAR(15) NOT NULL,
WHEELBASE DECIMAL(6,2) NOT NULL,
FRONT_TRACK DECIMAL(6,2) NOT NULL,
REAR_TRACK DECIMAL(6,2) NOT NULL,
LENGTH DECIMAL(6,2) NOT NULL,
WIDTH DECIMAL(6,2) NOT NULL,
HEIGHT DECIMAL(6,2) NOT NULL,
GROUND_CLEARANCE DECIMAL(6,2) NOT NULL,
PRIMARY KEY (NAME)

DRIVE_TRAIN
DRIVE_TRAINS CHAR(50) NOT NULL,
TRANS_GEAR_RATIO CHAR(20) NOT NULL,
PRIMARY KEY (DRIVE_TRAINS,TRANS_GEAR_RATIO)

ELECTRICAL_SYSTEM
ALTERNATOR_V_A CHAR(20) NOT NULL,
BATTERY_V INTEGER NOT NULL,
BATTERY_A_HRS INTEGER NOT NULL,
IGNITION CHAR(70) NOT NULL,
PRIMARY KEY (IGNITION,ALTERNATOR_V_A,BATTERY_V, BATTERY_A_HRS)

ENGINE
COD_E CHAR(15) NOT NULL,
TYPE CHAR(80) NOT NULL,
BORE_CM DECIMAL(5,2) NOT NULL,
STROKE_CM DECIMAL(5,2) NOT NULL,
DISPLACEMENT_CC INTEGER NOT NULL,
COMPRESSION_RATIO CHAR(10) NOT NULL,
HORSEPOWER CHAR(15) NOT NULL,
kW CHAR(15) NOT NULL,
MAX_TORQUE_MKG CHAR(15) NOT NULL,
MAX_TORQUE_NM CHAR(15) NOT NULL,
FUEL_REQUIREMENT CHAR(25) NOT NULL,
ARRANGEMENT CHAR(50) NOT NULL,
CYLINDER_BLOCK CHAR(50) NOT NULL,
CRANCK_SHAFT CHAR(50) NOT NULL,
CYLINDER_HEAD CHAR(50) NOT NULL,
VALVE_TRAIN CHAR(200) NOT NULL,
COOLING_SYSTEM CHAR(200) NOT NULL,
LUBRIFICATION CHAR(200) NOT NULL,
FUEL_AIR_SUPPLY CHAR(100) NOT NULL,
EMISSION CHAR(220) NOT NULL,
ALTERNATOR_V_A CHAR(20) NOT NULL,
BATTERY_V INTEGER NOT NULL,
BATTERY_A_HRS INTEGER NOT NULL,
IGNITION CHAR(50) NOT NULL,
FIRE_ORDER CHAR(15) NOT NULL,
ENGINE_OIL_L DECIMAL(5,2) NOT NULL,
FUEL_TANK_L DECIMAL(5,2) NOT NULL,
COOLING_SYSTEM_L DECIMAL(5,2) NOT NULL,
WIPER_FLUID_L DECIMAL(5,2) NOT NULL,
PRIMARY KEY (COD_E) ,
FOREIGN KEY (IGNITION,ALTERNATOR_V_A,BATTERY_V,BATTERY_A_HRS)
REFERENCES ELECTRICAL_SYSTEM (IGNITION,ALTERNATOR_V_A,BATTERY_V,BATTERY_A_HRS)

GEAR
COD_E CHAR(15) NOT NULL,
DRIVE_TRAINS CHAR(50) NOT NULL,
TRANS_GEAR_RATIO CHAR(20) NOT NULL,
FIRST CHAR(10) NOT NULL,
SECOND CHAR(10) NOT NULL,
THIRD CHAR(10) NOT NULL,
FOURTH CHAR(10) NOT NULL,
FIFTH CHAR(10),
REVERSE CHAR(10),
FINAL_DRIVE CHAR(10),
PRIMARY KEY (COD_E,DRIVE_TRAINS,TRANS_GEAR_RATIO),
FOREIGN KEY (COD_E) REFERENCES ENGINE(COD_E) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (DRIVE_TRAINS,TRANS_GEAR_RATIO) REFERENCES DRIVE_TRAIN(DRIVE_TRAINS,TRANS_GEAR_RATIO) ON DELETE NO ACTION ON UPDATE NO ACTION);
CREATE TABLE STEERING (STEERING CHAR(35) NOT NULL,
PRIMARY KEY (STEERING));
CREATE TABLE MODEL (NAME CHAR(15) NOT NULL,
COD_E CHAR(15) NOT NULL,
EPA_CLASS CHAR(20) NOT NULL,
PASSENGER_VOL_DM3 INTEGER NOT NULL,
TRUNCK_VOL_DM3 INTEGER NOT NULL,
SEATING_CAPACITY INTEGER NOT NULL,
VOL_FRONT_DM3 INTEGER NOT NULL,
VOL_REAR_DM3 INTEGER NOT NULL,
HEAD_ROOM_FRONT_CM DECIMAL(5,1) NOT NULL,
HEAD_ROOM_REAR_CM DECIMAL(5,1) NOT NULL,
SHOULDER_ROOM_FRONT_CM DECIMAL(5,1) NOT NULL,
SHOULDER_ROOM_REAR_CM DECIMAL(5,1) NOT NULL,
LEG_ROOM_FRONT_CM DECIMAL(5,1) NOT NULL,
LEG_ROOM_REAR_CM DECIMAL(5,1) NOT NULL,
BODY_TYPE CHAR(80) NOT NULL,
SUSPENSION_FRONT CHAR(200) NOT NULL,
SUSPENSION_REAR CHAR(200) NOT NULL,
SERVICE_BRAKE CHAR(200) NOT NULL,
ANTI_LOCK_BRAK_SYS CHAR(80) NOT NULL,
PARKING_BRAKE CHAR(80) NOT NULL,
WHEELS CHAR(100) NOT NULL,
TIRES CHAR(100) NOT NULL,
DRAG_COEFFICIENT DECIMAL(5,2) NOT NULL,
STEERING CHAR(50) NOT NULL,
TURNS_LOCK2LOCK DECIMAL(5,2) NOT NULL,
TURNING_CIRCLE_C2C_M DECIMAL(5,2) NOT NULL,
RATIO CHAR(10) NOT NULL,
PRICE DECIMAL(8,2) NOT NULL,
PRIMARY KEY (NAME,COD_E),
FOREIGN KEY (COD_E) REFERENCES ENGINE(COD_E),
FOREIGN KEY (NAME) REFERENCES CAR(NAME),
FOREIGN KEY (STEERING) REFERENCES STEERING(STEERING)

FUEL_CONSUMPTION
NAME CHAR(15) NOT NULL,
COD_E CHAR(15) NOT NULL,
DRIVE_TRAINS CHAR(50) NOT NULL,
TRANS_GEAR_RATIO CHAR(20) NOT NULL,
CITY_KM_L INTEGER NOT NULL,
HIGHWAY_KM_L INTEGER NOT NULL,
PRIMARY KEY (NAME,COD_E,DRIVE_TRAINS,TRANS_GEAR_RATIO),
FOREIGN KEY (NAME) REFERENCES CAR(NAME),
FOREIGN KEY (COD_E) REFERENCES ENGINE(COD_E),
FOREIGN KEY (DRIVE_TRAINS,TRANS_GEAR_RATIO) REFERENCES DRIVE_TRAIN(DRIVE_TRAINS,TRANS_GEAR_RATIO)

WEIGHTS
NAME CHAR(15) NOT NULL,
COD_E CHAR(15) NOT NULL,
DRIVE_TRAINS CHAR(50) NOT NULL,
TRANS_GEAR_RATIO CHAR(20) NOT NULL,
CURB_KG INTEGER,
PAYLOAD_KG INTEGER,
PRIMARY KEY (NAME,COD_E,DRIVE_TRAINS,TRANS_GEAR_RATIO),
FOREIGN KEY (NAME) REFERENCES CAR(NAME),
FOREIGN KEY (DRIVE_TRAINS,TRANS_GEAR_RATIO) REFERENCES DRIVE_TRAIN(DRIVE_TRAINS,TRANS_GEAR_RATIO),
FOREIGN KEY (COD_E) REFERENCES ENGINE(COD_E)

Back
The MOMIS Home Page