Question

Hey can anyone help me fix the logic in these CREATE statements? The create SITE will not run because it gets a "no matching unique or primary key for this column-list". I already asked this question before the expert before gave the wrong answer

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(NOC),

 

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

 

 

 

);

 

 

 

 

 

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)

 

);

Answer 1

Below i am giving the correct query .There was some syntax error and spelling mistakes in the given query.you can run the below query successfully..pls run it.

Query

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(ATHELTE_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(NOC),

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

);

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(RESULT_ID)

);

CREATE TABLE EVENT (

SPORT_EVENT VARCHAR2(100),

SPORT VARCHAR2(50),

GAMES VARCHAR2(50),

CONSTRAINT event_pk PRIMARY KEY(SPORT_EVENT)

);

******************END***********PLS GIVE ME UPVOTE********************