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 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.
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 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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
After composing the code for the " Create Horse Table with Constraints" I'm still not getting an output
CREATE TABLE Horse (
ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
RegisteredName VARCHAR(15) NOT NULL,
Breed VARCHAR(20) CHECK (Breed IN ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred')),
Height DECIMAL(3,1) CHECK (Height between 10.0 AND 20.0),
BirthDate DATE CHECK (BirthDate >= '2015-01-01')
);
by Bartleby Expert
