Multiple choice technology architecture

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

The parent entity Company has three child entities: Employee, Product, and Order. In a relational model, each child entity must contain the parent's primary key as a foreign key to establish the relationship. Therefore company_id appears once in each of the three child entities, totaling three appearances in the model.

Keep practicing — related questions