Assume that your town is home to a minor league baseball team. There is a team s
ID: 3911720 • Letter: A
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 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 35 $2.50 $4.75 $3.95 $6.95 $21.45 $26.75 $2.00 $3.50 $5.75 $8.00 $9.50 $14.95 Jersey Koozies 32 Visor 19 $%11.95 $17.00 Supplier Table Supplier Code Supplier name AC LG PC TN Telephone Ace Clothes Logo Goods 517-555-3946 Photo Connection 416-555-8661 Thomas Novelties 317-555-4885 616-555-9243 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 add item Team Flag to the Item table that comes from supplier SN?Explanation / Answer
The correct option is
option 1
As cascade option is not selected the changes in the item teble wil have
no impact on the supplier table.