-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathInsert.sql
More file actions
173 lines (158 loc) · 12.4 KB
/
Insert.sql
File metadata and controls
173 lines (158 loc) · 12.4 KB
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
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
USE JigitalclouN
-- Insert into Master Table
INSERT INTO MsCustomer VALUES('JCN-C3101','Budi Budiman','Male','Budi_B@gmail.com','2000-12-31','085775001112','Jl. Melati 31 Jakarta Pusat')
INSERT INTO MsCustomer VALUES('JCN-C5101','Edwin Tjandra','Male','Edwin_T@gmail.com','2004-05-27','081213878890', 'Jl. Indiana 45 Bekasi Timur' )
INSERT INTO MsCustomer VALUES('JCN-C6101','Nelson Wijaya','Male','Nelson_W@gmail.com','1999-02-13','089872534116', 'Jl. Sui garden 07 Jakarta Barat')
INSERT INTO MsCustomer VALUES('JCN-C3201', 'Ellyn Felicia', 'Female', 'Ellyn_F@gmail.com', '2003-05-20','082567913068','Jl. Permata hijau 20 jakarta selatan' )
INSERT INTO MsCustomer VALUES('JCN-C4201','Tristan Jaya','Male','Tristan_J@gmail.com','2004-06-06','086248716580','Jl. Augh Indah 78 Bekasi Selatan')
INSERT INTO MsCustomer VALUES('JCN-C7201','Ivan Gemilang', 'Male','Ivan_G@gmail.com','1998-07-01','085782451006','Jl. Cempaka Lestari 09 Jakarta Utara')
INSERT INTO MsCustomer VALUES('JCN-C3111','Nicholas juang','Male','Nicholas_J@gmail.com','2003-09-12','083425681098','Jl. Pejuang 23 Tanggerang Selatan')
INSERT INTO MsCustomer VALUES('JCN-C5111','Angel Markus','Female','Angel_M@gmail.com','2004-08-20','089933557766','Jl. Kece Indah 18 Bandung')
INSERT INTO MsCustomer VALUES('JCN-C6111','Caroline Valen','Female','Caroline_V@gmail.com','2000-01-01','081214151617','Jl. Persahabatan 13 Bekasi Barat')
INSERT INTO MsCustomer VALUES('JCN-C3103','Vania Tendean','Female','Vania_T@gmail.com','1998-11-12','081984723377','Jl. Imperium Biru 07 Jakarta Barat')
INSERT INTO MsStaff VALUES('JCN-S3101','Muhammad Ali','Male','Ali@JCN.com','2003-10-31','085819500111','Jl. Surya Kencana 01 Jakarta Barat','5000000')
INSERT INTO MsStaff VALUES('JCN-S4112','Ronaldo Messi','Male','Ron@JCN.com','1997-12-12','0875639278457','Jl. Suka Pluto 09 Tanggerang Selatan','5500000' )
INSERT INTO MsStaff VALUES('JCN-S5112','Perem Puan','Female','Pua@JCN.com','1990-09-06','0837885266119','Jl. Perjuangan Damai Indah 25 Jakarta Utara','19000000')
INSERT INTO MsStaff VALUES('JCN-S6112','Ihsan Pratama','Male','Ihs@JCN.com','2003-10-09','0896527183766','Jl. Silang terang 90 Bekasi Timur', '9327000')
INSERT INTO MsStaff VALUES('JCN-S7112', 'Mary Grace', 'Female','Mar@JCN.com','2000-01-30','0965349379878', 'Jl. Duduk kursi 05 Bekasi Barat','7350000')
INSERT INTO MsStaff VALUES('JCN-S3201','Ludo Vany', 'Female', 'Lud@JCN.com','2000-02-20','08275430326705','Jl. Pisang Hijau 22 Jakarta Barat', '6750000')
INSERT INTO MsStaff VALUES('JCN-S4201','Erwin Yasri', 'Male', 'Erw@JCN.com', '1990-03-27','0826315830157', 'Jl. Pertama Kinclong 56 Jakarta Selatan', '19999999')
INSERT INTO MsStaff VALUES('JCN-S5201', 'Wanto Susono', 'Male', 'Wan@JCN.com','1989-04-28','0862236661125','Jl. Piutang Jaya 09 Jakarta Pusat','19999999')
INSERT INTO MsStaff VALUES('JCN-S6201', 'Annisa Budie' ,'Female','Ann@JCN.com','1999-09-09','0885198571436', 'Jl. Nikah Muda 49 Bekasi Selatan', '4500000')
INSERT INTO MsStaff VALUES('JCN-S7201', 'Bartholomew Hamish Montgomery', 'Male','Bar@JCN.com','2000-08-21', '0837210689257', 'Jl. Raya Jaya 04 Jakarta Selatan', '8800000')
INSERT INTO MsMemory VALUES('JCN-M3101','Hyperion HX7500','HY7500','1500000','16','3200')
INSERT INTO MsMemory VALUES('JCN-M3102', 'Kingston HyperX Fury DDR4', 'KH8500', '300000','16', '2400')
INSERT INTO MsMemory VALUES('JCN-M3103', 'Crucial MX500 SATA', 'CM9500', '1400000', '256', '3200')
INSERT INTO MsMemory VALUES('JCN-M3104', 'Seagate Barracuda SATA HDD', 'SB1000', '750000', '32', '4800')
INSERT INTO MsMemory VALUES('JCN-M3105', 'Team T-Force Delta RGB DDR4', 'TD1050', '1700000', '16', '1800')
INSERT INTO MsMemory VALUES('JCN-M3106', 'G.Skill Trident Z RGB DDR4 R', 'GT1150', '1000000', '32', '2400')
INSERT INTO MsMemory VALUES('JCN-M3107', 'Kingston A2000 NVMe SSD', 'KA1250', '2000000', '256', '4800')
INSERT INTO MsMemory VALUES('JCN-M3108', 'Western Digital Blue SATA', 'WD1350', '7000000','64', '3200')
INSERT INTO MsMemory VALUES('JCN-M3109', 'Adata XPG Spectrix D50 DDR4', 'AX1450', '4200000', '128', '2000')
INSERT INTO MsMemory VALUES('JCN-M3110', 'Corsair Vengeance LPX DDR4', 'CV1550', '1500000', '8', '4200' )
INSERT INTO MsProcessor VALUES('JCN-P3101','Intel Xeon Platinum 8380','BX807098380','142000000','2800','24')
INSERT INTO MsProcessor VALUES('JCN-P3102', 'AMD Ryzen 9', 'BR807098381', '14000000', '4800', '12')
INSERT INTO MsProcessor VALUES('JCN-P3103', 'Qualcomm Snapdragon', 'BQ807098382', '10000000', '2400', '18')
INSERT INTO MsProcessor VALUES('JCN-P3104', 'Apple A14 Bionic', 'BA807098383', '6000000', '5200', '8')
INSERT INTO MsProcessor VALUES('JCN-P3105', 'NVIDIA GeForce RTX 3080', 'BN807098384', '18000000', '1800', '24')
INSERT INTO MsProcessor VALUES('JCN-P3106', 'Intel Core i7', 'BI807098385', '14000000', '3200', '18')
INSERT INTO MsProcessor VALUES('JCN-P3107', 'AMD Ryzen 7', 'BY807098386', '10000000', '4600', '24')
INSERT INTO MsProcessor VALUES('JCN-P3108', 'AMD Ryzen Threadripper', 'BZ807098387', '15000000', '5000', '8')
INSERT INTO MsProcessor VALUES('JCN-P3109', 'Intel Xeon W', 'BE807098388', '52000000', '1800', '24')
INSERT INTO MsProcessor VALUES('JCN-P3110', 'Apple M1', 'BP807098386', '8000000', '2800', '16')
INSERT INTO MsLocation VALUES('JCN-L3101','New York City','United States','10001','40.712776','-74.005974')
INSERT INTO MsLocation VALUES('JCN-L3102','Paris','France','75000','48.856613','2.352222')
INSERT INTO MsLocation VALUES('JCN-L3103','Sydney','Australia','2000','-33.867850','151.207316')
INSERT INTO MsLocation VALUES('JCN-L3104','Mumbai','India','400001','19.076000','72.877700')
INSERT INTO MsLocation VALUES('JCN-L3105','Beijing','China','100000','39.904200','116.407400')
INSERT INTO MsLocation VALUES('JCN-L3106','Bangkok','Thailand','10100','13.756300','100.501800')
INSERT INTO MsLocation VALUES('JCN-L3107','Istanbul','Turkey','34000','41.008200','28.978400')
INSERT INTO MsLocation VALUES('JCN-L3108','Jakarta','Indonesia','10210','-6.214600','106.845100')
INSERT INTO MsLocation VALUES('JCN-L3109','Seoul','South Korea','04524','37.566535','126.977969')
INSERT INTO MsLocation VALUES('JCN-L3110','Kuala Lumpur','Malaysia','50000','3.139003','101.686855')
INSERT INTO MsServer VALUES('JCN-V3101','JCN-M3101','JCN-L3101','JCN-P3101','145000000')
INSERT INTO MsServer VALUES('JCN-V3102','JCN-M3102','JCN-L3102','JCN-P3102','143000000')
INSERT INTO MsServer VALUES('JCN-V3103','JCN-M3103','JCN-L3103','JCN-P3103','120000000')
INSERT INTO MsServer VALUES('JCN-V3104','JCN-M3104','JCN-L3104','JCN-P3104','700000000')
INSERT INTO MsServer VALUES('JCN-V3105','JCN-M3105','JCN-L3105','JCN-P3105','197000000')
INSERT INTO MsServer VALUES('JCN-V3106','JCN-M3106','JCN-L3106','JCN-P3106','150000000')
INSERT INTO MsServer VALUES('JCN-V3107','JCN-M3107','JCN-L3107','JCN-P3107','130000000')
INSERT INTO MsServer VALUES('JCN-V3108','JCN-M3108','JCN-L3108','JCN-P3108','220000000')
INSERT INTO MsServer VALUES('JCN-V3109','JCN-M3109','JCN-L3109','JCN-P3109','567000000')
INSERT INTO MsServer VALUES('JCN-V3110','JCN-M3110','JCN-L3110','JCN-P3110','950000000')
/*
SELECT * FROM MsServer
SELECT * FROM MsLocation
SELECT * FROM MsMemory
SELECT * FROM MsProcessor
SELECT * FROM MsStaff
SELECT * FROM MsCustomer
*/
-- Insert into Transaction table
INSERT INTO TrRental VALUES('JCN-R0101','JCN-C3111','JCN-S4112','2012-01-12',32)
INSERT INTO TrRental VALUES('JCN-R0102','JCN-C6101','JCN-S3101','2012-02-01',12)
INSERT INTO TrRental VALUES('JCN-R0103','JCN-C3101','JCN-S6112','2013-02-28',24)
INSERT INTO TrRental VALUES('JCN-R0104','JCN-C3103','JCN-S7112','2013-03-14',48)
INSERT INTO TrRental VALUES('JCN-R0105','JCN-C5111','JCN-S3201','2014-12-12',12)
INSERT INTO TrRental VALUES('JCN-R0106','JCN-C6111','JCN-S5112','2014-09-12',27)
INSERT INTO TrRental VALUES('JCN-R0107','JCN-C4201','JCN-S3201','2015-04-09',60)
INSERT INTO TrRental VALUES('JCN-R0108','JCN-C3201','JCN-S4201','2015-07-12',12)
INSERT INTO TrRental VALUES('JCN-R0109','JCN-C5101','JCN-S5201','2016-10-09',24)
INSERT INTO TrRental VALUES('JCN-R0110','JCN-C3101','JCN-S6201','2017-05-29',30)
INSERT INTO TrRental VALUES('JCN-R0111','JCN-C5101','JCN-S7201','2017-08-17',45)
INSERT INTO TrRental VALUES('JCN-R0112','JCN-C6101','JCN-S3201','2018-01-31',12)
INSERT INTO TrRental VALUES('JCN-R0113','JCN-C5101','JCN-S4112','2019-05-09',36)
INSERT INTO TrRental VALUES('JCN-R0114','JCN-C7201','JCN-S3101','2020-05-02',10)
INSERT INTO TrRental VALUES('JCN-R0115','JCN-C5111','JCN-S4112','2020-11-11',6)
INSERT INTO TrSales VALUES('JCN-S0101','JCN-C3111','JCN-S4112','2015-01-12')
INSERT INTO TrSales VALUES('JCN-S0102','JCN-C6101','JCN-S3101','2015-08-01')
INSERT INTO TrSales VALUES('JCN-S0103','JCN-C3101','JCN-S6112','2021-06-25')
INSERT INTO TrSales VALUES('JCN-S0104','JCN-C3103','JCN-S7112','2021-11-03')
INSERT INTO TrSales VALUES('JCN-S0105','JCN-C5111','JCN-S3201','2012-07-21')
INSERT INTO TrSales VALUES('JCN-S0106','JCN-C6111','JCN-S5112','2013-06-30')
INSERT INTO TrSales VALUES('JCN-S0107','JCN-C4201','JCN-S3201','2021-01-12')
INSERT INTO TrSales VALUES('JCN-S0108','JCN-C3201','JCN-S4201','2022-10-10')
INSERT INTO TrSales VALUES('JCN-S0109','JCN-C5101','JCN-S5201','2017-09-13')
INSERT INTO TrSales VALUES('JCN-S0110','JCN-C3101','JCN-S6201','2021-01-12')
INSERT INTO TrSales VALUES('JCN-S0111','JCN-C5101','JCN-S7201','2023-01-10')
INSERT INTO TrSales VALUES('JCN-S0112','JCN-C6101','JCN-S3201','2020-10-10')
INSERT INTO TrSales VALUES('JCN-S0113','JCN-C5101','JCN-S4112','2013-01-21')
INSERT INTO TrSales VALUES('JCN-S0114','JCN-C7201','JCN-S3101','2021-05-17')
INSERT INTO TrSales VALUES('JCN-S0115','JCN-C5111','JCN-S4112','2021-09-02')
-- insert into transaction detail table
INSERT INTO TrRentalDetail VALUES('JCN-R0101','JCN-V3101')
INSERT INTO TrRentalDetail VALUES('JCN-R0101','JCN-V3102')
INSERT INTO TrRentalDetail VALUES('JCN-R0102','JCN-V3103')
INSERT INTO TrRentalDetail VALUES('JCN-R0102','JCN-V3104')
INSERT INTO TrRentalDetail VALUES('JCN-R0103','JCN-V3105')
INSERT INTO TrRentalDetail VALUES('JCN-R0103','JCN-V3106')
INSERT INTO TrRentalDetail VALUES('JCN-R0104','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0104','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0105','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0105','JCN-V3110')
INSERT INTO TrRentalDetail VALUES('JCN-R0106','JCN-V3101')
INSERT INTO TrRentalDetail VALUES('JCN-R0106','JCN-V3102')
INSERT INTO TrRentalDetail VALUES('JCN-R0107','JCN-V3103')
INSERT INTO TrRentalDetail VALUES('JCN-R0107','JCN-V3104')
INSERT INTO TrRentalDetail VALUES('JCN-R0108','JCN-V3105')
INSERT INTO TrRentalDetail VALUES('JCN-R0108','JCN-V3106')
INSERT INTO TrRentalDetail VALUES('JCN-R0109','JCN-V3107')
INSERT INTO TrRentalDetail VALUES('JCN-R0109','JCN-V3108')
INSERT INTO TrRentalDetail VALUES('JCN-R0110','JCN-V3109')
INSERT INTO TrRentalDetail VALUES('JCN-R0111','JCN-V3110')
INSERT INTO TrRentalDetail VALUES('JCN-R0112','JCN-V3101')
INSERT INTO TrRentalDetail VALUES('JCN-R0113','JCN-V3102')
INSERT INTO TrRentalDetail VALUES('JCN-R0114','JCN-V3103')
INSERT INTO TrRentalDetail VALUES('JCN-R0115','JCN-V3104')
INSERT INTO TrRentalDetail VALUES('JCN-R0115','JCN-V3105')
INSERT INTO TrSalesDetail VALUES('JCN-S0101','JCN-V3110')
INSERT INTO TrSalesDetail VALUES('JCN-S0101','JCN-V3109')
INSERT INTO TrSalesDetail VALUES('JCN-S0102','JCN-V3108')
INSERT INTO TrSalesDetail VALUES('JCN-S0102','JCN-V3107')
INSERT INTO TrSalesDetail VALUES('JCN-S0103','JCN-V3106')
INSERT INTO TrSalesDetail VALUES('JCN-S0103','JCN-V3105')
INSERT INTO TrSalesDetail VALUES('JCN-S0104','JCN-V3104')
INSERT INTO TrSalesDetail VALUES('JCN-S0104','JCN-V3103')
INSERT INTO TrSalesDetail VALUES('JCN-S0105','JCN-V3102')
INSERT INTO TrSalesDetail VALUES('JCN-S0105','JCN-V3101')
INSERT INTO TrSalesDetail VALUES('JCN-S0106','JCN-V3110')
INSERT INTO TrSalesDetail VALUES('JCN-S0106','JCN-V3109')
INSERT INTO TrSalesDetail VALUES('JCN-S0107','JCN-V3108')
INSERT INTO TrSalesDetail VALUES('JCN-S0107','JCN-V3107')
INSERT INTO TrSalesDetail VALUES('JCN-S0108','JCN-V3106')
INSERT INTO TrSalesDetail VALUES('JCN-S0108','JCN-V3105')
INSERT INTO TrSalesDetail VALUES('JCN-S0109','JCN-V3104')
INSERT INTO TrSalesDetail VALUES('JCN-S0109','JCN-V3103')
INSERT INTO TrSalesDetail VALUES('JCN-S0110','JCN-V3102')
INSERT INTO TrSalesDetail VALUES('JCN-S0111','JCN-V3101')
INSERT INTO TrSalesDetail VALUES('JCN-S0112','JCN-V3110')
INSERT INTO TrSalesDetail VALUES('JCN-S0113','JCN-V3109')
INSERT INTO TrSalesDetail VALUES('JCN-S0114','JCN-V3108')
INSERT INTO TrSalesDetail VALUES('JCN-S0115','JCN-V3107')
INSERT INTO TrSalesDetail VALUES('JCN-S0115','JCN-V3106')
/*
SELECT * FROM TrRental
SELECT * FROM TrRentalDetail
SELECT * FROM TrSales
SELECT * FROM TrSalesDetail
*/