Multiple choice technology architecture

PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?

  1. Product - Many Manufacturer - Many

  2. Product - Many Manufacturer - One

  3. Product - One Manufacturer - One

  4. Product - One Manufacturer – Many
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Product table contains Manufacturer ID as a foreign key, indicating each product is associated with one manufacturer. The Manufacturer table has Manufacturer ID as primary key. Since many products can reference the same manufacturer ID, this is a Many-to-One relationship: many Products to one Manufacturer.

Keep practicing — related questions