The FlexForce Solutions: Pioneering Flexible Staffing Solutions

The FlexForce Solutions $($FFS$)$ is an agency that places temporary workers in companies. It has emerged as a dynamic agency catering to the evolving needs of the modern workforce and the fluctuating demands of various industries. With a keen understanding of the value of flexibility in today's economy, FFS specializes in placing temporary workers in companies across diverse sectors$.$ FFS keeps a file of candidates who are willing to work and a list of companies that request temporaries.

FFS maintains a specific job history for any candidate who has worked before. Each time a candidate works, an additional job history record is created for the candidate. Qualification is required for all candidates. Each candidate needs to have earned at least one qualification. Different candidates can have earned the same qualification. FFS offers courses to help candidates to improve their qualifications. Each course develops one specific qualification; however, TE does not offer a course for every qualification. Some qualifications are developed through multiple courses.

Courses that cover basic topics do not require any prerequisite qualifications. Courses that cover advanced topics will require specific qualification as prerequisites. A course can require several prerequisites. A qualification can be a prerequisite for more than one course. Courses are taught during training sessions. A training session is the presentation of a single course. Over time, FFS will offer many training sessions for each course; however, new courses may not have any training sessions scheduled right away. Candidates can pay a fee to attend a training session. A training session can accommodate several candidates, although new training sessions will not have any candidates registered at first. A request for a temporary employee by a company is referred to as an opening. FFS keeps a folder called Openings to record all openings. Each opening in the folder records the name of the company that requested a temporary employee, the required qualifications, the starting date,

an anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification. An opening can be filled by many candidates, and a candidate can fill many openings. Each opening is assigned an opening number.

Jobs are assigned to candidates who match the required qualification. FFS keeps a folder called Placement Record to record all placements.

Requirements:

FFS wants to keep track of available resource and service they can offer for management and marketing purpose. You are asked to help the TC management team to develop an RDBMS$.$ In the design phase $($i$.$e$.,$ your Assignment $1),$ your task is to design an ERD for this enterprise. Specifically, you are required to:

a$)$ Identify all business rules from the TE business operation described above.

b$)$ Identify all necessary entities and relationships between them and List.