earn.zybooks.com$/$zybook$/$Database$\_$Essentials$\_$for$\_$Business$\_$with$\_$Lab$\_\_\_11506/$chapter$/3/$section$/8$

ly library $>$ BIS $245$: Database Essentials for Business with Lab home $>$

$8$: LAB $-$ Create Student table with constraints

$3\mathrm{.}8$ 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 c

LAB

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

Search