CREATE TABLE RECOGNITION ( recogID VARCHAR2 NOT NULL, recogReason VARCHAR2(50) NOT NULL, CONSTRAINT RECOGNITION_PK PRIMARY KEY (recogID) ); CREATE TABLE DEGREE ( degreeID VARCHAR2 NOT NULL, degreeName VARCHAR2(30) NOT NULL, CONSTRAINT COLLEGE_PK PRIMARY KEY (degreeID) ); CREATE TABLE EMPLOYER ( employerID VARCHAR2 NOT NULL, employerAddress VARCHAR2(30) NOT NULL, employerName VARCHAR2(30) NOT NULL, CONSTRAINT DEGREE_PK PRIMARY KEY (employerID) ); CREATE TABLE DEPARTMENT ( deptID VARCHAR2 NOT NULL, deptName VARCHAR2(20) NOT NULL, CONSTRAINT DEPARTMENT_PK PRIMARY KEY (deptID) ); CREATE TABLE ALUMNI ( alumID NUMBER NOT NULL, firstName CHAR(20) NOT NULL, recogID VARCHAR2 NOT NULL, lastName CHAR(20) NOT NULL, address VARCHAR2(30), city VARCHAR2(15) NOT NULL, state CHAR(15) NOT NULL, zipcode CHAR(15) NOT NULL, phoneNumber VARCHAR2(10), deptID VARCHAR2 NOT NULL, CommitteeID VARCHAR2 NOT NULL, employerID VARCHAR2 NOT NULL, degreeID VARCHAR2 NOT NULL, CONSTRAINT ALUMNI_PK PRIMARY KEY (alumID) ); CREATE TABLE DONOR ( donorID VARCHAR2 NOT NULL, recogID VARCHAR2 NOT NULL, alumID NUMBER NOT NULL, donorLastName VARCHAR2(20) NOT NULL, donorFirstName VARCHAR2, donationType VARCHAR2(20) NOT NULL, alumni NUMBER NOT NULL, CONSTRAINT DONOR_PK PRIMARY KEY (donorID) ); CREATE TABLE COMMITTEES ( CommitteeID VARCHAR2 NOT NULL, CommitteeMemberID VARCHAR2 NOT NULL, CommitteePosition CHAR NOT NULL, donorID VARCHAR2 NOT NULL, CONSTRAINT COMMITTEES_PK PRIMARY KEY (CommitteeID) ); CREATE TABLE EVENTS ( eventID VARCHAR2 NOT NULL, CommitteeID VARCHAR2 NOT NULL, eventName VARCHAR2 NOT NULL, eventDate DATE NOT NULL, eventTime DATE NOT NULL, CONSTRAINT EVENTS_PK PRIMARY KEY (eventID) ); CREATE TABLE MONETARYDONATION ( donationID VARCHAR2 NOT NULL, donorID VARCHAR2 NOT NULL, donationAmount NUMBER NOT NULL, donationCause VARCHAR2(50) NOT NULL, CONSTRAINT MONETARYDONATION_PK PRIMARY KEY (donationID) ); ALTER TABLE ALUMNI ADD CONSTRAINT RECOGNITION_ALUMNI_FK FOREIGN KEY (recogID) REFERENCES RECOGNITION (recogID) NOT DEFERRABLE; ALTER TABLE DONOR ADD CONSTRAINT RECOGNITION_DONOR_FK FOREIGN KEY (recogID) REFERENCES RECOGNITION (recogID) NOT DEFERRABLE; ALTER TABLE ALUMNI ADD CONSTRAINT COLLEGE_ALUMNI_FK FOREIGN KEY (degreeID) REFERENCES DEGREE (degreeID) NOT DEFERRABLE; ALTER TABLE ALUMNI ADD CONSTRAINT EMPLOYER_ALUMNI_FK FOREIGN KEY (employerID) REFERENCES EMPLOYER (employerID) NOT DEFERRABLE; ALTER TABLE ALUMNI ADD CONSTRAINT DEPARTMENT_ALUMNI_FK FOREIGN KEY (deptID) REFERENCES DEPARTMENT (deptID) NOT DEFERRABLE; ALTER TABLE DONOR ADD CONSTRAINT ALUMNI_DONOR_FK FOREIGN KEY (alumID) REFERENCES ALUMNI (alumID) NOT DEFERRABLE; ALTER TABLE MONETARYDONATION ADD CONSTRAINT DONOR_MONETARYDONATION_FK FOREIGN KEY (donorID) REFERENCES DONOR (donorID) NOT DEFERRABLE; ALTER TABLE COMMITTEES ADD CONSTRAINT DONOR_COMMITTEES_FK FOREIGN KEY (donorID) REFERENCES DONOR (donorID) NOT DEFERRABLE; ALTER TABLE ALUMNI ADD CONSTRAINT COMMITTEES_ALUMNI_FK FOREIGN KEY (CommitteeID) REFERENCES COMMITTEES (CommitteeID) NOT DEFERRABLE; ALTER TABLE EVENTS ADD CONSTRAINT COMMITTEES_EVENTS_FK FOREIGN KEY (CommitteeID) REFERENCES COMMITTEES (CommitteeID) NOT DEFERRABLE;

Make sure all tables resulting from your design are in Boyce-Codd Normal Form. Write CREATE TABLE statements for each of the tables. Use FOREIGN KEY constraints to create appropriate referential integrity constraints. Set ON DELETE [CASCADE SET NULL] behavior in accordance with your defined referential integrity actions. Note that Oracle does not support ON UPDATE [NO ACTION | CASCADE] The feeling at Oracle is that Primary keys should never be changed. They are supposed to be immutable. Write INSERT statements to insert at least three rows into each table. Create a view that hides columns to simplify results or to prevent the display of sensitive data. Create a view that hides complicated SQL syntax. Create a view that could be used to limit read access to specific rows and columns