Table MAINUSER created.


Table USER_STUDENT created.


Commit complete.

Table USER_FACULTY created.


Commit complete.


Table COURSE created.

Table USER_TA created.


Table MODERATOR created.


Table SITE_ADMINISTRATOR created.


Table COURSE_INTEREST_GROUP created.

Table INTERST_CLUB created.


Error starting at line : 64 in command -
create table group_disforum ( df_id int,
ig_id int,
constraint gdf_FK foreign key(ig_id) references Course_Interest_group(interest_gid),
constraint gdf_PK primary key(df_id, ig_id),
comments varchar(150)
)
Error report -
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 -  "no matching unique or primary key for this column-list"
*Cause:    A REFERENCES clause in a CREATE/ALTER TABLE statement
           gives a column-list for which there is no matching unique or primary
           key constraint in the referenced table.
*Action:   Find the correct column names using the ALL_CONS_COLUMNS
           catalog view
Table CLUB_DISFORUM created.


Table COURSE_DISFORUM created.


Table TEACHES created.

Table ENROLLS created.


Commit complete.


Error starting at line : 97 in command -
create table joins_IG ( userid int,
ig_id int,
constraint joins_FK foreign key( userid) references Mainuser(userid),
constraint joins_FK2 foreign key(ig_id) references Course_Interest_group(interest_gid),
constraint joins_PK primary key(userid, ig_id)
)
Error report -
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 -  "no matching unique or primary key for this column-list"
*Cause:    A REFERENCES clause in a CREATE/ALTER TABLE statement
           gives a column-list for which there is no matching unique or primary
           key constraint in the referenced table.
*Action:   Find the correct column names using the ALL_CONS_COLUMNS
           catalog view
Table JOINS_CLUB created.


Table ASSIGNS created.


Commit complete.

Table HAS_CLUB created.


Commit complete.


Error starting at line : 126 in command -
create table has_ig( courseid, ig_id,
constraint ig_FK3 foreign key(courseid) references course(courseid),
constraint ig_FK4 foreign key (ig_id) references Course_Interest_group( interest_gid),
constraint ig_PK2 primary key(courseid, ig_id)
)
Error report -
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 -  "no matching unique or primary key for this column-list"
*Cause:    A REFERENCES clause in a CREATE/ALTER TABLE statement
           gives a column-list for which there is no matching unique or primary
           key constraint in the referenced table.
*Action:   Find the correct column names using the ALL_CONS_COLUMNS
           catalog view
Error starting at line : 132 in command -
create table has_grp_mod ( moderator_id int, ig_id int,
constraint grp_FK foreign key( moderator_id) references Moderator(Moderator_id),
constraint grp_FK1 foreign key(ig_id) references Course_Interest_group( interest_gid),
constraint grp_PK primary key( moderator_id, ig_id)
)
Error report -
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 -  "no matching unique or primary key for this column-list"
*Cause:    A REFERENCES clause in a CREATE/ALTER TABLE statement
           gives a column-list for which there is no matching unique or primary
           key constraint in the referenced table.
*Action:   Find the correct column names using the ALL_CONS_COLUMNS
           catalog view

Table HAS_CLUB_MOD created.