Kindly check my code below for the above project attached befor this Question, I have issue in the fact table F$\_$ORDERS and D$\_$SALESMAN $,$ thay are empty no data inside the tables and I make sure every things correct. please help me with this issues.

check the code below:

$--$ Project $1$:

SELECT $*$ from OE$.$CUSTOMERS;

CREATE TABLE CUSTOMER$\_$COPY AS

SELECT

CUSTOMER$\_$ID$,$

CUST$\_$FIRST$\_$NAME,

CUST$\_$LAST$\_$NAME,

NLS$\_$LANGUAGE,

NLS$\_$TERRITORY,

CREDIT$\_$LIMIT,

CUST$\_$EMAIL,

ACCOUNT$\_$MGR$\_$ID$,$

CUST$\_$GEO$\_$LOCATION,

DATE$\_$OF$\_$BIRTH,

MARITAL$\_$STATUS,

GENDER,

INCOME$\_$LEVEL

FROM OE$.$CUSTOMERS;

DESCRIBE CUSTOMER$\_$COPY

ALTER TABLE CUSTOMER$\_$COPY

ADD TURNOVER NUMBER$(12,2)$;

SELECT $*$ from CUSTOMER$\_$COPY;

ALTER TABLE CUSTOMER$\_$COPY

ADD CUST$\_$TYPE VARCHAR$2(1)$;

SELECT $*$ from CUSTOMER$\_$COPY;

select $*$ from customer$\_$copy order by customer$\_$ID;

select $*$ from OE$.$Orders order by customer$\_$ID;

UPDATE CUSTOMER$\_$COPY c

SET TURNOVER $=($SELECT SUM$($o$.$ORDER$\_$TOTAL$)$

FROM OE$.$ORDERS o

WHERE o$.$CUSTOMER$\_$ID $=$ c$.$CUSTOMER$\_$ID

GROUP BY o$.$CUSTOMER$\_$ID$)$;

SELECT $*$ FROM customer$\_$copy;

DECLARE

avg$\_$turnover NUMBER$(12,2)$;

BEGIN

$--$ Calculate average turnover

SELECT AVG$($TURNOVER$)$ INTO avg$\_$turnover FROM CUSTOMER$\_$COPY;

$--$ Update customer type

FOR cust$\_$rec IN $($SELECT $*$ FROM CUSTOMER$\_$COPY$)$ LOOP

IF cust$\_$rec.TURNOVER $>=$ avg$\_$turnover THEN

UPDATE CUSTOMER$\_$COPY

SET CUST$\_$TYPE $=\text{'}$A$\text{'}$

WHERE CUSTOMER$\_$ID $=$ cust$\_$rec.CUSTOMER$\_$ID;

ELSIF cust$\_$rec.TURNOVER $>=$ avg$\_$turnover$/2$ THEN

UPDATE CUSTOMER$\_$COPY

SET CUST$\_$TYPE $=\text{'}$B$\text{'}$

WHERE CUSTOMER$\_$ID $=$ cust$\_$rec.CUSTOMER$\_$ID;

ELSE

UPDATE CUSTOMER$\_$COPY

SET CUST$\_$TYPE $=\text{'}$C$\text{'}$

WHERE CUSTOMER$\_$ID $=$ cust$\_$rec.CUSTOMER$\_$ID;

END IF;

END LOOP;

END;

$/$

SELECT $*$ FROM customer$\_$copy;

SELECT CUST$\_$TYPE, COUNT$(*)$ AS NUM$\_$CUSTOMERS

FROM CUSTOMER$\_$COPY

GROUP BY CUST$\_$TYPE;

SELECT COUNT$(*)$ AS TOTAL$\_$CUSTOMERS

FROM CUSTOMER$\_$COPY;

SELECT COUNT$($DISTINCT NLS$\_$TERRITORY$)$ AS NUM$\_$COUNTRIES

FROM OE$.$CUSTOMERS;

CREATE TABLE CURRENCY$\_$RATES$($

CUR$\_$SIGN CHAR$(3),$

COUNTRY VARCHAR$2(30),$

CUR$\_$QTY NUMBER$(4),$

EURO$\_$RATE NUMBER$(8,6)$

$)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$CNY$\text{'},$ 'CHINA', $1,0\mathrm{.}13)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$INR$\text{'},$ 'INDIA', $1,0\mathrm{.}011)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$CHF$\text{'},$ 'SWITZERLAND', $1,0\mathrm{.}92)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$THB$\text{'},$ 'THAILAND', $1,0\mathrm{.}027)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$JPY$\text{'},$ 'JAPAN', $1,0\mathrm{.}0079)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$EUR$\text{'},$ 'ITALY', $1,1)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$USD$\text{'},$ 'AMERICA', $1,0\mathrm{.}81)$

;

INSERT INTO CURRENCY$\_$RATES $($CUR$\_$SIGN, COUNTRY, CUR$\_$QTY$,$ EURO$\_$RATE$)$

VALUES $(\text{'}$EUR$\text{'},$ 'GERMANY', $1,1)$

;

SELECT $*$ FROM CURRENCY$\_$RATES

;

CREATE TABLE ORDERS$\_$IN$\_$EURO AS

SELECT

O$.$ORDER$\_$ID$,$

O$.$CUSTOMER$\_$ID$,$

C$.$NLS$\_$TERRITORY AS COUNTRY,

O$.$ORDER$\_$TOTAL,

O$.$ORDER$\_$TOTAL $*$ CR$.$EURO$\_$RATE AS ORDER$\_$TOTAL$\_$EURO

FROM

OE$.$ORDERS O

JOIN

OE$.$CUSTOMERS C ON O$.$CUSTOMER$\_$ID $=$ C$.$CUSTOMER$\_$ID

JOIN

CURRENCY$\_$RATES CR ON C$.$NLS$\_$TERRITORY $=$ CR$.$COUNTRY

;

CREATE OR REPLACE FUNCTION CONVERT$\_$TO$\_$EURO$($

p$\_$order$\_$total IN NUMBER,

p$\_$country IN VARCHAR$2$

$)$ RETURN NUMBER AS

v$\_$euro$\_$rate NUMBER;

BEGIN

SELECT EURO$\_$RATE INTO v$\_$euro$\_$rate

FROM CURRENCY$\_$RATES

WHERE COUNTRY $=$ p$\_$country;

RETURN p$\_$order$\_$total $*$ v$\_$euro$\_$rate;

EXCEPTION

WHEN NO$\_$DATA$\_$FOUND THEN

RETURN NULL;

END CONVERT$\_$TO$\_$EURO;

$/$

UPDATE ORDERS$\_$IN$\_$EURO

SET ORDER$\_$TOTAL$\_$EURO $=$ CONVERT$\_$TO$\_$EURO$($ORDER$\_$TOTAL, COUNTRY$)$

;

SELECT $*$ FROM ORDERS$\_$IN$\_$EURO

;

$-$

$---------$Project $2$ and $3$ in the attached pictures because it is not allowed here to write more. and for more clarification the project $1$ & $2$ is corrected and I submitted now I need to resolve project $3.$