Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The tables shown below contain a very small sample of the data kept in the database. The DML written must work on the complete
The tables shown below contain a very small sample of the data kept in the database. The DML written must work on the complete database table and not only the sample data given. The Chocolate Hamper Database The following database contains information about hampers that are sold to the general public. Each hamper has a Hamper Type and contains a variety of Items of chocolate. The hampers are normally purchased as gifts and are attractively wrapped in cellophane with a bow. Hampers (HamperType, Sale Price, NumInStock) HamperType Easter Feast Milk Christmas Time HamperType Contents (HamperType, Item, HowMany) Easter Feast Easter Feast Easter Feast Milk SalePrice Milk 50 40 100 Item Milk Chocolate Barrel Dark Chocolate Egg Milk Chocolate Rabbit Mega Chocolate Bar Milk Chocolate Barrel NumInStock 40 25 0 How Many 1 3 4 2 1 Permanently remove all records from the Hampers table that have no Items loaded in the Contents table.
Step by Step Solution
★★★★★
3.31 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
To Permanently remove records from table Hampers we can use the DELETE keyword wi...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started