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

Question

Quizplus · Accepted Answer

Creating multiple records for the same employee can lead to data redundancy and inconsistency. Instead, a relational database design using tables with foreign keys and many-to-many relationships would be more efficient.

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