Click here to Skip to main content
15,913,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: Thanks Alexandre Pin
IrishSonic12-Feb-03 10:16
IrishSonic12-Feb-03 10:16 
GeneralDatabase Design Pin
Mark Sanders10-Feb-03 11:52
Mark Sanders10-Feb-03 11:52 
GeneralRe: Database Design Pin
Mike Nordell10-Feb-03 12:42
Mike Nordell10-Feb-03 12:42 
GeneralRe: Database Design Pin
Mark Sanders11-Feb-03 4:19
Mark Sanders11-Feb-03 4:19 
GeneralRe: Database Design Pin
Mike Nordell11-Feb-03 6:09
Mike Nordell11-Feb-03 6:09 
GeneralRe: Database Design Pin
Mark Sanders11-Feb-03 8:57
Mark Sanders11-Feb-03 8:57 
GeneralRe: Database Design Pin
Jason McBurney10-Feb-03 13:02
Jason McBurney10-Feb-03 13:02 
GeneralRe: Database Design Pin
perlmunger11-Feb-03 18:39
perlmunger11-Feb-03 18:39 
I think you would get different answers from different people. My personal tack on it is to keep all book data in a single table. Then you let your stored procedures or business rules layer handle figuring things out.

I would just create one table for all books and then create a second table that contained the book id and its download count. Every book won't have a download count, but that's ok. You let your app or stored proc figure that out. You could even keep a lookup of book types and a table of book IDs with their book type. Just do a join on the two tables to get all books of that type. That type will tell your app whether you should do a download count look up. This way, if you ever added a new book type, you don't have to add a new specific book table just to accomodate one or two new parameters. You already have one that suits your needs. You just create new tables with the book ID as the lookup mechanism.

This is just one guy's opinion on this. Take it or leave it. Wink | ;-)

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
Questionwhat's wrong with this simple SQL statement? Pin
devvvy10-Feb-03 2:39
devvvy10-Feb-03 2:39 
AnswerRe: what's wrong with this simple SQL statement? Pin
Mazdak10-Feb-03 4:16
Mazdak10-Feb-03 4:16 
GeneralRe: what's wrong with this simple SQL statement? Pin
devvvy10-Feb-03 10:50
devvvy10-Feb-03 10:50 
AnswerRe: what's wrong with this simple SQL statement? Pin
Chris Meech10-Feb-03 4:34
Chris Meech10-Feb-03 4:34 
GeneralRe: what's wrong with this simple SQL statement? Pin
devvvy10-Feb-03 10:52
devvvy10-Feb-03 10:52 
AnswerRe: what's wrong with this simple SQL statement? Pin
Julio Martínez10-Feb-03 5:46
Julio Martínez10-Feb-03 5:46 
AnswerRe: what's wrong with this simple SQL statement? Pin
Bruce Duncan10-Feb-03 6:48
Bruce Duncan10-Feb-03 6:48 
GeneralRe: what's wrong with this simple SQL statement? Pin
devvvy10-Feb-03 11:17
devvvy10-Feb-03 11:17 
GeneralRe: what's wrong with this simple SQL statement? Pin
Bruce Duncan11-Feb-03 7:30
Bruce Duncan11-Feb-03 7:30 
GeneralRe: what's wrong with this simple SQL statement? Pin
devvvy11-Feb-03 15:30
devvvy11-Feb-03 15:30 
GeneralQuery From Column Name Pin
Mazdak9-Feb-03 23:33
Mazdak9-Feb-03 23:33 
GeneralRe: Query From Column Name Pin
karl_w10-Feb-03 6:27
karl_w10-Feb-03 6:27 
GeneralKeeping Database Connection Open Pin
ChrisDM9-Feb-03 2:21
ChrisDM9-Feb-03 2:21 
GeneralProblem with running stored procedure Pin
Mazdak8-Feb-03 1:41
Mazdak8-Feb-03 1:41 
QuestionWhat is wrong with these SQL statements?? Pin
IrishSonic8-Feb-03 0:37
IrishSonic8-Feb-03 0:37 
AnswerRe: What is wrong with these SQL statements?? Pin
Mazdak8-Feb-03 2:51
Mazdak8-Feb-03 2:51 
GeneralRe: What is wrong with these SQL statements?? Pin
karl_w8-Feb-03 3:01
karl_w8-Feb-03 3:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.