$2\mathrm{.}7$ 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.

$542418\mathrm{.}38871309329y?$

LAB

ACTIVITY

$2\mathrm{.}7\mathrm{.}1$: LAB $-$ Create Student table with constraints

$\frac{0}{10}$