Question

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. True or false?

Answer 1

Answer:

False

Explanation:

Creating multiple records for each employee on different projects and different managers would not make the database normalized.

But, we can create foreign keys for different projects and mangers, and assign to each employee.

The list of projects can be created on another table and linked to each employee via the foreign key.