Verify Vehicle and VehicleEvent column names, data types, primary keys, foreign keys, and constraints.

Feedback

$+0$ FAIL: Vehicle table has incorrect name, data type, or constraint in column$($s$)$:

StateCode

$+1$ PASS: Vehicle table primary key is VehicleID

$+1$ PASS: Vehicle table UNIQUE constraint on $($PlateID$,$ StateCode$)$ found

$+2$ PASS: VehicleEvent table has correct column names, data types, and constraints

$+1$ PASS: VehicleEvent table primary key is $($VehicleID$,$ EventNumber$)$

$+0$ FAIL: VehicleEvent table VehicleID foreign key is incorrect

$+0$ FAIL: VehicleEvent table EventNumber foreign key is incorrect

$+1$ PASS: No other foreign keys in Vehicle or VehicleEvent table