3.7 LAB - Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. • ID - integer with range 0 to 65 thousand, auto increment, primary key • RegisteredName - variable-length string with max 15 chars, not NULL • Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred • Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be ≥ Jan 1, 2015 Note: Not all constraints can be tested due to current limitations of MySQL.
3.7 LAB - Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. • ID - integer with range 0 to 65 thousand, auto increment, primary key • RegisteredName - variable-length string with max 15 chars, not NULL • Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred • Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be ≥ Jan 1, 2015 Note: Not all constraints can be tested due to current limitations of MySQL.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Topic Video
Question

Transcribed Image Text:3.7 LAB - Create Horse table with constraints
Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated.
ID - integer with range 0 to 65 thousand, auto increment, primary key
●
RegisteredName - variable-length string with max 15 chars, not NULL
●
Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint,
Saddlebred
●
Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0
• BirthDate - date, must be ≥ Jan 1, 2015
Note: Not all constraints can be tested due to current limitations of MySQL.
401682.2354678.qx3zqy7
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
I keep getting this message.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'number(66) primary key, RegisteredName varchar(15)Not null, Breed varchar(20), H' at line 2

Transcribed Image Text:1 create table HORSE (
2 ID number (66) primary key,
3 RegisteredName varchar(15)Not null,
4 Breed varchar(20),
5 Height (>=10 and <=20)integer (3)
6 BirthDate date(>= Jan, 2015));
Main.sql
Solution
Follow-up Question
What do I put in the corresponding numbers

Transcribed Image Text:Edit View History Bookmarks Window Help
Grades for Gerardo Quintero: 202230 Databas...
zyBooks
esc
1
Q
A
Mind Tap - Cengage Learning
My library > CGS 2545C: Database Management Systems home >
11.1: LAB - Create Horse table with constraints
10
leger
Saddlebred
2
RegisteredName - variable-length string with max 15 chars, not NULL
• Breed-variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Pain
• Height-number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0
• BirthDate- date, must be ≥ Jan 1, 2015
Note: Not all constraints can be tested due to current limitations of MySQL.
392832.2608952.qx3zqy7
LAB
ACTIVITY 11.1.1: LAB - Create Horse table with constraints
1 DataType NOT NULL AUTO_INCREMENT
2 DataType NOT NULL,
W
S
I
#
3
E
D
JUL
20
$
4
R
F
%
175⁰
learn.zybooks.com
T
G
<C
Main.sql
Y
&
7
zy Section 11.1 - CGS 2545C: Database Managem...
H
U
8
J
LE zyBooks catalog
zyBooks catalog ? Help/F
#tv A
9
Ć
K
O
0
Load default template...
L
0/10
DO
P
1
{
Solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education