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 decidé 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 Item Number Supplier Code On Hand Cost Description Ball Cap 3663 Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 Jersey Koozies Note Cube 6343 Tee Shirt7810 Visor Selling Price LG TN LG LG AC TN TN AC LG 30 $11.15 $18.95 50 $0.95 $1.50 $2.50 $4.75 12 $3.95 $6.95 $21.45 $26.75 35 $%2.00 $3.50 $5.75 $8.00 $9.50 $14.95 19 $%11.95 $17.00 24 5923 18 6189 32 7930 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 If a one-to-many relationship is established between the tables and referential integrity is enforced with neither Cascade option 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 onnection will be deleted from the ltem table with changes to the Item table

Explanation / Answer

Answer 1:

As your deleting from the table where cascading is not choosen than it will not impact anything on the child table,

Cascading means if we delete the parent class records than the corresponding child class records will be deleted automaticaly

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---