We are using, Oracle Database 11g Express Edition, Using SQL Thank you. ________

Question

We are using, Oracle Database 11g Express Edition, Using SQL

Thank you.

___________________________________________________________________________________________________

Create a view named ITEM_ORDER. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.

a. Write and execute the CREATE VIEW command to create the ITEM_ORDER view.

b. Write and execute the command to retrieve the item number, description, order number, and quoted price for all orders in the ITEM_ORDER view for items with quoted prices that exceed $100.

c. Write and execute the query that the DBMS actually executes.

d. Does updating the database through this view create any problems? If so, what are

they? If not, why not?

ORDER LINE ORDERS ORDER NUM ORDER DATE CUSTOMER NUM ORDER NUM ITEM NUM NUM ORDERED QUOTED PRICE 51608 33 5 $86.99 51608 10/12/2015 126 51610 1012/2015 334 51610 KL 78 25 $10.95 516 13 10V 13/2015 3s6 51610 TR40 10 S1399 516 14 1013/2015 260 516 13 DL51 5 4.95 51617 10/15/2015 586 51614 FD11 1 24.05 51619 10/15/2015 126 51617 89 4 $115.99 51623 10/15/2015 556 51617 35 3 S116.5 51625 10/10/2015 796 51619 FD 11 2 S121.05 31623 DR67 S20.05 $36.95 51623 FH24 51623 KD34 10 3.10 51625 MTO3 s S45.79 ITEM ITEM NUM DESCRIPTION ON HAND CATEGORY STOREHOUSE PRICE A 74 Patience 9 GME I3 $22.99 BR 23 skittles 21 GME 2 S29.99 36 TOY sso 49 CD33 Wood Block Set (48 piece) 3 12 TOY Classic Railway Set $107.95 DL51 DR67 Giant Star Brain Teaser 24 PZL 2 S31.95 Mancala 40 GME 3 S50.00 DW23 S TOY 3 S124.95 FD11 Rocking Horse Puzzle Gift Set 65 PZL 1 $38.95 FH24 KA12 Cribbage Set 56 GME 3 $75.00 60 PZL 2 $14.95 KD34 Pentomin oes Brain Teaser 110 GME $1095 KL78 Pick Up Sticks s4579 Zauberkasten Brain Teaser MTO3 45 PZL NLS9 Wood Block Set (62 piece) 32 TOY 3 $119.75 Tic Tac Toe 75 GME 2 si 3.99 TR40 $118.95 Fire Engine TW35 30 TOY

Explanation / Answer

CREATE VIEW ITEM_ORDER AS SELECT ITEM_NUM,DESCRIPTION,PRICE FROM ITEM,SELECT ORDER_NUM FROM ORDER_LINE,SELECT ORDER_DATE FROM ORDERS,SELECT NUM_ORDERED,QUOTED_PRICE FROM ORDER_LINE;

SELECT ITEM_NUM,DESCRIPTION,PRICE,QUOTED_PRICE FROM ITEM_ORDER WHERE QUOTED_PRICE >$100

No,View cant update actual tables.When modifying data through a view (that is, using INSERT or UPDATE statements) certain limitations exist depending upon the type of view. Views that access multiple tables can only modify one of the tables in the view.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.