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

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

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!