Included are two ERDs. ERD1 is an idea I just recently had, I am wondering if this would work, or would ERD2 be the only correct way? And, should any of the one-to-one relationships be added into the product table? Some of the entities are simplified. Have a nice day! These neat diagram are made easily at: https://app.diagrams.net