Re: DB structure - Managing a collection of books
Posted by:
Rick James
Date: December 02, 2011 09:19PM
Sounds good. You have identified several "Entities", each of which is a table:
book
person
author (yes, this is optional -- do you have anything other than "name"?)
personal collection
wish list
Then look for "Relationships" (FOREIGN KEYS). personal_collection and wish_list will have a person_id and a book_id. These provide "many to many" relationships between persons and lists. Perhaps you could combine those two lists and have a flag saying which kind each row is. (It will probably become obvious later if you should not do that.)
Subject
Written By
Posted
November 21, 2011 04:24PM
November 22, 2011 12:52PM
Re: DB structure - Managing a collection of books
December 02, 2011 09:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.