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 will be based on the following database structure: Item Table Description Item Number Supplier Code On Hand Cost Selling Price Ball Cap 3663 30 $11.15 $18.95 50 $0.95 $1.50 $2.50 $4.75 $3.95 $6.95 $21.45 $26.75 LG Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 5923 6189 Note Cube 6343 Tee Shirt 7810 7930 TN LG LG AC TN TN ?? LG 24 12 18 Jersey Koozies 35 $%2.00 $3.50 $5.75 $8.00 32 $%9.50 $14.95 19 $%11.95 $17.00 Visor Supplier Table Supplier Code Supplier name AC LG PC TN Telephone Ace Clothes 616-555-9243 Logo Goods 517-555-3946 Photo Connection 416-555-8661 Thomas Novelties 317-555-4885 If a one-to-many relationship is established between the tables and referential integrity is enforced with both Cascade options selected, what will happen if you attempt to delete Supplier Photo Connection from the Supplier table? Photo Connection will be deleted from the Supplier table with no changes to the Item table

Explanation / Answer

Answer 1:

as cascading option is enabled if you delete anything in the parent table than the corresponding record in the child class will be deleted automatically where the supplier code is used

so here if you delete Photo connection from the supplier table it will delete from the supplier table and it looks for the records in Item table where PC is used, here we did't use so nothing will change it Itemtable

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---