Assume that your town is home to a minor league baseball team. There is a team s

Question

Assume that your town is home to a minor league baseball team. There is a team store that sells a variety of items and team memorabilia. You decide to create a relational database that will store some of the inventory information. Your database ill be based on the following database structure: tem Table Item Number Supplier Code On Hand Cost Description Selling Price Ball Cap 3663 Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 5923 6189 Note Cube 6343 Tee Shirt 7810 7930 LG TN LG LG AC TN TN AC LG 30 $11.15 $18.95 50 $0.95 $1.50 24 12 18 $21.45 $26.75 35 7 32 19 $11.95 $17.00 $2.50 $4.75 $3.95 $6.95 Jersey Koozies $2.00 $3.50 $5.75 $8.00 $9.50 $14.95 Visor Supplier Table Supplier Code Supplier name AC LG PC TN Telephone Ace Clothes 616-555-9243 Logo Goods Photo Connection 416-555-8661 Thomas Novelties 317-555-4885 517-555-3946

Explanation / Answer

Answer 2:

The Supplier logo goods will be deleted from the Supplier table and changes will be made to the item table as we are using LG in the item table so all the records where we used the LG in the Item table will be deleted

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---