Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE ETUDIANT(
- numetu VARCHAR(8),
- nom VARCHAR(30),
- prenom VARCHAR(30),
- datenaiss DATE,
- rue VARCHAR(50),
- cp number(5),
- ville VARCHAR(40),
- CONSTRAINT pk_etu PRIMARY KEY(numetu)
- );
- CREATE TABLE MATIERE(
- codemat NUMBER(4),
- libelle VARCHAR(30),
- coef NUMBER(3,1),
- CONSTRAINT pk_mat PRIMARY KEY(codemat)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement