Details
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.
Additional Information
| Special Price | $3.00 |
|---|
Check items to add to the cart or select all
-
DAT/380 Week 3 LAB 3.11 - Create Student table with constraints
Add to WishlistRegular Price:
Special Price
-
DAT/380 Week 3 LAB 3.12 - Create LessonSchedule table with FK constraints
Add to WishlistRegular Price:
Special Price
-
-
-
-
DAT/380 Week 3 LAB 3.16 - Select horses with logical operators
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
