zy Section 3.7 - BIS 245: Database Essentials for Business with Lab | zyBooks
https://learn.zybooks.com/zybook/Database_Essentials_for_Business_with_Lab_-_10857/chapter/3/section/7
zyBooks My library > BIS 245: Database Essentials for
3.7: LAB - Create Horse table with constraints
Business with Lab home >
3.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 $\ge$ 10.0 and $\le$ 20.0
BirthDate - date, must be $\ge$ 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.
54360638977654 qizay/
ACTIVITY
LAB 3.7.1: LAB - Create Horse table with constraints
0/10