Multiple choice technology databases

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 - One or Many Manufacturer - One or Many

  3. Product - Many Manufacturer - One

  4. Product - One Manufacturer - One

  5. Product - One Manufacturer - Many

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Product table has a foreign key (Manufacturer ID) referencing the Manufacturer table's primary key. One manufacturer can produce many products (1:M from manufacturer's side), and each product belongs to exactly one manufacturer. This is a classic one-to-many relationship where the 'many' side is the Product table. Option A describes M:M, D describes 1:1, and E reverses the relationship.