Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 430856.3010638.qx3zzyz LAB ACTIVITY 3.9.1: LAB - Insert rows into Horse table 0 / 10 Main.sql Load default template.. 1. UPDATE horse SET height = 15.6 WHERE id = 2; 2. UPDATE horse SET registeredname = 'Lady Luck' , birthdate = '2015-05-01' WHERE id = 4; 10 11 3. 12 UPDATE horse SET breed = NULL WHERE birthdate >= '2016-12-2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

013548622X, 978-0135486221

Students also viewed these General Management questions