CREATE OR REPLACE FORCE VIEW "SESSIAVIEW" ("GRUPPA", "TIP", "FAKULTETT", "KURS", "AUDITORIA", "DATTE", "NAME_DISCIP", "FIO_PREPODS", "DOLZHNOST") AS select "SESSIA"."GRUPPA" as "GRUPPA", "SESSIA"."TIP" as "TIP", "SESSIA"."FAKULTETT" as "FAKULTETT", "SESSIA"."KURS" as "KURS", "SESSIA"."AUDITORIA" as "AUDITORIA", "SESSIA"."DATTE" as "DATTE", "DISCIPLIN"."NAME_DISCIP" as "NAME_DISCIP", "PREPODS"."FIO_PREPODS" as "FIO_PREPODS", "PREPODS"."DOLZHNOST" as "DOLZHNOST" from "PREPODS" "PREPODS", "KAFEDRY" "KAFEDRY", "DISCIPLIN" "DISCIPLIN", "SESSIA" "SESSIA" where "DISCIPLIN"."SHIFR_DIS"="SESSIA"."SHIFR_DIS" and "KAFEDRY"."SHIFR_KAF"="PREPODS"."SHIFR_KAF" and "PREPODS"."SHIFR_PREPODS"="SESSIA"."SHIFR_PREPODS" /
CREATE OR REPLACE FORCE VIEW "GRUPPA-EKZAMEN" ("NAME_DISCIP", "GRUPPA", "DATTE", "AUDITORIA") AS select "DISCIPLIN"."NAME_DISCIP" as "NAME_DISCIP", "SESSIA"."GRUPPA" as "GRUPPA", "SESSIA"."DATTE" as "DATTE", "SESSIA"."AUDITORIA" as "AUDITORIA" from "DISCIPLIN" "DISCIPLIN", "SESSIA" "SESSIA" where "DISCIPLIN"."SHIFR_DIS"="SESSIA"."SHIFR_DIS" /
CREATE OR REPLACE FORCE VIEW "KAFEDRA-DISCIPLINS" ("NAME_KAFEDRA", "NAME_DISCIP") AS select "KAFEDRY"."NAME_KAFEDRA" as "NAME_KAFEDRA", "DISCIPLIN"."NAME_DISCIP" as "NAME_DISCIP" from "PREPODS" "PREPODS", "KAFEDRY" "KAFEDRY", "SESSIA" "SESSIA", "DISCIPLIN" "DISCIPLIN" where "DISCIPLIN"."SHIFR_DIS"="SESSIA"."SHIFR_DIS" and "KAFEDRY"."SHIFR_KAF"="PREPODS"."SHIFR_KAF" and "PREPODS"."SHIFR_PREPODS"="SESSIA"."SHIFR_PREPODS" /
