3.7 LAB - Create Horse table with constraintsCreate 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, 2015Note: Not all constraints can be tested due to current limitations of MySQL.401682.2354678.qx3zqy7

Name: 3.7 LAB - Create Horse table with constraintsCreate a Horse table wit
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: 3.7 LAB - Create Horse table with constraintsCreate 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●R

The CREATE TABLE command is used to create a table in MYSQL. The syntax is given below CREATE TABLE…

Answered: 3.7 LAB - Create Horse table with…

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

See similar textbooks

Related questions

Topic Video

Question

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

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

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

by Bartleby Expert

SEE SOLUTION

Follow-up Question

What do I put in the corresponding numbers

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

by Bartleby Expert

SEE 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.

Similar questions