Jump to content

Database for Tasks System


FlyingIsFun1217

Recommended Posts

Hey everyone! Long time no see ;)

 

Anyway, my current task involves designing a system to track tasks assigned by leaders of a team, to members of the team. Currently, I've got a system to log users in (that wasn't a problem at all), but what I need help with is the design for an unlimited amount of tasks.

 

Essentially, I'd like each user to be able to have multiple tasks, each holding some info (such as status, assignee, assigner, original date, etc.). What I'm not sure on, is how to set up the database to handle such problems. I want to keep all tables for the system in one database, including the table I have for users.

 

Should I keep one huge table for each task? Have each task be a table? If I had each table be a task, how would I know which tasks were for which users (assuming that I have a HUGE amount of tasks, and a huge number of users)?

 

Thanks for the help on this! I really appreciate it!

 

FlyingsFun1217

Link to comment
Share on other sites

Reading up on proper normalization will answer a lot of your questions.

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

 

Things to consider are: what if a task is reassigned.. what if multiple people are leaders of the same task.

 

Having tables in the same database isn't a problem..  After you read you will start to understand how you should separate your tables, and what data should go in where.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.