Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
I need help on part said update the data I get erro . Create a table as follows Inventory InvID number (10), Description varchar2(20), Price number(7,2), Quantity number(5,2) Add three constraints a) Primary key b) CHECK, price less or equal to $ 10000 c) description UNIQUE Enter the following data, assign inventory IDs as seems needed to you for your inventory. MOUNTAIN SKIS $500 7pcs MOTOBIKE $600 2pcs SKATEBOARD $300 5pcs SNOWBOARD $360 7pcs Update two first records to FIBERGLASS MOUNTAIN SKIS $650 YAMAHA SPORTS BIKE $6000 (If you cannot update for any reason, alter table to make sure that you can do the updates) UPDATE INVENTORY SET DESCRIPTION="FIBERGLASS MOUNTAIN SKIS", PRICE=650 WHERE ID=1; Show the results. Show how to select All products that cost more than $1000 All products that have the word Yamaha or yAmaHa, etc. in their description.

I need help on part said update the data I get erro . Create a table as follows Inventory InvID number (10), Description varchar2(20), Price number(7,2), Quantity number(5,2) Add three constraints a) Primary key b) CHECK, price less or equal to $ 10000 c) description UNIQUE Enter the following data, assign inventory IDs as seems needed to you for your inventory. MOUNTAIN SKIS $500 7pcs MOTOBIKE $600 2pcs SKATEBOARD $300 5pcs SNOWBOARD $360 7pcs Update two first records to FIBERGLASS MOUNTAIN SKIS $650 YAMAHA SPORTS BIKE $6000 (If you cannot update for any reason, alter table to make sure that you can do the updates) UPDATE INVENTORY SET DESCRIPTION="FIBERGLASS MOUNTAIN SKIS", PRICE=650 WHERE ID=1; Show the results. Show how to select All products that cost more than $1000 All products that have the word Yamaha or yAmaHa, etc. in their description.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 40P
See similar textbooks
icon
Related questions
Question

I need help on part said update the data I get erro .

  • Create a table as follows

Inventory

InvID                      number (10),

Description         varchar2(20),

Price                      number(7,2),

Quantity              number(5,2)

               

               

  • Add three constraints a) Primary key b) CHECK, price less or equal to $ 10000 c) description UNIQUE

 

  •  Enter the following data, assign inventory IDs as seems needed to you for your inventory.

MOUNTAIN SKIS              $500       7pcs

MOTOBIKE                          $600       2pcs

SKATEBOARD                     $300       5pcs

SNOWBOARD                    $360       7pcs

  • Update two first records to

FIBERGLASS MOUNTAIN SKIS                    $650

YAMAHA SPORTS BIKE                                   $6000

(If you cannot update for any reason, alter table to make sure that you can do the updates)

UPDATE INVENTORY SET DESCRIPTION="FIBERGLASS MOUNTAIN SKIS", PRICE=650 WHERE ID=1;

Show the results.

  • Show how to select
  1. All products that cost more than $1000
  2. All products that have the word Yamaha or yAmaHa, etc. in their description.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS