Quote:

Originally Posted by Magian I am requesting critiques of a ERD that I have created

Random points:

• As mentioned above there are no primary keys or foreign keys - these are essential.
• for us to understand your design.
• All the 1:1 relationships between the tables are almost certainly wrong ie
• Surely a customer could have many invoices but your schema indicates just one?
• Location and Insurance tables hold people in the Contact table - could you move the drivers in here as well?
• Can a driver really only drive one truck?
• Should the Insurance fields be inside the truck (or driver) tables?
• What's a FOB??