Assume that your town is home to a minor league baseball team. There is a team s
ID: 3911730 • 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 Selling Price Description Ball Cap 30 $%11.15 $18.95 50 $0.95 $1.50 $2.50 $4.75 $3.95 $6.95 $21.45 $26.75 LG 3663 Bumper Sticker 3783 Coffee Mug 4563 Foam Figure 4593 5923 6189 Note Cube 6343 Tee Shirt 7810 TN LG LG AC TN TN AC LG 24 12 18 Jersey 35 $2.00 $3.50 $5.75 $8.00 32 $9.50 $%14.95 19 $11.95 $17.00 Koozies Visor 7930 Supplier Table Telephone Supplier Code Supplier name AC LG PC TN 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, which table is the primary table and which table is the secondary table?Explanation / Answer
Answer: option 4 i.e. Supplier is the primary table and Item is the secondary table
In this one-to-many relation, a single supplier code is used as primary key in supplier table and being reference by multiple items in Item table. So Supplier table containing primary key is primary table and Item table is the secondary table