• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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).
0
wademi
Asked:
wademi
1 Solution
 
Ephraim WangoyaCommented:

Normalization
You need three tables

Table1 : Books
BookID  PK
BookTitle
ISBN
.....

Table2: Region
RegionID   PK
RegionTitle
.....

Table3: BookRegion
ID  PK
BookID
RegionID
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now