DB Modeling 101 - best practice?

[scooby]

Say I have the following tables & scenario:

Books
Book_ID
Book_Title
Book_Price

Stores
Store_ID
Store_Name

Books_Stores
Book_ID
Store_ID

95% of the time, all stores will sell the book at the "list" price (Book_Price). However, there are some times when a store will sell the book at a different price.

Would I create something like a Books_Stores_Price field in Books_Stores that would contain every store's price (seems like I would be storing a lot of duplicative data)? Or is there some more elegant way to store just the exceptions, and ensure that on any given query that the default price in the Books table or the exception store price gets returned?

Thanks in advance!

[Ignorant]

your subject line was misleading.. I thought it was something like a FAQ or a tutorial

[skhanal]

Create a table for price exceptions only for the store.