*We use mysql and northwind database 2019* I really need help getting started with creating my database so any help will be greatly appreciated.

Before you start on this assignment you need to create a new Database named college using the following commands. DROP DATABASE IF EXISTS college; CREATE DATABASE college; If at any point you wish to start over, you can run these two commands again. The commands will completely delete the mytestdb and then create an empty database. Write an SQL script that creates the following four tables with the constaints as indicated for each: Hint: If you create the foreign references in the CREATE TABLE command you have to create the tables in the correct order for the foreign key references to work. Alternatively, you can create the tables first and then use ALTER TABLE statements to create the foreign key references