Basic-Bank-Operations/insertions.sql at master · karthik07m/Basic-Bank-Operations · 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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158

/* ** Insert values in table called LMS_MEMBERS ** */


Insert into LMS_MEMBERS
Values('LM001', 'AMIT','CHENNAI','2012-02-12','2013-02-11','Temporary');


Insert into LMS_MEMBERS
Values('LM002', 'ABDHUL','DELHI', '2012-04-10','2013-04-09','Temporary');

Insert into LMS_MEMBERS
Values('LM003', 'GAYAN', 'CHENNAI','2013-05-12','2013-05-14', 'Permanent');

Insert into LMS_MEMBERS
Values('LM004', 'RADHA', 'CHENNAI', '2012-04-22','2013-04-21','Temporary');

Insert into LMS_MEMBERS
Values('LM005', 'GURU','BANGALORE', '2012-03-20','2013-03-29','Temporary');

Insert into LMS_MEMBERS
Values('LM006','MOHAN', 'CHENNAI', '2012-04-12','2013-04-12','Temporary');


/* ** Insert values in table called LMS_SUPPLIERS_DETAILS ** */


Insert into  LMS_SUPPLIERS_DETAILS
Values ('S01','SINGAPORE SHOPPEE', 'CHENNAI', 9894123555,'sing@gmail.com');


Insert into  LMS_SUPPLIERS_DETAILS
Values ('S02','JK Stores', 'MUMBAI', 9940123450 ,'jks@yahoo.com');


Insert into  LMS_SUPPLIERS_DETAILS
Values ('S03','ROSE BOOK STORE', 'TRIVANDRUM', 9444411222,'rose@gmail.com');


Insert into LMS_SUPPLIERS_DETAILS
Values ('S04','KAVARI STORE', 'DELHI', 8630001452,'kavi@redif.com');


Insert into  LMS_SUPPLIERS_DETAILS
Values ('S05','EINSTEN BOOK GALLARY', 'US', 9542000001,'eingal@aol.com');


Insert into  LMS_SUPPLIERS_DETAILS
Values ('S06','AKBAR STORE', 'MUMBAI',7855623100 ,'akbakst@aol.com');


/* ** Insert values in table called LMS_FINE_DETAILS ** */


Insert into LMS_FINE_DETAILS Values('R1', 20);


insert into LMS_FINE_DETAILS Values('R2', 50);


Insert into LMS_FINE_DETAILS Values('R3', 75);


Insert into LMS_FINE_DETAILS Values('R4', 100);


Insert into LMS_FINE_DETAILS Values('R5', 150);


Insert into LMS_FINE_DETAILS Values('R6', 200);


/* ** Insert values in table called LMS_BOOK_DETAILS ** */


Insert into LMS_BOOK_DETAILS
Values('BL000001', 'Java How To Do Program', 'JAVA', 'Paul J. Deitel', 'Prentice Hall', '1999-12-10', 6, 600.00, 'A1','2011-05-10', 'S01');


Insert into LMS_BOOK_DETAILS
Values('BL000002', 'Java: The Complete Reference ', 'JAVA', 'Herbert Schildt',  'Tata Mcgraw Hill ','2011-10-10', 5, 750.00, 'A1','2011-05-10', 'S03');


Insert into LMS_BOOK_DETAILS
Values('BL000003', 'Java How To Do Program', 'JAVA', 'Paul J. Deitel', 'Prentice Hall','1999-12-10',6, 600.00, 'A1', '2012-5-12', 'S01');


Insert into LMS_BOOK_DETAILS
Values('BL000004', 'Java: The Complete Reference ', 'JAVA', 'Herbert Schildt', 'Tata Mcgraw Hill ','2011-10-10', 5, 750.00, 'A1','2012-05-12', 'S01');


Insert into LMS_BOOK_DETAILS
Values('BL000005', 'Java How To Do Program', 'JAVA', 'Paul J. Deitel',  'Prentice Hall','1999-12-10', 6, 600.00, 'A1', '2012-05-12', 'S01');


Insert into LMS_BOOK_DETAILS
Values('BL000006', 'Java: The Complete Reference ', 'JAVA', 'Herbert Schildt', 'Tata Mcgraw Hill ', '2011-10-10', 5, 750.00, 'A1','2012-05-12', 'S03');


Insert into LMS_BOOK_DETAILS
Values('BL000007', 'Let Us C', 'C', 'Yashavant Kanetkar ', 'BPB Publications', '2010-12-11',  9, 500.00 , 'A3', '2010-01-03','S03');


Insert into LMS_BOOK_DETAILS
Values('BL000008', 'Let Us C', 'C', 'Yashavant Kanetkar ','BPB Publications', '2010-12-11',  9, 500.00 , 'A3','2010-01-03', 'S04');


/* ** Insert values in table called LMS_BOOK_ISSUE ** */


Insert into LMS_BOOK_ISSUE
Values (001, 'LM001', 'BL000001',  '2012-05-01', '2012-05-16',   '2012-05-16' ,'N', 'R1');


Insert into LMS_BOOK_ISSUE
Values (002, 'LM002', 'BL000002',  '2012-04-20', '2012-05-06',  '2012-05-04' , 'N', 'R2');


Insert into LMS_BOOK_ISSUE
Values (003, 'LM003', 'BL000007',  '2012-04-01', ' 2012-04-16',  ' 2012-04-20' ,'Y','R1');


Insert into LMS_BOOK_ISSUE
Values (004, 'LM004', 'BL000005',  ' 2012-04-01', ' 2012-04-16' , ' 2012-04-20',  'Y', 'R1');


Insert into LMS_BOOK_ISSUE
Values (005, 'LM005', 'BL000008',  ' 2012-03-30' ,  ' 2012-04-15', ' 2012-04-20',  'N', 'R2');


select * from lms_book_details;

select * from lms_members;

select * from lms_book_issue;

select * from lms_suppliers_details;

select * from lms_fine_details;