System Analysis:Hire Co:HR Sub-system ERD

Human resources

Entity relationship diagram for HR subsystem



Entity relationship diagram for timesheets



Rules for timesheets (a one to many relationship)
 * A staff member can have 0, 1 or many timesheets
 * A timesheet must belong to a staff member

Staff is a strong entity as it is independent of other entities Timesheet is a weak entity (The double line rectangle), that is, the timesheet cannot exist without a staff member.

Entity relationship diagram for management



Rules for management: (a one to many relationship)
 * A staff member can manage 0, 1 or many staff members
 * A staff member can be managed by 0 or 1 staff

Entity relationship diagram for car parks



Rules for car parks: (a one to one relationship)
 * A staff member can have 0, 1 car parks
 * A car park can be assigned to 0 or 1 staff

{{vmv:FooterAPA}