-- create tables create table ch12_job ( id number generated by default on null as identity constraint ch12_job_id_pk primary key, job_description varchar2(100 char) ) ; create table ch12_competence ( id number generated by default on null as identity constraint ch12_competence_id_pk primary key, competence_description varchar2(100 char) ) ; create table ch12_job_competence ( id number generated by default on null as identity constraint ch12_job_competenc_id_pk primary key, id_job number constraint ch12_job_competenc_id_job_fk references ch12_job on delete cascade, id_competence number constraint ch12_job_compet_id_competen_fk references ch12_competence on delete cascade, required_level varchar2(8 char) constraint ch12_job_comp_required_leve_ck check (required_level in ('ASSIST','USE','MASTER','TAILOR','INNOVATE')) ) ; -- load data -- Generated by Quick SQL Monday January 09, 2023 20:55:02 /* CH12_JOB job_description vc100 CH12_COMPETENCE competence_description vc100 CH12_JOB_COMPETENCE id_job num /fk CH12_JOB id_competence num /fk CH12_COMPETENCE required_level vc10 /check 'assist','use','master', 'tailor','innovate' # settings = { semantics: "CHAR", language: "EN", APEX: true } */