As far as I understand this problem, you have created a hierarchical layout:
ROW -< SHELF -< BOOK (where -< stands for "one to many")
What you could do is: add another 1:m relationship (ie another FK) between ROW and BOOK.
I do not know what the actual user requirements for this database are...
I know there is an "official" StackExchange meta-post already concerning this question, however I think it would be suitable to have our own post that reflects our position.
This really excellent question has provoked a number of excellent answers, one of which was self-deleted after the OP req...
Seen on the interwebs today ... There are these two beautiful marble statues on either side of a big open piazza. For centuries they have stood frozen, starring longingly into each other's eyes. One day the gods look down upon them with pity and decide to grant them one hour of mortal life. The statues, overwhelmed with joy, rush across the square and into each others arms and immediately run off into a bush to fulfill their greatest desires. After about a half an hour of rustling around in the bushes they emerge, panting and sweaty. "Wow" says the one statue, "that was amazing" "A dream co…
As far as I understand this problem, you have created a hierarchical layout:
ROW -< SHELF -< BOOK (where -< stands for "one to many")
What you could do is: add another 1:m relationship (ie another FK) between ROW and BOOK.
I do not know what the actual user requirements for this database are...
