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: tem Table Item Number Supplier Code On Hand Cost Description Selling Price Ball Cap3663 Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 5923 6189 Note Cube 6343 Tee Shirt 7810 7930 LG TN LG LG AC 30 $11.15 $18.95 50 $0.95 $1.50 24 12 $3.95 $6.95 18 35 $2.50 $4.75 Jersey $21.45 $26.75 $2.00 $3.50 Koozies TN AC LG $5.75 $8.00 32 $9.50 $14.95 19 $11.95 $17.00 Visor Supplier Table Supplier Code Supplier name AC Telephone Ace Clothes 616-555-9243 Logo Goods 517-555-3946 Photo Connection 416-555-8661 Thomas Novelties 317-555-4885 PC 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 change the Supplier Code for Supplier Ace Clothes to AA? Supplier Code will change for Ace Clothes in Supplier table with no changes to the Item table

Explanation / Answer

The correct option is

option 2

As reeferential entity is enforced the chanege in supplier table must
be updated in the item table.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---