Can someone fix my SQL Create Table statements? I'm lost on how to create table SITE with correct primary key and foreign key... I will show you the ERD Diagram I was following and the CSV file for the database! Thank you!

CREATE TABLE OLMP_COUNTRY (

NOC CHAR(3),

TEAM VARCHAR2(100),

CITY VARCHAR2(100),

CONSTRAINT country_pk PRIMARY KEY(NOC)

);

CREATE TABLE ATHLETE (

ATHELTE_ID CHAR(8),

NAME VARCHAR2(100),

AGE CHAR(3),

SEX CHAR(1),

HEIGHT CHAR(3),

WEIGHT DECIMAL(3,1),

NOC CHAR(3),

CONSTRAINT athlete_pk PRIMARY KEY(ATHLETE_ID),

CONSTRAINT country_fk FOREIGN KEY(NOC) REFERENCES OLMP_COUNTRY(NOC)

);

CREATE TABLE SITE (

NOC CHAR(3),

CITY VARCHAR2(100),

SEASON VARCHAR2(20),

YEAR CHAR(4),

CONSTRAINT site_pk PRIMARY KEY

);

CREATE TABLE RESULTS (

RESULT_ID CHAR(8),

MEDAL CHAR(6),

ATHLETE_ID CHAR(8),

SPORT_EVENT VARCHAR2(100),

YEAR CHAR(4),

GAMES VARCHAR2(50),

CONSTRAINT results_pk PRIMARY KEY(RESULTS_ID)

);

CREATE TABLE EVENT (

SPORT_EVENT VARCHAR2(100),

SPORT VARCHAR2(50),

GAMES VARCHAR2(50)

CONSTRAINT event_pk PRIMARY KEY(SPORT_EVENT)

);

Belongs To SITE NOC TEAH RESIALTS SPORT EVENT athlete events.cav-Excel Insert Page Layout Formdlas Data Review View Adid-ins Hep Acrobat Team Tell me what you want to do AAWrsp Ted General lignment POSSIELE DATA LOSS Some feshures might be lost it you save this workbook in the comma-delimited (eaw) fommat. To preseve these features, seve it in an Excel file format Sex Age Height Weight Team CHN 1992 Summer 1992 Summer Barcelona Basketball CHN 2012 Summer 2012 Summer London Judo DEN 1920 Summer 1920 Summer Antwerpen Football 1 Gunnat Nielsen Aaby M 4Edgar undenau Aabye M 34 NA NA Denmark/Sweden bEN SOO Summer 1500 Summer para S Christine lacoba Aaftin F21 185 82NetherlandsNED 195s Winter 1983 Winter Clgaryspeod Skating Football Men's Football Tug-Of War Men's Tug-Of-War Speed Skating Wamen's 500 metres 24 NA NA Denmark aaftinf 2 RS Netherlands NED 1988 Winter 1988 Wnter Calgary Speed Skting peed Skating Women's 1,000 metres s Christieve Jacoba aftin s Cheistine lacobe Aattin 25 15 8 Notherland NED 1992 Winter 192 Winter Albertville Speed Skating 25 18S 82 Netherlands NED 1992 Winter1932 Winter Albertville Speed Skating 2 18s 2Netherlands NED 1994 Winter 1994 Winter Lillchammer Speed Skating 1992 winter Speed Skating Women's 1,000 metres Speed Skating Women's 1,000 metres Cross Country skiing Men's SO kilometres s Cheistine lacoba Aaftin F 27 15 82 Netherlands NED 1994 Winter 1994 Winter usichammer Speed Skating Speed Skating Women's 500 metres S Christine lacoba Aaftin M 31 18 75 United States USA 1992 Winter 1992 Winter Albertville Cross Country Sking Cross Country Skiing Men's 10 kilometres M 6Per Knut Aaland 31 ia8 United States usA i992 writer AlbertvilleCross Country skiing 6 Pee Knut AulandM 31 88 75 United StatesUSA 1992 Winter 1992 Winter Albertville Cross Country Skiing Cross Country Skring Men's 10/15 kilometres Pursuit NA b Per Knut AalandM 31 188 75 United States USA 1932 Winter 1992 Winter Albertville Cross Country Skiing Cross Country Skring Men's 4 x 10 kilometres Relay NA 6Per Knut Aaland bPet Knut Aaland M 33 2S United States usA1994 writer i994 winter Lillehammer Cross Country skiing Cross Country Skiing Men's 30 kilometre5 M 1BS 75United States usa994 winter i994 winter Lillehammer Cross Country Skiing Cross Country Skang Men's 10 kilometres 6 Per Knut Aaland M 33 18875 United States USA 194 Winter 1994 Winter Lillehammer Cross Country Sking Cross Country Skiing Men's zo/IS kilometres Pursuit NA United States u5A 1994 writer its winter ullehammer cross country Skiing Cross Country Ski.ng Mens 4 s iokilometres Rela, NA M 31 183 2 United States USA 1992 Winter 1992 winter Albertville Cross Country skirg Cross Country Skiing Men's 10 kilometres M 311 2 United States usa 1932 Winter 1992 Winter Alb ross Country Sking Cross Country Sking Men's 50 kilometres 72 united States USA 1932 Winter 1992 Winter Albertville Cross Country Skiing Cross Country Skring Men's 10/15 kilometres Pursuit NA 2 United States USA 1992 Winter1932 Winter Albertville Crass Country Sking Crass Country Skiing Mon's 4 x 10 kilometres Reday NA M 31 18 Winter 72 United States USA R United StatesUSA 1934 Winter194 uillehammer Cross Country Skiing Cross Country Sking Men's 10 kilometres Cross Country skar% cross country skiing Men's 30 kilometrus Lullehammer Cross Country Sking Cross Country Skuing Men's 20/15 kilometres Pursuit NA Ulwhammer Cross Country Sking Cross Country Skimg Men's 4 x 10 kilometres Relay NA Winter Cross 1932 Summer 1312 Sumner Los Angeles Athietics NED 1932 Summer 1932 Summer Los Angeles Athletics Winter 2002 Winter Salt Lake City ice Hockey 1952 summe 3952 Summer Helsinki 5wimming Athleties Women's 4 x 300 metres Relay ce Hockey Men's ice Hockey 90 winter 1990 winter Lake