title: mysql relationships in EER
body: <p>I'm trying to clarify some entity relationships here within my EER diagram that I made in MySQL. The end goal is to be able to have a few tables (fleet1, fleet2, fleet3) that are comprised of a unique certificate ID, but have multiple vendors and multiple vessels. In each fleet, the vendor can appear more than once, but each vessel only once. When everything is complete, I will connect this database to mail merge and be able to query data from each fleet.
  I think what I am confused on is how to link the tables. I've tried a one to many (creating a linking table which would be each fleet table), but I want each fleet table to comprise of all of the vendor information, and all of the fleet information so that when I do a mail merge, I see certificateid, all of vendor info, and all of vessel info. I'm guessing a linking table would suffice for this?</p>
  
  <p>Please see my attached EER. I would appreciate any advice and suggestions. Right now I think I am in 2NF, but I may be able to simplify further into 3NF?
  <a href="https://i.stack.imgur.com/ZwDtd.png" rel="nofollow noreferrer">diagram</a>
  <a href="https://i.stack.imgur.com/ZwDtd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZwDtd.png" alt="enter image description here"></a></p>