ROCKINDANO Posted January 14, 2009 Share Posted January 14, 2009 Hello all, i am working on a project for job postings. right now i have my table structure with two tables. i have one table for the title, pay rate, job number, closing date and then i have another table for the description of the job as job summary, equipment and materials, condition of work enviornment, example of work, and education required. my question is would it be neccassary to have two tables or can i have all these info in one table? anyone??? Please help Quote Link to comment Share on other sites More sharing options...
rhodesa Posted January 14, 2009 Share Posted January 14, 2009 you could have them as one table Quote Link to comment Share on other sites More sharing options...
ROCKINDANO Posted January 14, 2009 Author Share Posted January 14, 2009 would it make a difference if they were all in one table hence having two tables. as far as performance etc... Quote Link to comment Share on other sites More sharing options...
rhodesa Posted January 14, 2009 Share Posted January 14, 2009 if you were running LOTS of queries on just a few fields, it might make sense to have those fields in a separate table. the other time it makes sense is if a bunch of the fields are always used. for instance, if you have a USERS table. and the admins in that table have a few fields for admin info. it would make sense to have the admin info in a separate table, otherwise you have tons of NULL values that are just taking up space Quote Link to comment Share on other sites More sharing options...
ROCKINDANO Posted January 14, 2009 Author Share Posted January 14, 2009 thanks makes sense. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.