CREATE TABLE T_ADHERENT
(
ADR_ID        number(4) NOT NULL PRIMARY KEY,
ADR_NOM       VARCHAR2(32),
ADR_PRENOM    VARCHAR2(25)
);
 
CREATE TABLE T_SPORT
(
SPT_ID        number(4) PRIMARY KEY,
SPT_LIBELLE   VARCHAR2(32)
);
 
CREATE TABLE T_J_PRATIQUE
(
ADR_ID   number(4)  NOT NULL,
SPT_ID   number(4)  NOT NULL,
PRIMARY KEY (ADR_ID, SPT_ID),
FOREIGN KEY (ADR_ID) REFERENCES T_ADHERENT (ADR_ID),  
FOREIGN KEY (SPT_ID) REFERENCES T_SPORT (SPT_ID)
);
