DAT/380 Week 3 LAB 3.10 – Create Horse table with constraints

$ 5

DAT/380 Week 3 LAB 3.10 – 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 65 thousand, 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.0 and ≤ 20.0
BirthDate – date, must be ≥ Jan 1, 2015

Note: Not all constraints can be tested due to current limitations of MySQL.

996 in stock

SKU: DAT380WK3L3P10 Category:

Description

DAT/380 Week 3 LAB 3.10 – 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 65 thousand, 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.0 and ≤ 20.0
BirthDate – date, must be ≥ Jan 1, 2015

Note: Not all constraints can be tested due to current limitations of MySQL.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.