Complete the following Updating Data Activities using SQL. After completing the required SQL activity, use a Select clause after each activity to display the fields changed to prove the results is correct. 1. Change the description of part BT04 to Oven. 2. Add $100 to the credit limit of every customer represented by sales rep number 06. 3. Add order 12600 (order date: 09/06/2018, customer number: 311) to the database. Add two order lines to this order. On the first line, the part number is AX12, the number ordered is 5, and the quoted price is $13.95. On the second line, the part number is BA74, the number ordered is 3, and the quoted price is $4.50. 4. Write the command to delete every customer whose balance is $0 and who is represented by sales rep 12. Do not execute the command. 5. Create a new table named SPGOOD to contain the columns PART_NUMBER, DESCRIPTION, and UNIT_PRICE. Then insert into this new table the part number, part description, and unit price from the PART table for every part whose item class is SG. 6. Change the street address of sales rep number 03 to null. 7. Add a column named ALLOCATION to the PART table. The allocation is a three-digit number representing the number of units of each part that have been allocated to each customer. Set all values of ALLOCATION to zero. Calculate the number of units of BT04 currently on order. Change the value of ALLOCATION for part number BT04 to this number. 8. Write the command to delete the ITEM_CLASS column from the PART table. Do not execute the command. 9. Increase the length of the PART_DESCRIPTION column to 30 characters. 10. Write the command to remove the PART table from the Premiere Products database. Do not execute the command.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Complete the following Updating Data Activities using SQL. After completing the required SQL activity, use a Select clause after each activity to display the fields changed to prove the results is correct. 1. Change the description of part BT04 to Oven. 2. Add $100 to the credit limit of every customer represented by sales rep number 06. 3. Add order 12600 (order date: 09/06/2018, customer number: 311) to the database. Add two order lines to this order. On the first line, the part number is AX12, the number ordered is 5, and the quoted price is $13.95. On the second line, the part number is BA74, the number ordered is 3, and the quoted price is $4.50. 4. Write the command to delete every customer whose balance is $0 and who is represented by sales rep 12. Do not execute the command. 5. Create a new table named SPGOOD to contain the columns PART_NUMBER, DESCRIPTION, and UNIT_PRICE. Then insert into this new table the part number, part description, and unit price from the PART table for every part whose item class is SG. 6. Change the street address of sales rep number 03 to null. 7. Add a column named ALLOCATION to the PART table. The allocation is a three-digit number representing the number of units of each part that have been allocated to each customer. Set all values of ALLOCATION to zero. Calculate the number of units of BT04 currently on order. Change the value of ALLOCATION for part number BT04 to this number. 8. Write the command to delete the ITEM_CLASS column from the PART table. Do not execute the command. 9. Increase the length of the PART_DESCRIPTION column to 30 characters. 10. Write the command to remove the PART table from the Premiere Products database. Do not execute the command.

CUST_CUSTOMER_NUMBER CUST_LAST CUST_FIRST CUST_STREET
124
239
256
311
315
405
412
522
567
587
622
Adams
(Yours)
Samuels
Charles
Daniels
Williams
Adams
Nelson
Dinah
Galvin
Martins
Sally
(Yours)
Ann
Don
Tom
Al
Sally
Mary
Tran
Mara
Dan
481 Oak
239 Drive
215 Pete
48 College
914 Cherry
519 Watson
16 Elm
108 Pine
ses Ridge
512 Pine
419 Chip
CUST_CITY CUST_STATE CUST_ZIP CODE
Lansing
Edison
Grant
Ira
Kent
Grant
Lansing
Ada
Harper
Ada
Grant
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
49224
8818
49219
49034
48391
49219
49224
49441
48421
49441
49219
CUST BALANCE
818.75
1000
21.5
825.75
770.75
402.75
1817.5
98.75
402.4
114.6
1045.75
CUST CREDIT_LIMIT CUST_SALES_REP_NUMBER
1000
3000
1500
1000
750
1500
2000
1500
750
1000
1000
k
3
12
12
6
6
12
3
6
6
12
3

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions