Solved

Database schema help

Posted on 2011-02-24
1
389 Views
Last Modified: 2012-05-11
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
Comment
Question by:wademi
1 Comment
 
LVL 32

Accepted Solution

by:
ewangoya earned 500 total points
ID: 34975856

Normalization
You need three tables

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

Table2: Region
RegionID   PK
RegionTitle
.....

Table3: BookRegion
ID  PK
BookID
RegionID
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question