Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Change to use the database frozenfood 2. Create a table named sizeType with the following attributes, data types, and constraints: a. ID, integer, 7

image text in transcribed

1. Change to use the database frozenfood 2. Create a table named sizeType with the following attributes, data types, and constraints: a. ID, integer, 7 characters, not null, auto increment b. size, variable character, 20 characters, not null c. primary key is the ID field 3. Update table product, row with description as tiramisu classico so the size = '3 ounce' versus '3 oz 4. Insert into table sizeType, column size the distinct character portion of table product, column size using the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value -1. Example SUBSTRING INDEX(,',-1). 5. Alter table product, add column sizeTypeId as integer, 7 characters, not null

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

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago