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.)

Options: ReplyQuote


Subject
Written By
Posted
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.