Databases are huge overkill for a game that's not an MMO.
You should probably have a class hierarchy for items, like maybe a CItem class and a CWeapon class that derives from CItem; then maybe CMeleeWeapon and CRangedWeapon would be subclasses of CWeapon. These classes would have various methods allowing them to be picked up, dropped, etc. and properties indicating weight, damage, etc.
Then you could have a CCharacter class, and as a field in that, have an array of (references to) CItems representing the character's inventory. You could also have a field holding a reference to the currently wielded weapon on the left hand, and another for the right hand. A method on CCharacter would exist to equip a CWeapon from the inventory, which would check which hand(s) it is for and set the references appropriately.