Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE programs (
  program_id    INTEGER PRIMARY KEY,
  institution   VARCHAR2(20),
  concentration VARCHAR2(20),
  degree        VARCHAR2(20)
)
CREATE TABLE users (
  user_id               INTEGER PRIMARY KEY
);
CREATE TABLE /*project1.*/Public_User_Information (
  user_id               INTEGER,
  program_year          INTEGER,
  institution_name      VARCHAR2(20),
  program_concentration VARCHAR2(20),
  program_degree        VARCHAR2(20)
)
CREATE TABLE Education(
    user_id INTEGER NOT NULL,
    program_id INTEGER NOT NULL,
    FOREIGN KEY (program_id) REFERENCES Programs,
    PRIMARY KEY (user_id),
    FOREIGN KEY(user_id) REFERENCES Users,
    program_year INTEGER NOT NULL
);
INSERT ALL
  INTO programs (program_id, institution, concentration, degree)
    VALUES (1, 'A', 'B', 'C')
  INTO users (user_id) VALUES (1)
  INTO /*project1.*/Public_User_Information (user_id, program_year, institution_name, program_concentration, program_degree)
    VALUES (1, 1970, 'A', 'B', 'C')
  INTO /*project1.*/Public_User_Information (user_id, program_year, institution_name, program_concentration, program_degree)
    VALUES (1, 1971, 'A', 'B', 'C')
SELECT * FROM DUAL;
4 rows affected

SELECT u.user_id, p.program_id, u.program_year
FROM   /*project1.*/Public_User_Information u,
       Programs p
WHERE  p.institution   = u.institution_name
AND    p.concentration = u.program_concentration
AND    p.degree        = u.program_degree


USER_ID
PROGRAM_ID
PROGRAM_YEAR


1
1
1970

1
1
1971


MERGE INTO Education e
    USING (SELECT u.user_id, p.program_id, u.program_year
           FROM /*project1.*/Public_User_Information u,
                Programs p
           WHERE p.institution = u.institution_name
             AND p.concentration = u.program_concentration
             AND p.degree = u.program_degree
    ) d
    ON (e.user_id = d.user_id)
    WHEN NOT MATCHED THEN
        INSERT (user_id, program_id, program_year)
        VALUES (d.user_id, d.program_id, d.program_year);
ORA-00001: unique constraint (FIDDLE_WVNYLTVXEWVIXVJCFJFW.SYS_C00104424) violated