Conception de bases de données

CREATE SCHEMA loisir;

CREATE SCHEMA loisir;

CREATE TABLE loisir.sport (

pknom VARCHAR(25) NOT NULL,

fketu CHAR(13) NOT NULL,

PRIMARY KEY (pknom, fketu),

FOREIGN KEY (fketu) REFERENCES etu(pknumsecu));

CREATE TABLE loisir.sport (
pknom VARCHAR(25) NOT NULL,
fketu CHAR(13) NOT NULL,
PRIMARY KEY (pknom, fketu),
FOREIGN KEY (fketu) REFERENCES etu(pknumsecu));

INSERT INTO loisir.sport (pknom, fketu)

VALUES ('Tennis', '1800675001066');

INSERT INTO loisir.sport (pknom, fketu)

VALUES ('Karaté', '1800675001066');

INSERT INTO loisir.sport (pknom, fketu)
VALUES ('Tennis', '1800675001066');
INSERT INTO loisir.sport (pknom, fketu)
VALUES ('Karaté', '1800675001066');

SET search_path TO public,loisir;

\d

SELECT * FROM loisir.sport;

SET search_path TO public,loisir;
\d
SELECT * FROM loisir.sport;