Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE KSIAZKA(
- ISBN INT(8) PRIMARY KEY,
- TYTUL VARCHAR(40) NOT NULL,
- WYDAWNICTWO VARCHAR(15) NOT NULL,
- ROK_WYDANIA INT(4) NOT NULL
- );
- CREATE TABLE AUTOR(
- ID_AUTORA INT(4) PRIMARY KEY,
- IMIE VARCHAR(15) NOT NULL,
- NAZWISKO VARCHAR(25) NOT NULL
- );
- CREATE TABLE AUTORSTWO(
- ISBN INT(8),
- ID_AUTORA INT(4),
- PRIMARY KEY(ISBN, ID_AUTORA),
- CONSTRAINT FOREIGN KEY(ISBN) REFERENCES KSIAZKA(ISBN),
- CONSTRAINT FOREIGN KEY(ID_AUTORA) REFERENCES AUTOR(ID_AUTORA)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement