Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

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)

Step by Step Solution

3.29 Rating (152 Votes )

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

Students also viewed these Databases questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago