Suggestions for Improvement

[Steve R.]

Attached is a screen shot of my science fiction book database. The category books consists of three tables. On table "SFBOOKS" lists all novels. The table "COMPILATION" is a book that consists of numerous stories all by one author. The table "ANTHOLOGY" is a book that has stories where the story author is different.

The magazine category also consists of three tables. "MAGAZINELIST" is a drop down list for the table "MAGAZINE", which holds all the information for a particular magazine. For example Galaxy, June 1970 issue. The table "MAGSTORY" holds all the magazine stories and is keyed to a specific issued by the field "ISSUEID".

PS: I am missing a table for the cover artist. That will be added later. Also as currently configured, I have multiple entries for stories, such as Asimov's "Nightfall", I have not yet made up my mind on solving this issue yet.

 

[KenHigg]

Your image is too small to read the text...

 

[namliam]

For one thing I would not make different tables for different kind of books/stories/etc.
Just add a column which has the type in it. Saves a lot of headache.

 

[Steve R.]

Thought so. Sorry about that. I will try again. I knew I should have done it at home where I have a "real" photo editing capability.
---------------------
New Image Uploaded on first post.