Customer

The table name should be CUSTOMERS $($plural$).$

Each CustomerID should be a $3-$digit number.

Names should be strings of up to thirty characters.

The sample data should be:

$101,$ Taylor Swift

$102,[$your name$]$

Order

The table name should be ORDERS $($plural$).$

Each OrderID should be a $4-$digit number.

Product names should be strings of up to thirty characters.

The sample data should be:

$1001,20-$MAY$-24,$ Jasmine Tea, $101$

$1002,[$a date of your choice$],[$a product of your choice$],102$

What you submit are

The SQL script to $($i$)$ drop the two tables, $($ii$)$ create the two tables, $($iii$)$ insert the sample data, and $($iv$)$ show

the full contents of the two tables.

a$.$ The header of your script should be something like:

$\frac{?}{{?}^{**}}$

Your Name

IS$451$ HW$5$

$*/$

b$.$ Make sure to start your script file with DROP TABLE commands for the two tables in order to avoid

conflicts. Use the DROP TABLE commands in the following order.

i$.$ ORDERS

ii$.$ CUSTOMERS

c$.$ Save your SQL script as HW$5$YourName.sql $($e$.$g$.,$ HW$5$JohnDoe.sql$).$

d$.$ Make sure that your SQL script runs without an error from the first line to the last one.

The Word$/$text file to show the entire outputs of your SQL script.

a$.$ The header of your file should be something like:

$\frac{?}{{?}^{**}}$

Your Name

IS$451$ HW$5$

$*/$

b$.$ Name your file to HW$5$YourName.docx $($e$.$g$.,$ HW$5$JohnDoe.docx$)$ or HW$5$YourName.txt $($e$.$g$.,$

HW$5$JohnDoe.txt$).$

c$.$ The easiest is to clear the Script Output window first and then save the output of your script file after

running it$.$