Help ME FIX MY conceptual entity relationship diagram (ERD).

We are very much a customer focussed company. A Customer makes an Order for one or more Bikes. A Customer over the years may make many Orders and each Order is associated with a single Customer.

Each Order may be for one or several Bikes, because each Bike is individually hand assembled and hand painted they are all unique so each individual Bike is associated with exactly one Order.

Although they are hand built they are built from industry standard parts. Each Bike consists of 3 main component sets: A Drivetrain (Crankset, Pedals. Cassette, Shifters and Brakes) . A Wheelset (Front and Rear wheels) and a Frameset (Frame, Bottom Bracket, Seat post, Saddle, forks, headset and bars.)

A particular Drivetrain such as Shimano Dura-Ace Di2 will be used in many Bikes, but each Bike of course just has one Drivetrain. Drivetrains are supplied by specialist Drivetrain_Suppliers. Each Drivetrain_Supplier may supply us with many Drivetrains but each Drivetrain has just one Drivetrain_Supplier.

A specific Frameset such as the Ritte Snob will be used in many Bikes, but each Bike of course just has one Frameset. Frameset are supplied by specialist Frameset_Suppliers. Each Frameset_Supplier may supply us with many Framesets but each Frameset has just one Frameset_Supplier.

A specific Wheelset such as the Campagnolo Bora WTO 33 will be used in many Bikes, but each Bike of course just has one Wheelset. Wheelsets are supplied by specialist Wheelset_Suppliers. Each Wheelset_Supplier may supply us with many Wheelsets but each Wheelset has just one Wheelset_Supplier.

Bikes as mentioned earlier are hand built by a team of highly skilled Builders. It may take several Builders to build a single Bike and of course each Builder will build many Bikes.

Painting is a different matter each Bike is assigned to a single Painter based on the complexity of the design , only Terry can do the "Wreck of the Hesperus" with any deal of skill. A good Painter might complete 10 moderately complex paint jobs per month.

Of course we are a business so the vulgar topic of monies needs to be addresse. When an Order is placed it generates an Invoice, each Order creates just one Invoice and each invoice refers to just one Order. The Customer receives the Invoice. A Customer who makes many Orders will naturally receive many Invoices and each invoice is sent to the Customer who made the Order.

Invoices need Payment. Since the Bikes are quite pricey we allow Customers to pay invoices in installments , so each Invoice might have multiple Payments but each Payment is associated with just one Invoice.

Customers make Payments, as Customers may receive many Invoices they may make many Payments but each Payment comes from a single Customer.

\begin{tabular}{|l|l|l|l|} \hline Customer & \multicolumn{1}{|l|}{ relationship } & \multicolumn{2}{|l|}{ Order } \\ \cline { 1 - 1 } Customer ID & 1.1 & 1. & OrderNo \\ \hline \end{tabular} \begin{tabular}{|l|} \hline Bikes \\ \hline BikenO \\ \hline \end{tabular} \begin{tabular}{|l|} \hline Builders \\ \hline BuildelD \\ \hline \end{tabular} \begin{tabular}{|l|} \hline Drivetrain \\ \hline Pkey \\ \hline \end{tabular} \begin{tabular}{|l|} \hline Wheelset \\ \hline Pkey \\ \hline \end{tabular} \begin{tabular}{|l|} \hline Frameset \\ \hline Pkey \\ \hline \end{tabular}