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

Explanation / Answer

For item table, primary key should be Item Number as a primary key of a table is a field which uniquely identify record, must have unique values and should not have NULL values. In Item table Item Number has unique values.

Second option is correct

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---