Member Avatar for scratchwiz

Hi all,

I have to develop Library Management System using Java and MSSQL and I/m currntley in designning phase.

Now my prblem is this,

When user add to New Book to the DB, it stores with a qnuiqe Bookid which is going to be auto generated.
But if there are more than one copy of a new book what is the method should I use?
As a example if Book A has 3 copies i want to save them under 3 different qnique ids. Because Bookid is unique only for a one copy.
Anu sugeestions for this DB design.
Any reply will be warmly welcomed. :)

  • 2 Contributors
  • 1 Reply
  • 140 Views
  • 10 Minutes Discussion Span
  • Latest Post Latest Post by urtrivedi
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.