SQL Tables

r p

In my Job Site, I have three forms like

1. IndustryDetails.aspx - this is the preferred industry which the person wants to work(drodownlist)
2. Location.aspx - only one location is allowed/cv; no multiple location.
3. Skills.aspx - this gives a text box to enter the skills

Should I make 3 DIFFERENT TABLES and insert data seperately (May be I can create a talbe called 'Account' and make a primary
key which can be used in all thesee 3 tables as a foreign key - it will be a unique key) or should I create only ONE TABLE
(In that case how can I insert data from different forms)?
Could you plese let me know your openion?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Accepted answer
Hi,

No Just have only one table to store all these data all thes 3 are related to each other.

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com
r p18y ago
I have industry table which passes industry id, location table which passes location id. Now, when I want to insert data entered by the job seeker, I HAVE 3 FORMS - Industrydetails.aspx (where the user will enter the preferred industry he wants to work from a drop downlist), Location.aspx (user chooses a location from the dropddown list) and skills where the user enters the skills in a text box. Now, these forms are connected to three different MENU on top. If I am using only one form I can create a table called 'jobprofile' and insert. But, since I am using 3 forms should I create 3 tables to insert data?
Vijaya Kadiyala18y ago
Hi,

Dont design the tables based on the forms. tell us what information you want to store and a brief descrption about those attribute then we can guide you in designing the tables. remember the whole system peformance can go down if you dont have good database design.

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com