zy Section $3\mathrm{.}7-$ BIS $245$: Database Essentials for Business with Lab $|$ zyBooks

$-=$ zyBooks

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

zyBooks catalog

Help$/$FAQ

Wilson Duenas $-$

$3\mathrm{.}7$ LAB $-$ Create Horse table with constraints

Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated.

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

RegisteredName $-$ variable$-$length string with max $15$ chars, not NULL

Breed $-$ variable$-$length string with max $20$ chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred

Height $-$ number with $3$ significant digits and $1$ decimal place, must be $10\mathrm{.}0$ and $20\mathrm{.}0$

BirthDate $-$ date, must be $$ Jan $1,2015$

Notes: Not all constraints can be tested due to current limitations of MySQL$.$ Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

LAB

$3\mathrm{.}7\mathrm{.}1$: LAB $-$ Create Horse table with constraints

$\frac{0}{10}$