SQL> @C:\groupA9.sql
DROP TABLE SUPPLIERPARTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE ORDERLINE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE BOAT
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE RENTAL
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE CLASSSIZE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE ORDERS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE PARTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE SUPPLIER
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE DEALER
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE MAINTENANCE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE CUSTOMER
           *
ERROR at line 1:
ORA-00942: table or view does not exist



Table created.

FOREIGN KEY (boat_id) REFERENCES BOAT(boat_id))
             *
ERROR at line 11:
ORA-00904: "BOAT_ID": invalid identifier



Table created.


Table created.


Table created.


Table created.


Table created.

CONSTRAINT fk_rental_boat FOREIGN KEY (boat_id) REFERENCES BOAT(boat_id),
                                       *
ERROR at line 10:
ORA-00904: "BOAT_ID": invalid identifier


CONSTRAINT fk_boat_supplier FOREIGN KEY (SuppID) REFERENCES SUPPLIER(SuppID),
                                         *
ERROR at line 11:
ORA-00904: "SUPPID": invalid identifier



Table created.


Table created.

create table a (...);
create table b (...);

alter table a add constraint pka primary key ...;
alter table b add constraint pkb primary key ...;

alter table a add constraint fkab foreign key ... references b ...;