3 9 LAB Insert rows into Horse table The Horse table has the following columns ID integer, auto increment, primary key RegisteredName variable length string 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 the Horse table 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 452350 3012772 qx3zqy7 LAB ACTIVITY 3 9 1 LAB Insert rows into Horse table Students Section 3 9 is a part of 1 assignment Week 3 zyBook Labs Requirements zyLab 3 9 LAB Insert rows into Horse table The Horse table has the following columns ID integer, auto increment, primary key RegisteredName variable length string 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 the Horse table

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 11, 2024

3.9 LAB - Insert rows into Horse table The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length

image text in transcribed

3.9 LAB - Insert rows into Horse table

The Horse table has the following columns:

ID - integer, auto increment, primary key

RegisteredName - variable-length string

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 the Horse table:

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

452350.3012772.qx3zqy7

LAB ACTIVITY

3.9.1: LAB - Insert rows into Horse table

Students: Section 3.9 is a part of 1 assignment: Week 3: zyBook Labs Requirements: zyLab 3.9 LAB - Insert rows into Horse table The Horse table has the following columns: - ID - integer, auto increment, primary key - RegisteredName - variable-length string - 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 the Horse table