Q & A DB tables design

[Jan Il]

Hi all -

I am putting together a database to enter my reference library for program
and OS problems and solutions for same, and the updates that I have already
installed and what for. These include answers and information I have
received from this and several other newsgroups and forums.

I've created some tables, but I am not sure if they are correct. I would
very much appreciate it if someone would advise me if I have them correct.

tblSubectAnswers:
SubjectID
SubjectName
Program
ProblemType
Answser

tblArticles:
QID - PK
QNo
QTitle
AppliesTo
ProblemType

tblUpdates:
UpdateID - PK
UpdateNo
UpdateTitle
OSVersions
InstallDate

I would truly appreciate any suggestions for necessary additions or changes.

Jan

 

[Brian Kastel]

Some suggestions:

Split subjects from answers: one subject may have more than one solution.
Add a lookup table for ProblemType
Create a table for Programs Versions
Create a table for OS Versions