SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Staff Duty Roster		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Quentin
Starting Member

Australia
12 Posts
Posted - 02/14/2013 :  18:58:54  Show Profile  Reply with Quote
I am looking at transferring our current spreadsheet roster to a database. There are 5 parts to the data.

Staff Details - Firstname, Surname, staffid etc
Roster Details - rostertype (Onsite,R&R, Annual Leave ect)
Duty Details - each 3 months a persons duties are changed in a rotating system (Duties like Cleaning, Cooking, Maintenance etc)

I would like the output to be based on a date range so I need to assign each Day a roster type for each staff member, then a duty type for that date as well.

Is the best option top have a table for each detail (Staff, Roster, Duty) which includes a date range for each particular item and then a view central table for Date, Staffid, RosterType, DutyType).

Or is there a better way?

Thanks

markspend1
Starting Member

Australia
5 Posts
Posted - 02/18/2013 :  14:22:11  Show Profile  Reply with Quote
Hey Guys i think that the term of duty roster is an business unit that determines what and when people in a group need to do.Such company is important in a group process or objective because it guarantees that all necessary responsibilities are finished. It also allows affiliates to see that others have been allocated duties, so they do not think that they are the only ones doing the perform.Thanks in advance!!
Edited by - markspend1 on 02/18/2013 14:22:29
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000