Question

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

          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

zy Section 3.7 - BIS 245: Database Essentials for Business with Lab | zyBooks
https://learn.zybooks.com/zybook/DatabaseEssentialsforBusinesswithLab-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 ≥ 10.0 and ≤ 20.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.
54360638977654 qizay/
ACTIVITY
LAB 3.7.1: LAB - Create Horse table with constraints
0/10

Added by Mary G.

Question

Please give Ace some feedback