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) 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.
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) 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.
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...
Related questions
![Q: [ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on…A: A relational database contains tables. Tables are also known as relations and they contain rows and…](/questions-and-answers/slide-15-.png-q1.-please-write-sql-codes-to-create-below-member-database-table-based-on-the-previous/3b4446fb-5348-4dbb-944d-a99326b9259f){kind=link}
Question
- 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)
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning