Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 1 : Create a NONCAT table with the structure shown below. Field Type Null Key Default ITEM _ ID char ( 4 ) NO
Task : Create a NONCAT table with the structure shown below.
Field Type Null Key Default
ITEMID char NO PRI NULL
DESCRIPTION char YES NULL
ONHAND int YES NULL
CATEGORY char YES NULL
PRICE decimal YES NULL
Task : Insert into the NONCAT table the item ID description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category CAT.
Task : In the NONCAT table, change the description of item ID DT to Dog Toy Gift Bonanza.
Task : In the NONCAT table, increase the price of each item in category BRD by
Multiply each price by
Task : Add the following item to the NONCAT table:
ITEMID : FF
DESCRIPTION : Premium Fish Food,
ONHAND :
CATEGORY : FSH
PRICE :
Task : Delete every item in the NONCAT table for which the category is HOR.
Task : In the NONCAT table, change the category for item UF to null.
Task : Add a column named ONHANDVALUE to the NONCAT table. The onhand value is a sevendigit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ONHANDVALUE to ONHAND PRICE.
Task : In the NONCAT table, increase the length of the DESCRIPTION column to characters.
Task : Remove the NONCAT table from the KimTay Pet Supplies database.
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