Question: The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable - length string, NULL values allowed Breed -

The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string, NULL values allowed
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred
Height - decimal number, must be between 10.0 and 20.0
BirthDate - date, must be on or after Jan 1,2015
Insert the following data into Horse:
RegisteredName
Breed
Height
BirthDate
Babe
Quarter Horse
15.3
2015-02-10
Independence
Holsteiner
16.0
2017-03-13
Ellie
Saddlebred
15.0
2016-12-22
NULL
Egyptian Arab
14.9
2019-10-12
To confirm that the inserts have been applied, add the SELECT * FROM HORSE; statement.To confirm that the inserts have been applied, add the SELECT * FROM HORSE; statement.To confirm that the inserts have been applied, add the SELECT * FROM HORSE ; statement.
Main.sql
Main.sql
 The Horse table has the following columns: ID - integer, auto

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!