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 01/09/2014 02:08:33
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 01/09/2014 :  04:59:58  Show Profile  Reply with Quote
quote:
Originally posted by Quentin

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


I think you can use approach like this
Have reference tables to store STaff,Roster, Duty etc
Then have a table which relates all these to indicate the type of duty for a roster assigned to an employee with period (start and enddates) for the roster
ie fields as StaffID<RosterID,DutyID,StartDAte,ENdDate with all IDs joining to respective master tables via foreign key constraints

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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