Home
Kimball Group Home
Search
Register
Log inApplicant availability model
Page 1 of 1
Applicant availability model
satishjayan Thu Dec 20, 2012 1:59 pm
During application process each applicant needs to provide availability information and below is the matrix that we present -
Mon Tue Wed Thu Fri Sat Sunday
Early Morning x
Mid day x x
Afternoon x
Evening
Overnight x x
I'm designing the table as below. Please let me know if there is a better way to do this.
ApplicantID
ShiftID - (There will be a look up table for all Shifts in a day Early morning -1, Midway -2 etc.;)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon Tue Wed Thu Fri Sat Sunday
Early Morning x
Mid day x x
Afternoon x
Evening
Overnight x x
I'm designing the table as below. Please let me know if there is a better way to do this.
ApplicantID
ShiftID - (There will be a look up table for all Shifts in a day Early morning -1, Midway -2 etc.;)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
satishjayan- Posts : 4
Join date : 2012-12-18
Similar topics» credit card model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|