QUESTION 11 Three questions require you to download the Medicine database MySQL dump (link in Quiz assessment folder) and import it into MySQL Based on the Medicines database you imported, complete t...
QUESTION 11 Three questions require you to download the Medicine database MySQL dump (link in Quiz assessment folder) and import it into MySQL Based on the Medicines database you imported, complete the SQL statement below to add the table Locations to record the state (up to 6) a Manufacturer can operate in. When completing the statement, ensure you use the same naming conventions as other columns in the database and choose the most appropriate datatype. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces Locations CHAR(3), PRIMARY KEY FOREIGN KEY (manufacturerID) REFERENCES Manufacturer (manufacturerlD)
QUESTION 11 Three questions require you to download the Medicine database MySQL dump (link in Quiz assessment folder) and import it into MySQL Based on the Medicines database you imported, complete the SQL statement below to add the table Locations to record the state (up to 6) a Manufacturer can operate in. When completing the statement, ensure you use the same naming conventions as other columns in the database and choose the most appropriate datatype. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces Locations CHAR(3), PRIMARY KEY FOREIGN KEY (manufacturerID) REFERENCES Manufacturer (manufacturerlD)