In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Question

Quizplus · Accepted Answer

The best approach would be to use a relational database model where the employee information is stored once, and relationships to projects and managers are managed through foreign keys or linking tables, avoiding duplication of employee records.

In an Organization, Each Employee Might Work for One or More