I was told in a previous question that my table structure was incorrect and that I should use BCNF or 4NF. What is BCNF and 4NF? My DB is used as a study program. I have several tables which each contain a ID field, a Question Field and a Answer Field. I used seperate tables because I have many different subjects to study from and did not want to mix up questions. I created a query for each table and a form for each query. With all the tables, queries and forms my database has begun to slow down. Is there a better way to structure my tables?

Adan

Burlinga,

Whats your table structure like? Is it normalized as best as possible?
Since you didn't mention what topic your application is dealing with, I'd suggest taking a look at these
data models:

Data Models....

Good luck,

Aqua

Take a look at Understanding Normalization

I would strongly recommend not having separate tables per subject. Have a Subject field in a single table.

Hi

BCNF = Boyce Codd Normal Format (usually refered to as 3NF) and 4NF is fourth normal format. Generally, provided your db meets 3NF criteria you'll be in very good shape. Here's some links to help you understand normalisation.......

• Database planning tutorial Part I
• Database planning tutorial Part II
• argeedblu's FAQ on Design Strategies
• Noah's FAQ on Normalization
• Jerry's FAQ on Normalization
• GroverParkGeorge's PDF on Normalization
• Jerry’s FAQ on Fully Qualified Naming
• Jerry's FAQ on Glossary
• Danny's FAQ on Reserved Words
• Autonumbers - What They Are / Are Not
• Primary Keys - Natural vs Surrogate
• Naming Conventions - Hungarian Notation
• Crystal's ACCESS Basics for Programming
• Database Answers (free models)
• MSKB 283878: Description of the database normalization basics

Good luck and please post back if you have any questions

Only to reinforce what's been said: You don't want questions in different tables. They should all be in the same table as Doug described.

So if I put all the questions in one table and make a field for the subject.....how would I filter the subject field using only one form? Should I have more than one form? Should I use a filter or Dlookup or FindRecord Method? Would a query by form work to pull data from a subject field? Just trying to understand this and get the most out of my DB so it will run smoothly. thanks for all the help

Adan