You create Web-based client applications.
You are designing a database that must meet the following requirements:
Store data about people in the People table and data about the companies they work for in the Companies table.
Track an unlimited number of companies for a person.
Track an unlimited number of persons who worked at each company. You decide to create a one-to-many link from the People table to the Companies table. You need to evaluate whether the database is designed effectively and make a recommendation, if required. What should you recommend?
A.
The database is not correctly designed according to the requirements. You must create a many-to-many link between the People table and the Companies table by using an intersection table.
B.
The database is not correctly designed according to the requirements. You must create a many-to-many link directly between the People table and the Companies table.
C.
The database is not correctly designed according to the requirements. You must create a one-to-many link from the People table to the Companies table. Create another one-to-many link from the Companies table to the People table. Add columns to the People table and the Companies table to accommodate multiple child rows.
D.
The database is correctly designed according to the requirements. No changes are required.