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

 3.9 LAB - Insert rows into Horse table The Horse table

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

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!