Database schema help
Posted on 2011-02-24
How do you design the database schema for Books and Region using the following scenario?
I am confused because 1 book can belong to many regions.
Certain books wont be available in some regions. I want each record in the book table to be unique.
We are currently building an ebook store with 1.2 million titles, each of which is identified by ISBN. We store a plethora of information we’d like to collect, including author, title, copyright year, publisher, language, price, and geographic region(s) to which the books are allowed be distributed (for instance: China has strict censorship laws).