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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |