Sorry in advance for the large question, but I'm working on a piece of coursework for a data management module using Oracle 12c, I don't have any prior experience in anything like this and I'm very confused as to what to do. The objective is to create a database for a fictional shipping company, I have created an ERD and exported that into a DDL to use for my database queries. I have been able to input data into the Ship table, however when I try to input data into any other tables it come up with Error ORA-00942: table or view does not exist, and I am unsure why. Below is the code exported from the DDL and some sample statements. Thank you in advance for any help that you can give.
CREATE TABLE Consignments
(
Consignment_Number CHAR (6 CHAR) NOT NULL ,
Supplier_Address VARCHAR2 (40 CHAR) ,
Delivery_Address VARCHAR2 (40 CHAR) ,
Volume NUMBER ,
Weight NUMBER ,
Ship_Ship_Number CHAR (4 CHAR) NOT NULL
) ;
ALTER TABLE Consignments ADD CONSTRAINT Consignments_PK PRIMARY KEY (
Consignment_Number ) ;
CREATE TABLE Officers
(
Officer_Number CHAR (6 CHAR) NOT NULL ,
Officer_Name VARCHAR2 (20 CHAR) ,
Officer_Address VARCHAR2 (40 CHAR) ,
Officer_DoB DATE ,
Officer_Rank VARCHAR2 (20 CHAR) ,
Ship_Ship_Number CHAR (4 CHAR) NOT NULL ,
Officers_Officer_Number CHAR (6 CHAR) ,
Officers_Ship_Ship_Number CHAR (4 CHAR)
) ;
ALTER TABLE Officers ADD CONSTRAINT Officers_PK PRIMARY KEY (
Officer_Number, Ship_Ship_Number ) ;
CREATE TABLE Port
(
Port_Number CHAR (3 CHAR) NOT NULL ,
Port_Name VARCHAR2 (20 CHAR) ,
Agent_Name VARCHAR2 (20 CHAR) ,
Arrival_Date DATE ,
Departure_Date DATE
) ;
ALTER TABLE Port ADD CONSTRAINT Port_PK PRIMARY KEY ( Port_Number ) ;
CREATE TABLE Relation_1
(
Voyage_Voyage_Number CHAR (6 CHAR) NOT NULL ,
Port_Port_Number CHAR (3 CHAR) NOT NULL
) ;
ALTER TABLE Relation_1 ADD CONSTRAINT Relation_1_PK PRIMARY KEY (
Voyage_Voyage_Number, Port_Port_Number ) ;
CREATE TABLE Ship
(
Ship_Number CHAR (4 CHAR) NOT NULL ,
Ship_Name CHAR (20 CHAR) ,
Voyage_Voyage_Number CHAR (6 CHAR) NOT NULL
) ;
CREATE UNIQUE INDEX Ship__IDX ON Ship
(
Voyage_Voyage_Number ASC
)
;
ALTER TABLE Ship ADD CONSTRAINT Ship_PK PRIMARY KEY ( Ship_Number ) ;
CREATE TABLE Voyage
(
Voyage_Number CHAR (6 CHAR) NOT NULL ,
Duration NUMBER ,
Ship_Ship_Number CHAR (4 CHAR) NOT NULL
) ;
CREATE UNIQUE INDEX Voyage__IDX ON Voyage
(
Ship_Ship_Number ASC
)
;
ALTER TABLE Voyage ADD CONSTRAINT Voyage_PK PRIMARY KEY ( Voyage_Number ) ;
ALTER TABLE Consignments ADD CONSTRAINT Consignments_Ship_FK FOREIGN KEY (
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;
ALTER TABLE Relation_1 ADD CONSTRAINT FK_ASS_1 FOREIGN KEY (
Voyage_Voyage_Number ) REFERENCES Voyage ( Voyage_Number ) ;
ALTER TABLE Relation_1 ADD CONSTRAINT FK_ASS_2 FOREIGN KEY (
Port_Port_Number ) REFERENCES Port ( Port_Number ) ;
ALTER TABLE Officers ADD CONSTRAINT Officers_Officers_FK FOREIGN KEY (
Officers_Officer_Number, Officers_Ship_Ship_Number ) REFERENCES Officers (
Officer_Number, Ship_Ship_Number ) ;
ALTER TABLE Officers ADD CONSTRAINT Officers_Ship_FK FOREIGN KEY (
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;
ALTER TABLE Ship ADD CONSTRAINT Ship_Voyage_FK FOREIGN KEY (
Voyage_Voyage_Number ) REFERENCES Voyage ( Voyage_Number ) ;
ALTER TABLE Voyage ADD CONSTRAINT Voyage_Ship_FK FOREIGN KEY (
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;
INSERT INTO Officers (Officer_Number, Officer_Name, Officer_Address,
Officer_DoB, Officer_Rank, Ship_Ship_Number)
VALUES (000000, 'J. Cena', ('1 Elder Row, Glasgow'), 1970-01-01, 'Captain',
1111)