Multiple choice technology web technology

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 relationship is Many-to-One from Product to Manufacturer. Each Product has exactly one Manufacturer (foreign key Manufacturer_ID in Product table references Manufacturer_ID in Manufacturer table). However, one Manufacturer can produce many Products (multiple Product records can reference the same Manufacturer_ID). This is not Many-to-Many (no junction table), not One-to-One (Manufacturer_ID isn't unique in Product), and not One-to-Many from Product (each Product doesn't have multiple Manufacturers).