Question: Any help would be awesome! Thanks SQL Assignment 6 - Creating a database, tables, keys and indexes. Before you start on this assignment you need

Any help would be awesome! Thanks
SQL Assignment 6 - Creating a database, tables, keys and indexes. Before you start on this assignment you need to create a new Database named mytestdb using the following commands. DROP DATABASE IF EXISTS mytestdb; CREATE DATABASE mytestdb; 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 does the following: Step 1. Using the SQL CREA'T'E TABLE command, create the zipcode table as follows: Table: zipcode Step 2. Using the SQL CREATE TABLE command, create the customers table as follows: T'able: customers Create the foreign key using a table level constraint. Step 3. Using the SQL CREA'E 'TABLE command, create the orders table as follows: Table: orders
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
