Insert.sql

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
*/