Multiple choice technology databases

A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?

  1. computer_id

  2. product_id

  3. company_id

  4. employee_id

  5. order_id
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In this hierarchical model, Company is the parent entity with three child entities (Employee, Product, Order). Each child entity must reference its parent through a foreign key, which is company_id. Therefore, company_id appears exactly three times in the model - once in each child entity. Other keys like computer_id, employee_id, and order_id are local keys or appear fewer times.

Keep practicing — related questions