I am building a gun inventory database for a friend. He needs to have information such as , gun price, sale price, manuf, caliber, serial number, model, so forth.
My question is; would it be better to have severa different tables? I. E.
Table 1
Manufacturers
Table 2
Models
Table 3
SalePrice...