One of our experts has described the planning database for human resources of an enterprise. The ERP database system includes several components that help manage human resources in an enterprise: the maintenance of personnel records, working time, calculation of payments, traveling expenses, management of data about candidates, and many others. In this sample you can also check the ER-diagram.
If you are having trouble with your ERP database assignment, experts from AssignmentShark can help you with ease! We have gathered professionals that are in love with ERP systems and can easily solve any tasks related to their implementation. Our experts can deal with any ERP module: OLAP, EDI, CAD, CMS, CRM, and others. To get help, just complete the order form on our page and add specifications for your assignment. As soon as you will place the order and pick the expert who will be performing your assignment, the work will begin! You can communicate with the writer directly with the help of an online chat and control the writing process on our site. All of our clients feel safe and secure, as we guarantee total confidentiality. We provide online assignment help 24/7, so you can reach our experts at any time, no matter in what part of the world you are situated.
Planning Database for the Human Resources of the Enterprise
The department of labor and wages plans the demand for workers with different specialties and qualifications on the basis of specifications of products and schedules of the production.
Input information:
- The production department gives the specifications of the product and the need, in hours, for workers of different professions and places in the context of workshops and production units for each product.
- The planning department generates the schedule of output, which contains the planned number of products of each type for each date.
- The department of labor and wages sends the monthly plan of requirements, workshops, specializations, and qualifications to management.
We need to determine relationships between sets of entities and construct an ER model for the database.
The main function of the department of labor and wages is the distribution of the workforce of the workshops, and the implementation schedule for each type of product.
| № |
|
|
|
| 1 | 2 | 3 | 4 |
Schedule
| № |
|
|
| 1 | 2 | 3 |
Manpower requirements
| № |
|
|
|
|
| 1 | 2 | 3 | 4 | 5 |
Speciality
| № | Name |
| 1 | 2 |
Workshop
| № п/п |
|
|
| 1 | 2 | 3 |
Workshop
ER-Diagram
