The tables shown below contain a very small sample of the data kept in the database....

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

To Permanently remove records from table Hampers we can use the DELETE keyword wi... View the full answer