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 keyRegisteredName - variable-length string with max 15 chars, not NULLBreed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, SaddlebredHeight - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0BirthDate - date, must be ≥ Jan 1, 2015

Lets see the solution.The create table command will be as follows :

Answered: e table with the following columns,…

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

Question

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

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 entered this and it is still not correct. I need each answer separated on the table and it is showing up all together.

2: Test Registered Name column
Your result
Expected result
ID
Breed
Field
Registered Name varchar(15)
Height
BirthDate
Field
Type
smallint
date
Null Key Default
NO PRI NULL auto_increment
varchar(20) YES
decimal(3,1) YES
Type
NO
YES
RegisteredName varchar(15) NO
NULL
NULL
Field
RegisteredName varchar(15) NO
NULL
Null Key Default Extra
NULL
NULL
Type Null Key Default Extra
NULL
Extra
0/2

1:Test ID column ^
Your result
Expected result
ID
Breed
RegisteredName varchar(15)
Height
Field
BirthDate
Field
ID
Field
Type
smallint
Type
date
varchar(20) YES
decimal(3,1) YES
Type
Null Key Default
NO PRI NULL
smallint
NO
YES
NULL
NULL
NULL
NULL
Extra
auto_increment
Null Key Default
ID smallint unsigned NO PRI NULL auto_increment
Null Key Default Extra
NO PRI NULL auto_increment
Extra
0/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