CREATE TABLE ch16_award ( aw_id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 10 INCREMENT BY 10, award_description VARCHAR(15), amount_eur NUMBER, CONSTRAINT ch16_award_id_pk PRIMARY KEY ( aw_id ) ) / CREATE TABLE ch16_employee ( emp_id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 1 INCREMENT BY 1, fname VARCHAR(30) NOT NULL, lname VARCHAR(30) NOT NULL, email VARCHAR(50) NOT NULL , manager NUMBER, CONSTRAINT ch16_emp_id_pk PRIMARY KEY ( emp_id ) ) / CREATE TABLE ch16_idea ( idea_id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 1 INCREMENT BY 1, contributor NUMBER NOT NULL, submission_date DATE DEFAULT sysdate NOT NULL, title VARCHAR(50) NOT NULL, idea_description BLOB, idea_filename VARCHAR(80), mime_type VARCHAR(100), decision VARCHAR(6), decision_date DATE DEFAULT sysdate, decision_maker NUMBER, award_type NUMBER, CONSTRAINT ch16_idea_id_pk PRIMARY KEY ( idea_id ) ) / ALTER TABLE ch16_employee ADD CONSTRAINT ch16_employee_manager_fk FOREIGN KEY ( manager ) REFERENCES ch16_employee ( emp_id ) ON DELETE CASCADE; ALTER TABLE ch16_idea ADD CONSTRAINT ch16_idea_award_type_fk FOREIGN KEY ( award_type ) REFERENCES ch16_award ( aw_id ) ON DELETE CASCADE; ALTER TABLE ch16_idea ADD CONSTRAINT ch16_idea_contributor_fk FOREIGN KEY ( contributor ) REFERENCES ch16_employee ( emp_id ) ON DELETE CASCADE; ALTER TABLE ch16_idea ADD CONSTRAINT ch16_idea_decision_maker_fk FOREIGN KEY ( decision_maker ) REFERENCES ch16_employee ( emp_id ) ON DELETE CASCADE;