overview
this is my hand-coded best guess at the HR portion of a large business, with the following criteria:
- keep track of employee locations
- keep track of employee salary histories and details about thhose events
- keep track of current salary
- updatable salary by groups using an embedded SQL program or PHP.
- company building locations are kept track of
no attempt at handling Accounting/Finance or Management or Facilities or Sales & Order Mgmt is taken into account, although I have some examples of Order Mgmt in a book I could expand on.
Download Nowcompany.sql - MySQL source
Download Nowgeneric-company-sql.zargo - ArgoUML diagram
UML 1.4 Class Diagram (I don't have an ER Diagrammer)
