I am creating a lending library database and I am trying to figure how to deal with multiply copies of an asset. Let's say I have 2 copies of "How to stay positive." Is it easier to just have it listed in the data base twice with a second copy being "How to stay positive 2" or is there a way I could just have one entry in the assets table that can account for multiply copies?
I have though about added a copies column in my assets table and using that to determine if there a copy available or not. I just am not sure the direction to go with this. any ideas or a direction to go n would be helpful.