Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE konyvt;
- USE konyvt;
- CREATE TABLE konyvek(
- isbn VARCHAR(50) PRIMARY KEY,
- szoveg VARCHAR(50),
- cim VARCHAR(100) NOT NULL,
- megjelenes INT NOT NULL
- );
- CREATE TABLE kolcsonzesek(
- id INT IDENTITY(1,1) PRIMARY KEY,
- kolcsonzo VARCHAR NOT NULL,
- konyv VARCHAR(50) FOREIGN KEY REFERENCES konyvek(isbn),
- hatarido DATE );
- INSERT INTO konyvek(isbn,szoveg,cim,megjelenes) VALUES
- ('9780394600284', 'Gustave Flaubert' ,'Madame Bovary', 1856),
- ('9783736411050', 'Leo Tolstoy', 'War and Peace', 1867),
- ('9781471229015', 'F. Scott Fitzgerald', 'The Great Gatsby', 1925),
- ('9789630786935', 'Vladimir Nabokov', 'Lolita', 1955),
- ('9781495379086', 'Marcel Proust', 'In Search of Lost Time', 1908);
- INSERT INTO kolcsonzesek(kolcsonzo,konyv,hatarido) VALUES
- ('Gipsz Elek', '9780394600284', '2018-10-20'),
- ('Gipsz Elek','9783736411050', '2018-10-20'),
- ('Szüre Tibor', '9789630786935', '2018-12-20'),
- ('Szüre Tibor', '9781495379086', '2018-12-30');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement