如何使用多个表而不是获取重复数据？ （MySQL的/ PDO）

I am trying to create a firearms site that will house about 1000 guns. This is not a lot of database entries, but I am trying to keep the database light as possible. I have created five tables, keeping normalization in mind, and I'm having problems putting data into all five tables in one query. My database is structured like so:I am trying to create a firearms site that will