I need help with this question for my Database Management class for SQL developer. Thank you REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE) Write SQL Queries to: a) Permit joshi to update the ITEM table. b) Increase the Price of Items in ITEM by 10% c) Create an index on balance for the Customer table. d) Add a new order to the database, where Order_Num is 51627 (character type) , Customer_Num is 111 (numeric), and Order_Date is 10/17/2015. e) Add a 5 character column Item_Location to ITEM table.
I need help with this question for my
REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE)
CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM)
ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM)
ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE)
ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)
Write SQL Queries to:
a) Permit joshi to update the ITEM table.
b) Increase the Price of Items in ITEM by 10%
c) Create an index on balance for the Customer table.
d) Add a new order to the database, where Order_Num is 51627 (character type) , Customer_Num is 111 (numeric), and Order_Date is 10/17/2015.
e) Add a 5 character column Item_Location to ITEM table.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
