how to answer this in Sql: Study the Scenario below: Parttime Employment Corporation (PEC) places parttime workers in companies around Johannesburg. PECs manager gives you the following description of the business: PEC has a file of candidates who are willing to work. In the case where the candidate has prior work experience, they possess a distinct employment background. Conversely, if the candidate has never worked, they lack any job history. Whenever the candidate engages in employment, a new job history entry is generated. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a BSc degree or an Azure Certification. And clearly, a candidate may have earned both a BSc and an Azure Certification.) PEC offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, PEC does not offer a course for every qualification. Some qualifications have multiple courses that develop that qualification. Certain courses delve into advanced subjects, necessitating specific qualifications as prerequisites. Conversely, there are courses focusing on fundamental topics, devoid of any prerequisite qualifications. A course may have multiple prerequisites, and a qualification can serve as a prerequisite for multiple courses. Courses are taught during training sessions. Each training session focuses on a specific course. As time progresses, PEC will provide multiple training sessions for each course. However, newly introduced courses may not have immediate scheduling for training sessions. 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. PEC also has a list of companies that request temporaries. Each time a company requests a part-time employee, PEC makes an entry in the Openings folder. That folder contains an opening number, a company name, required qualifications, a starting date, an anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification. When a candidate matches the qualification, the job is assigned, and an entry is made in the Placement Record folder. That folder contains an opening number, a candidate number, the total hours worked, etc. In addition, an entry is made in the job history for the candidate. An opening can be filled by many candidates, and a candidate can fill many openings. Source: Coronel, Morris, & Rob. (2013). Based on the scenario provided above, create, and draw an entity-relationship diagram. The diagram should indicate and clearly show the following. a. All entities with possible attributes (primary keys and foreign keys should be clearly shown and indicated as such). (12 Marks) b. All associating relationships between the entities (cardinalities and association names should be clearly shown). (18 Marks)