Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 . 1 2 LAB - Update rows in Horse table The Horse table has the following columns: ID - integer , auto increment, primary

2
.
1
2
LAB
-
Update rows in 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
>=
1
0
.
0
and
<=
2
0
.
0
BirthDate
-
date, must be
>=
Jan
1
,
2
0
1
5
Make the following updates: Change the height to
1
5
.
6
for horse with ID
2
.
Change the registered name to Lady Luck and birth date to May
1
,
2
0
1
5
for horse with ID
4
.
Change every horse breed to NULL for horses born on or after December
2
2
,
2
0
1
6
.
Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions

Question

=+ What is its mission?

Answered: 1 week ago