Question

Having trouble creating SQL data base. Need help trying to correct the following data so that it will run...

CREATE TABLE CUSTOMER_T
(Customer_ID VARCHAR2(10),
CUSTOMER_NAME VARCHAR2(50),
CUSTOMER_STREET VARCHAR2(50),
CUSTOMER_CITY VARCHAR2(25),
CUSTOMER_STATE VARCHAR2(2),
CUSTOMER_POSTAL_CODE VARCHAR2(9),
CUSTOMER_TYPE VARCHAR2(20),
LOCATION_ID VARCHAR2(15),
CONSTRAINT CUSTOMER_PK PRIMARY KEY (CUSTOMER_ID),
CONSTRAINT CUSTOMER_FK FOREIGN KEY(LOCATION_ID) REFERENCES LOCATION_T (LOCATION_ID));

CREATE TABLE LOCATION_T
(LOCATION_ID VARCHAR2(15),
LOCATION_NAME VARCHAR2(30),
LOCATION_COUNTRY VARCHAR2(30),
CONSTRAINT LOCATION_PK PRIMARY KEY (LOCATION_ID),
CONSTRAINT LOCATION_FK FOREIGN KEY(RATE_ID) REFERENCES LOCATION(LOCATION_ID));

CREATE TABLE RATE_T
(RATE_ID VARCHAR2(15),
RATE_CLASS VARCHAR2(20),
RATE_PER_kwh NUMBER(10,2),
CONSTRAINT RATE_ID PRIMARY KEY (RATE_ID));

CREATE TABLE CUSTOMER_LOCATION_T
(CUSTOMER_ID VARCHAR2(25) NOT NULL,
LOCATION_ID VARHAR2(15) NOT NULL,
CONSTRAINT FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMER(CUSTOMER_ID),
CONSTRAINT customer_Location_fk FOREGIN KEY(LOCATION_ID) REFERENCES LOCATION(LOCATION_ID));

CREATE TABLE LOCATION_RATE_T
(LOCATION_ID VARCHAR2(15) NOT NULL,
RATE_ID VARCHAR2(15) NOT NULL,
TIME_OF_DAY TIME NOT NULL,
CONSTRAINT FOREIGN KEY(LOCATION_ID) REFERENCES LOCATION(LOCATION_ID),
CONSTRAINT FOREIGN KEY(RATE_ID) REFERENCES RATE(RATE_ID);

Answer 1

In table LOCATION_T there is no attribute named RATE_ID so it is been removed, whole LOCATION_FK has been removed, as no FOREIGN KEY is required there.
Next in table CUSTOMER_LOCATION_T "CONSTRAINT " and "CONSTRAINT customer_Location_fk " is removed along with spelling of FOREIGN is also corrected.
Similarly "CONSTRAINT " is also removed from table LOCATION_RATE_T and in the end bracket is added before ;

CREATE TABLE CUSTOMER_T
(CUSTOMER_ID VARCHAR2(10),
CUSTOMER_NAME VARCHAR2(50),
CUSTOMER_STREET VARCHAR2(50),
CUSTOMER_CITY VARCHAR2(25),
CUSTOMER_STATE VARCHAR2(2),
CUSTOMER_POSTAL_CODE VARCHAR2(9),
CUSTOMER_TYPE VARCHAR2(20),
LOCATION_ID VARCHAR2(15),
CONSTRAINT CUSTOMER_PK PRIMARY KEY (CUSTOMER_ID),
CONSTRAINT CUSTOMER_FK FOREIGN KEY(LOCATION_ID) REFERENCES LOCATION(LOCATION_ID));

CREATE TABLE LOCATION_T
(LOCATION_ID VARCHAR2(15),
LOCATION_NAME VARCHAR2(30),
LOCATION_COUNTRY VARCHAR2(30),
CONSTRAINT LOCATION_PK PRIMARY KEY (LOCATION_ID));

CREATE TABLE RATE_T
(RATE_ID VARCHAR2(15),
RATE_CLASS VARCHAR2(20),
RATE_PER_kwh NUMBER(10,2),
CONSTRAINT RATE_ID PRIMARY KEY (RATE_ID));

CREATE TABLE CUSTOMER_LOCATION_T
(CUSTOMER_ID VARCHAR2(25) NOT NULL,
LOCATION_ID VARCHAR2(15) NOT NULL,
FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMER(CUSTOMER_ID),
FOREIGN KEY(LOCATION_ID) REFERENCES LOCATION(LOCATION_ID));

CREATE TABLE LOCATION_RATE_T
(LOCATION_ID VARCHAR2(15) NOT NULL,
RATE_ID VARCHAR2(15) NOT NULL,
TIME_OF_DAY DATE NOT NULL,
FOREIGN KEY(LOCATION_ID) REFERENCES LOCATION(LOCATION_ID),
FOREIGN KEY(RATE_ID) REFERENCES RATE(RATE_ID));