Hello All,
I have created the ERD for my project, here is the scenario:
Employee is allocated to one manager whilst a manager can manage many employees.
An employee can work just on one type of shift whilst a shift can hold many employees
An employee can book many holidays whilst a holiday can contain more than one employee (6)
Employee can work on many systems whilst a system can be worked on my many employees (the systems will be present in the employee table)
Employee can have a certain amount of holidays allocated; a profile of holiday can be allocated to one employee, while an employee can have one profile of holiday allocation.
An employee can be off from work more than once in any given day (employee can have holiday in the first half of the day and then be sick for the rest of the day (pm).
Here is a pic of the ERD:
Can you see any relational problems?
Also when I create a holiday for an employee, how does the holiday booking table update itself with the records?
Thanks
________
Web Shows
I have created the ERD for my project, here is the scenario:
Employee is allocated to one manager whilst a manager can manage many employees.
An employee can work just on one type of shift whilst a shift can hold many employees
An employee can book many holidays whilst a holiday can contain more than one employee (6)
Employee can work on many systems whilst a system can be worked on my many employees (the systems will be present in the employee table)
Employee can have a certain amount of holidays allocated; a profile of holiday can be allocated to one employee, while an employee can have one profile of holiday allocation.
An employee can be off from work more than once in any given day (employee can have holiday in the first half of the day and then be sick for the rest of the day (pm).
Here is a pic of the ERD:
Can you see any relational problems?
Also when I create a holiday for an employee, how does the holiday booking table update itself with the records?
Thanks
________
Web Shows
Last edited: