Ok, I am creating a small application that handles a staff rota and have some data that needs normalising, I am familiar with the process however I've never normalised grid data before, let me explain..
here are the fields:
userID (this is included so each staff member can log in independantly, coinciding with other parts of the application)
Location (this is typically the same)
Dept (typically the same)
Hours Owed (calculated, so not to be included)
The raw data is a simple excel spreadsheet, with the days of the week across the top, the staff names down the side and shifts populating the rest i.e 8-8, 12-4 etc.
What I need to figure out is the repeating data, the rest will follow
I spoke with my tutor who reckoned I go with the days of the week as the repeating data, I dont agree. Here is what I reckon to be the repeating data, indented (as the data is repeated over and over):