We should have added this sooner. The good news is that we can base it on previous examples that were provided in our class.
More than likely this will apply to books more than authors.
books can be divided up into Category (e.g. Fiction, Horror, Romance, Non-Fiction, Biographies, etc.) There would likely be multiple categories assigned.
books can be divided up into Subject (e.g. "Mathematics", "Architecture", etc.)
books can be divided up into Tags (e.g. "clowns", "monsters", etc.)
Now that I think about it, I'm glad I added the loc (Library of Congress ID number) and dewey (Dewey Decimal ID number) fields to the book table.
We could probably just simply this by just having a Tag system that covers Category, Subject, and Tags.
We should have added this sooner. The good news is that we can base it on previous examples that were provided in our class.
More than likely this will apply to
book
s more thanauthor
s.book
s can be divided up into Category (e.g. Fiction, Horror, Romance, Non-Fiction, Biographies, etc.) There would likely be multiple categories assigned.book
s can be divided up into Subject (e.g. "Mathematics", "Architecture", etc.)book
s can be divided up into Tags (e.g. "clowns", "monsters", etc.)Now that I think about it, I'm glad I added the
loc
(Library of Congress ID number) anddewey
(Dewey Decimal ID number) fields to thebook
table.We could probably just simply this by just having a Tag system that covers Category, Subject, and Tags.