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) );

THIS IS THE SQL USED AND I AM NOT GETTING DATA ON

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!