$3\mathrm{.}5$ LAB $-$ Create Student table with constraints

Create a Student table with the following column names, data types, and constraints:

ID $-$ integer with range $0$ to $65$ thousand, auto increment, primary key

FirstName $-$ variable$-$length string with max $20$ chars, not NULL

LastName $-$ variable$-$length string with max $30$ chars, not NULL

Street $-$ variable$-$length string with max $50$ chars, not NULL

City $-$ variable$-$length string with max $20$ chars, not NULL

State $-$ fixed$-$length string of $2$ chars, not NULL, default $"$TX$"$

Zip $-$ integer with range $0$ to $16$ million, not NULL

Phone $-$ fixed$-$length string of $10$ chars, not NULL

Email $-$ variable$-$length string with max $30$ chars, must be unique

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

$550750\mathrm{.}3461566\mathrm{.}9329y7$

LAB

ACTIVITY

$3\mathrm{.}5\mathrm{.}1$: LAB $-$ Create Student table with constraints

$\frac{6}{10}$

Main.sql

Load default template...

$1--$ Your SQL statements go here

$2$

Explore the database and run your program as often as you'd like, before submitting for

grading. Click Run program and observe the program's output in the second box.