The following relational model represents an HRM system of a consultancy firm. The primary keys are underlined; foreign keys are in italic font.

Suppose a new consultant is hired and immediately assigned to a new training project at a new firm and to two other, already-existing projects. How many rows (tuples) must be added to the database to reflect this change?

a. 1.

b. 3.

c. 5.

d. 6.

Transcribed Image Text:

Consultant (ConsultantID, Date of Birth, Expertise) Assigned to (ConsultantID, ProjectID) ConsultantID refers to ConsultantID in Consultant; ProjectID refers to ProjectID in Project Project (ProjectID, Description, Type, Company) Company refers to Name in Company Company (Name, Location)