A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How many fields per table?



 
 
Thread Tools Display Modes
  #11  
Old April 18th, 2006, 06:31 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How many fields per table?

Looking at what you siad here I was hoping you can just clarify this for me:

I have a lot of areas that are just questions and answers (long text answers)
e.g:
Under Premises:
Describe the location of the business, the size of the premises are the
premises leased or owned

Can I use this
tbl_Questions
QuestionID (PK)
QuestionText (the question is placed in this field, it isn't a separate field)
Assuming that the QuestionText will be a set question that I will put in?
And then I will have a seperate answers table?

I am not that good with this yet but if you have any questions on PHP I can
help. I feel so stupid today.

Regards
Natasja

"mnature" wrote:

You just seem to keep creating spreadsheets.

To dissect this part of your table:

􀁹*Is the application in respect of
- a new business?
- an existing business?
- a franchise?
- a newly acquired business?


These are all fields? That is not how to normalize a database. To
normalize means something like this:

tbl_Questions
QuestionID (PK)
QuestionText (the question is placed in this field, it isn't a separate field)

Now, notice that the questions are completely separate from the answers.
That is what is meant by normalization. Next, you build a table that lists
the different people you ask these questions of. Then you build a table that
joins the questions, the people, and the answers.

tbl_People
PeopleID (PK)

tbl_Answers
AnswerID (PK)
QuestionID
PeopleID
AnswerText

Using this format, you can have hundreds or thousands of questions, because
your tables are normalized.

  #12  
Old April 18th, 2006, 08:08 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How many fields per table?

tbl_Questions
QuestionID (PK)
QuestionTypeID [use this to designate what kind of question it is, such as
premises]
QuestionText [the question is placed in this field]

QuestionTypes
QuestionTypeID (PK)
QuestionTypeText

tbl_People
PeopleID (PK)
PeopleName

tbl_Answers
AnswerID (PK)
QuestionID [ties back to a particular question]
PeopleID [ties back to a particular person]
AnswerMemo [Make this a memo field, and you will have lots of room for long
answers]

Under Premises:
Describe the location of the business, the size of the premises, are the
premises leased or owned


These are three different questions, each would belong to QuestionType :
Premises, and would relate to the People and Answers tables. Once you have
set up the questions, then you can have as many answers as you want, with any
particular answer always related to a particular person and question. You
could even have a date field in the answer table, and have the same question
asked several times over a period of time, to see how the answer changes.

The QuestionType field would allow you to sort the questions/answers
according to what they refer to.
  #13  
Old April 18th, 2006, 08:11 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How many fields per table?


MNATU
Looking at what you siad here I was hoping you can just clarify this for me:

I have a lot of areas that are just questions and answers (long text answers)
e.g:
Under Premises:
Describe the location of the business, the size of the premises are the
premises leased or owned

Can I use this
tbl_Questions
QuestionID (PK)
QuestionText (the question is placed in this field, it isn't a separate field)
Assuming that the QuestionText will be a set question that I will put in?
And then I will have a seperate answers table?



I am not that good with this yet but if you have any questions on PHP I can
help. I feel so stupid today.

Regards
Natasja

  #14  
Old April 19th, 2006, 05:51 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default How many fields per table?

=?Utf-8?B?QWNjZXNzIEFmcmljYQ==?=
wrote in :

if you have any questions on PHP I can
help.


Good MySQL design is exactly the same as good Access design... :-)


Tim F

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table problem Redwood Database Design 29 April 3rd, 2006 04:58 PM
Table design problem? Melissa Database Design 29 November 18th, 2005 05:14 AM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Complicated Databse w/many relationships Søren Database Design 7 July 13th, 2004 05:41 AM
COMPARE THE TWO TABLES Stefanie General Discussion 0 June 4th, 2004 04:36 PM


All times are GMT +1. The time now is 10:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.