Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't pinpoint exactly where my issue is. Could I get some help on how to correct my statement? Create a Horse table with the

image text in transcribed

I can't pinpoint exactly where my issue is. Could I get some help on how to correct my statement?

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. \begin{tabular}{l|l} LAB & 3.7.1: LAB - Create Horse table with constraints \end{tabular} 0/10 Main.sql Load default template... 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, 3 RegisteredName VARCHAR(15) NOT NULL, 4 Breed VARCHAR(20) CHECK (Breed IN ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred')) 5 Height DECIMAL (3,1) CHECK (Height >=10.0 AND Height = '2015-01-01')]

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

Practical Issues In Database Management A Refernce For The Thinking Practitioner

Authors: Fabian Pascal

1st Edition

0201485559, 978-0201485554

More Books

Students also viewed these Databases questions