Question: THIS IS THE SQL USED AND I AM NOT GETTING DATA ON THE FOLLOWING, ANY IDEA ON WHAT IS CAUSING THE ISSUE? . CREATE TABLE
THIS IS THE SQL USED AND I AM NOT GETTING DATA ON THE FOLLOWING, ANY IDEA ON WHAT IS CAUSING THE ISSUE? .
CREATE TABLE Vehicle ( VehicleID INT UNSIGNED NOT NULL AUTO_INCREMENT, Number INT UNSIGNED NOT NULL, Model VARCHAR(20) NOT NULL, PRIMARY KEY (VehicleID) );
CREATE TABLE VehicleEvent ( VehicleID INT UNSIGNED, EventNumber INT UNSIGNED, FOREIGN KEY (VehicleID) REFERENCES Vehicle(VehicleID) ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (EventNumber) REFERENCES Event(EventNumber) ON DELETE RESTRICT ON UPDATE RESTRICT, PRIMARY KEY(VehicleID, EventNumber) );

2:Test multiple Vehicle columns Your result Your SQL produced no results Expected result 3:Test Vehicle unique columns Your result Your SQL produced no results Expected result
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
