Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started