The image below is my ham-fisted attempt to design a database of cabinets. I'm new to this and this is simply an exercise to help me understand database structure.
My goal is not to create an inventory/order database that relates to client purchases. I want to create a database that would allow me to populate products based on style, material, joinery, or etc... In other words, if a customer visits the website and selects to view cabinets of a certain category then all the cabinets associated with that category will populate in an array. It will display an image and beneath that a title. For example:
From what I've researched attributes should define the columns of the table, but many of the cabinets have multivalued attributes. I'm starting to believe I've overcomplicated the design. I added a few text blocks to hopefully clarify the purpose of the table. Can someone with experience provide some constructive feedback? Thanks!