Forum Discussion
Relationship & Data modelling
Memorable MemberIt is a bit mess to understand, but first of all regarding the structure I think you need
- For all tables: Merge day,month, year to create a date column in a format dd/mm/yyyy. and remove extra columns for all except date table.
- Employee Table (remove dayWeekMonthQuarter and keep date column created)
- Event Table (remove dayWeekMonthQuarter, everything related to employee except ID and keep date column created). That is Event should contain (Date, EmployeeID, Eventname and EventCount)
And now...Relate event table with employee by using EmployeeID and relate event table with Date table by using Date field
So you must have:
- Date (Date, year, month, quarter, week, day)
- Employee (Date, EmployeeID, First Name, Last Name, Dept.ID, Dep.GroupID, TeamID, Team)
- Event (Date, EmployeeID,Eventname,EventCount)
You could also create an auxiliary table for a better performance Team with TeamID, Team but is up to you.
Once you have structured the data it will be easier to compute all you need
Hello. Thank you for your suggestions. My main problem is that I don't have a clear staff and organisation table. In my "employees" table I have:
1.) Daily every employee
2.) and the corresponding organisationThis means that all ID's are always present several times
I can't build a unique organisation table because at different times the organisation names keep changing.
