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 Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 5923 6189 Note Cube 6343 Tee Shirt 7810 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 18 $21.45 $26.75 35 $%2.00 $3.50 $5.75 $8.00 32 $9.50 $%14.95 19 $11.95 $17.00 24 Jersey Koozies Visor 7930 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 TN If a one-to-many relationship is established between the tables and referential integrity is enforced

Explanation / Answer

Answer: option 1

Kandy Kitchen will be added to the Supplier table with no changes to Item Table

Since there are no constraints and supplier will have the primary key, so a new supplier record can be added. Where as to add to Item table, a supplier should be existing in Supplier table because since Item table refrences Supplier table

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---