wademi
asked on
Database schema help
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.
SCENARIO
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).
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.
SCENARIO
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).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.