Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use SQL Workbench. Module 6 KimTay Pet Supplies. 1. Create a NONCAT table with the structure shown in FIgure 6-28. (Picture Below) 2. Insert into

Use SQL Workbench. Module 6 KimTay Pet Supplies.

1. Create a NONCAT table with the structure shown in FIgure 6-28. (Picture Below)

image text in transcribed2. 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.

3. In the NONCAT table, change the description of item ID DT12 to "Dog Toy Gift Bonanza."

4. In the NONCAT table, increase the price of each item in category BRD by 5 percent. (Hint: Multiply each price by 1.05.)

5. Add the following item to the NONCAT table: item ID: FF17; description: Premium Fish Food; number of units on hand: 10; category: FSH; and price: 11.95.

NONCAT FIGURE 6-28 NONCAT table layout

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

Database Processing

Authors: David M. Kroenke, David Auer

11th Edition

B003Y7CIBU, 978-0132302678

More Books

Students also viewed these Databases questions

Question

Discuss the activities involved in sales force management?

Answered: 1 week ago

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago