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
CREATE TABLE Horse
(ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
RegisteredName VARCHAR(15) NOT NULL,
Breed VARCHAR(20) CHECK (Breed=”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’)
);
This is my solution for this question. I scored 9/10 for some odd reason.
“Your result
count() 0
Expected result
count() 1″
It states that I am missing a column constraint, is this an error on my part or the system?
TroubledEngineer is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.