Which of the Following Is the Best Approach While Handling

question 102

Multiple Choice

Which of the following is the best approach while handling complex relationships, such as the data for a company where employees can be assigned to more than one project and each project can have more than one employee assigned to it?

• A) create two or more records for the employee, each of which lists a different project
• B) include multiple project fields, such as project 1, project 2, and so on, for the employee
• C) normalize the relationship between "employees" records and "projects" records
• D) make the relationship between "employees" records and "projects" records hierarchically dependent

---

Definitions:

Sales Force Resources

Tools, materials, and support provided to a sales team to help them effectively perform their duties and achieve sales targets.

Fixed Cost

Expenses that do not change with the level of production or sales in the short term, such as rent, salaries, and insurance premiums.

Gross Profit

Money available to cover the costs of marketing the product, operating the business, and profit.

Merchandise

Goods or products that are purchased, sold, or traded, often in the context of retail.