Assume that your town is home to a minor league baseball team. There is a team s
ID: 3911733 • 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 Item Number Supplier Code On Hand Cost Description Ball Cap Selling Price 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 24 12 18 35 $0.95 $1.50 $2.50 $4.75 $3.95 $6.95 $21.45 $26.75 $2.00 $3.50 $5.75 $8.00 Jersey Koozies 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 no Cascade options selected, what will happen if you attempt to change the Supplier Code for Supplier Ace Clothes to AA?Explanation / Answer
Answer 1: C
as Supplier code is the primary key for the SupplierCode table it will not allow use to change the Supplier Code