Human Resources Department (HRD) of an organization follows the performance of the workers employed in different departm

[answerhappygod]

Human Resources Department (HRD) of an organization follows the
performance of the workers employed in different departments based
on the hours they have worked in various projects within the
organization. Every project has different hourly performance score
determined by the project leader that will contribute to the
worker's performance. Working hours of each worker for each project
in each day are recorded. The manager of HRD wants the following
two reports to be taken from the information system that will be
developed.
1 - For a specific project, list of workers who have worked in
that project together with their project performance score and the
name of the department they are working in, for the inputted
month-year
2 - For a specific department, list of workers of that
department together with the names of the projects they have
worked
QUESTIONS
- Design the codes for departments, projects & workers[for
each of them give the code type and also give an example]
- Design the database for the above case [for each file;
give the name of the file, its type, its attributes,
primary/foreign key(s) if exist (s)]
- Design the two reports mentioned in the above case (report 1 :
20 points - report 2 : 15 points