Which plan should you recommend?

You are designing a SharePoint 2010 application that stores information about each machine in a factory. This
information includes an inventory of parts, the machines 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?

A.
Create tables in Microsoft SQL Server for each set of inventories. Create relationships with primary and foreign keys linking the tables.
Use Business Connectivity Services (BCS) to connect SharePoint 2010 lists to these tables to manage the data.

B.
Create tables in Microsoft SQL Server for each set of inventories.
Create relationships with primary and foreign keys linking the tables.
Store machine part manuals in a SharePoint document library and use event receivers to synchronize data in the lists and libraries.

C.
Use SharePoint 2010 lists and document libraries to store data.
Create relationships using lookup fields and relationship joins between the lists and document libraries.

D.
Use SharePoint 2010 lists and document libraries to store data.
Create a custom workflow to update information in the lists and document libraries.