You are designing a SharePoint 2010 application that stores information about each machine in a factory. This information includes an inventory of parts, the machine's maintenance history, and a…

You are designing a SharePoint 2010 application that stores information about each machine in a factory. This information includes an inventory of parts, the machine's maintenance history, and a document library of repair manuals for each machine in Microsoft Word format. The application must:

• Establish links between the factory machine data, the machine part

inventory, the maintenance history, and the repair manuals to allow the display of additional fields from the other lists.

• Enforce relational integrity between the data to create custom views

for various business users.

• Allow nontechnical users to update the individual list data and

views, as well as to update the manuals.

• Enforce relationships that allow cascade deletes of items from the

machine parts list when items are deleted from the machine list, but prevent data in the machine parts list from being orphaned. You need to design a data access plan that meets all these requirements and allows all data to be managed within the SharePoint 2010 system. Which plan should you recommend?