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

$3\mathrm{.}8$: LAB $-$

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

ZyBooks c

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