daymoon
Premium Member
Registered: 1st Aug 08
Location: Selby, North Yorkshire
User status: Offline
|
Anyone want to help me?
UNF
Employee number
Employee name
Employee phone number
Chamber description
Shift preference
Shift date
Shift hours
Holidays start
Holidays finish
|
Gary
Premium Member
Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
|
Sat what?
|
ashleh
Member
Registered: 23rd Dec 08
Location: Nottingham
User status: Offline
|
Did this at uni, it's shit  .
|
daymoon
Premium Member
Registered: 1st Aug 08
Location: Selby, North Yorkshire
User status: Offline
|
quote:
Originally posted by ashleh
Did this at uni, it's shit .
Every time I attempt it get different results
When look at solution it all makes sense but can never get to the answer myself 
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
You need to provide more information.
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
In fact, you need to actually ask a question 
|
noshua
Member
Registered: 19th Nov 08
User status: Offline
|
http://searchbusinessintelligence.techtarget.in/tutorial/Database-normalization-in-MySQL-Four-quick-and-easy-steps
Also did this at uni, proper shit!
|
Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
|
I did this as part of my degree...and I found it to be a total bastard.
|
daymoon
Premium Member
Registered: 1st Aug 08
Location: Selby, North Yorkshire
User status: Offline
|
Well I done this again, tutor looked at it and I wasnt miles off. Looks like I learned something at uni
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
I hate storing dates.
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
quote:
Originally posted by Ian
I hate storing dates.
Dates in general? Or formatted dates?
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
Mostly making the decision what to store, like if you use a unix epoch but don't need per second resolution, and it breaks when the clocks go forward/back.
Then issues like if you were storing a period like a holiday whether you would store 7 days as 7 rows or just a start and finish date. The latter of which is more elegant, less susceptible to anomalies like missing a day out of the middle but also less elegant on the query because you need a range rather than just looking on the day.
Like if you had a hotel room and wanted to see if it was booked, you query on that day and it might appear free but there's a start and finish date which encompass it.
Once those decisions are made I'm OK but I hate having multiple approaches and not knowing which way to go, and dates do that to me the most.
|
