CREATE TABLE CERT_ACC_AGENCY
(
  ACCRED_ID       NUMBER(4),
  ACCRED_ACRONYM  VARCHAR2(30 BYTE),
  ACCRED_NAME     VARCHAR2(100 BYTE),
  ACCRED_ORDER    NUMBER(4)
);

CREATE UNIQUE INDEX ACCREDITATION_AGENCY_PK ON CERT_ACC_AGENCY (ACCRED_ID);

ALTER TABLE CERT_ACC_AGENCY ADD (
  CONSTRAINT ACCREDITATION_AGENCY_PK
  PRIMARY KEY
  (ACCRED_ID)
  USING INDEX ACCREDITATION_AGENCY_PK
  ENABLE VALIDATE);

SET DEFINE OFF;
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (1, 'NCCA', 'National Commission For Certifying Agencies', 'This certification is accredited by NCCA.', 2);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (2, 'ANAB', 'ANSI National Accreditation Board', 'This certification is accredited by ANAB.', 3);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (3, 'JOB CORPS', 'Job Corps', 'This certification is related to Job Corps training programs.', 5);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (4, 'IND', 'Industry-Endorsed', 'This certification is third-party industry-endorsed.', 6);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (6, 'MILITARY', 'Military Occupational Specialties', 'This certification is related to military occupational specialties.', 4);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (7, 'ICAC', 'International Certification Accreditation Council', 'International Certification Accreditation Council', 8);
Insert into CERT_ACC_AGENCY
   (ACCRED_ID, ACCRED_ACRONYM, ACCRED_NAME, ACCRED_DESCRIPTION, ACCRED_ORDER)
 Values
   (8, 'In-Demand', 'In-demand', 'In-demand certification.', 1);
COMMIT;
