my question is about NF1 what is best practice to store book volumes in table .
for example mostly it is like bookname = abc volume= 1 ect but some time it is abc volume 1-2.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In my experience it's best to have the title in its current full form. That being said, I would have the volume in the title field as simply the volume, without stating how many volumes are in the series. "History of Rome volume 1"
If I put it in as "History of Rome volume 1-2" then if a third volume was added, I would have to update each title to account for the new number of volumes in the series.
A second approach could be adding a new field for the number of volumes in the series, which would list the total number. It would still have to be updated if a third volume was written, but is a smaller impact to update an integer field from 2 to 3, than to update the varchar field of the book title.