Query 5: Management needs to know the candidates who haven’t been successfully placed into employment with any of the companies. These identified candidates will then be contacted and encouraged to enroll into courses that will help provide the required qualifications and improve the candidates’ chances of a successful placement. List these candidates and the recommended courses that they should be encouraged to enroll in.
VII. Query 6: For each of the identified candidates that require further education, management will need to inform each student of the courses, when each course will start, the respective cost of each course and the total cost of the required courses. The list is to be ordered by the candidate’s last name in ascending order.
VIII. Query 7: Management needs a list of all the candidates who are currently pursuing studies and the respective qualifications that they are studying. For qualifications that require multiple courses, management needs to know how many courses each student has completed/enrolled in.
IX. Query 8: To help finalise financial records for the 1st quarter of the year, management needs to know candidates who have not paid their fees in order to contact them.
X. Query 9: For each opening, management will need to determine the most suitable candidate/s. Each potential candidate will then be further evaluated to ensure maximum suitability. List all the
companies that have current openings and the details, qualifications and number of successful placements of candidates that could be shortlisted for these openings.
XI. Query 10: Marketing department needs three of the most successful candidates and three of the most successful companies to feature in the latest edition of TE’s newsletter and website.
XII. Query 11: To help determine the average pay rate based on qualifications for the respective companies, management needs a list of all the companies, the qualifications they are requesting for the openings and the average pay for openings by each company.