SunQuest
 
           Database Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesDatabase Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old November 7th, 2007, 06:00 PM
crowma crowma is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2007
Posts: 1 crowma User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 6 sec
Reputation Power: 0
Database Design Question

Hi,
I've been tasked with coming up with a project/time tracking system. A technician can be assigned a task to perform and upon completion of the task the technician enters the date, amount of time it took to complete and a description of the work done. Also, the system must be able to accomodate a higher lever "project". Time can be associated directly to a project or a project can contain any number of tasks, each with its own time entry. A task can only have one project parent, though. A project can have many child tasks.

I'm sure this is an elementary excersise for many of you but I'm fairly new to database design and want to get started in the right direction.

I'm looking for a clean database schema that can accomodate these data requirements.

Any help would be greatly appreciated.

Thanks,
crowma

Reply With Quote
  #2  
Old November 8th, 2007, 04:45 AM
Humanetainit's Avatar
Humanetainit Humanetainit is offline
Beyond help
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2007
Location: The Netherlands
Posts: 223 Humanetainit User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 1 h 32 m 30 sec
Reputation Power: 2
Take a look at the schema of TaskFreak for ideas.

Maybe a good idea to include the functionality of Time Tracker too?
__________________
One World... Humanetainit | Program secure

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesDatabase Development > Database Design Question


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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 On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway