DBMS-LAB-Programs/Programs/program1/INSERT.sql at main · Raghuvorkady/DBMS-LAB-Programs · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
INSERT INTO PUBLISHER VALUES ('MCGRAW-HILL', 'BANGALORE', 9989076587);
INSERT INTO PUBLISHER VALUES ('PEARSON', 'NEWDELHI', 9889076565);
INSERT INTO PUBLISHER VALUES ('RANDOM HOUSE', 'HYDERABAD', 7455679345);
INSERT INTO PUBLISHER VALUES ('HACHETTE LIVRE', 'CHENNAI', 8970862340);
INSERT INTO PUBLISHER VALUES ('GRUPO PLANETA', 'BANGALORE', 7756120238);

INSERT INTO BOOK VALUES (1,'DBMS','JAN-2017', 'MCGRAW-HILL');
INSERT INTO BOOK VALUES (2,'ADBMS','JUN-2016', 'MCGRAW-HILL');
INSERT INTO BOOK VALUES (3,'CN','SEP-2016', 'PEARSON');
INSERT INTO BOOK VALUES (4,'CG','SEP-2015', 'GRUPO PLANETA');
INSERT INTO BOOK VALUES (5,'OS','MAY-2016', 'PEARSON');

INSERT INTO BOOK_AUTHORS VALUES (1, 'NAVATHE');
INSERT INTO BOOK_AUTHORS VALUES (2, 'NAVATHE');
INSERT INTO BOOK_AUTHORS VALUES (3, 'TANENBAUM');
INSERT INTO BOOK_AUTHORS VALUES (4, 'EDWARD ANGEL');
INSERT INTO BOOK_AUTHORS VALUES (5, 'GALVIN');

INSERT INTO LIBRARY_BRANCH VALUES (10,'RR NAGAR','BANGALORE');
INSERT INTO LIBRARY_BRANCH VALUES (11,'RNSIT','BANGALORE');
INSERT INTO LIBRARY_BRANCH VALUES (12,'RAJAJI NAGAR', 'BANGALORE');
INSERT INTO LIBRARY_BRANCH VALUES (13,'NITTE','MANGALORE');
INSERT INTO LIBRARY_BRANCH VALUES (14,'MANIPAL','UDUPI');

INSERT INTO BOOK_COPIES VALUES (1, 10, 10);
INSERT INTO BOOK_COPIES VALUES (1, 11, 5);
INSERT INTO BOOK_COPIES VALUES (2, 12, 2);
INSERT INTO BOOK_COPIES VALUES (2, 13, 5);
INSERT INTO BOOK_COPIES VALUES (3, 14, 7);
INSERT INTO BOOK_COPIES VALUES (5, 10, 1);
INSERT INTO BOOK_COPIES VALUES (4, 11, 3);

INSERT INTO CARD VALUES (100);
INSERT INTO CARD VALUES (101);
INSERT INTO CARD VALUES (102);
INSERT INTO CARD VALUES (103);
INSERT INTO CARD VALUES (104);

INSERT INTO BOOK_LENDING VALUES (1, 10, 101, '01-JAN-17', '01-JUN-17');
INSERT INTO BOOK_LENDING VALUES (3, 14, 101, '11-JAN-17', '11-MAR-17');
INSERT INTO BOOK_LENDING VALUES (2, 13, 101, '21-FEB-17', '21-APR-17');
INSERT INTO BOOK_LENDING VALUES (4, 11, 101, '15-MAR-17', '15-JUL-17');
INSERT INTO BOOK_LENDING VALUES (1, 11, 104, '12-APR-17', '12-MAY-17');