As the usage of the Tracking Job Opening at Personal Touch Inc, I have found some information from that. From the question that provided, some of them are meet the requirement while some of them are the major problem of this case.
For the information on weekly wages sorted by employer in ascending manner, it is the partially meet which we can find at queries. However, calculation of wage statistics grouped by position title is in the queries which is the partially meet. We can find the list of NAICS information in the table. It is the partially meet. Other than that, from the queries can also find the computation displaying the least paid wage, highest paid wage and the average paid wage. It is the partially meet also. The list of placement fee charges by state and report grouped by position title that will show the position ID, its employer and the total weekly wages as well as the grand total of weekly wages for the position title and in the report. It is the fully meet because the report is mixed up by the information in the report and queries. Lastly, form the queries we also can find the information of the list of positions that require working experience and list of positions with wages more than $17 per hour.
From the case, I also found out two major problems. There are the peak periods of recruitment to ensure that they have sufficient staff in hand to recruit candidates, and a report grouped by industry that will show the number of employees for each industry and the total number of job openings for each employer....