import sqlite3

conn = sqlite3.connect('TestDB.db')
c = conn.cursor()

c.execute('''CREATE TABLE 'students' (
  'STUDENT_ID' text NOT NULL,
  'FATHER_NAME' varchar(100) NOT NULL,
  'MOTHER_NAME' varchar(100) NOT NULL,
  'EMAIL_ID' text NOT NULL UNIQUE,
  'CONTACT_NO' int(10) NOT NULL UNIQUE
);''')

c.execute('''INSERT INTO 'students' VALUES ('1234567898','Broderick','Guadalupe','gloria52@hotmail.com','70361292'),
('14375658BC','Sonny','Shakira','elena37@hotmail.com','75304386'),
('94375678EF','Omer','Mylene','weissnat.rafael@yahoo.com','98926527'),
('84335678GH','Dalton','Noemi','dbrakus@yahoo.com','88532233'),
('74335678HK','Manley','Layla','ihane@hotmail.com','21293139'),
('89335678LM','Madison','Linda','martin.cummings@gmail.com','43692354'),
('99935678PW','Crawford','Lavonne','kuvalis.rudy@hotmail.com','15102164'),
('89935678SV','Trent','Lily','stewart32@gmail.com','57176246'),
('69785678ZX','Orval','Lexi','kristin.schaden@gmail.com','81251605'),
('99999678XX','Michael','Joanie','trisha40@hotmail.com','50386642'),
('13335342','Brando','Laisha','mills.chris@yahoo.com','44784355'),
('65820964','Marshall','Ellen','trevion93@gmail.com','65382097'),
('56900507','Mitchel','Fleta','wkuhic@gmail.com','5060047'),
('99246907','Bud','Alisha','paucek.jackeline@yahoo.com','99146917'),
('06689919','Van','Astrid','bernhard.watson@hotmail.com','3144459'),
('29318445','Jeremy','Kaylie','reuben.stark@gmail.com','60749741'),
('82534929','Woodrow','Clementina','ebert.samir@hotmail.com','74890101'),
('50737376','Guiseppe','Ethyl','schumm.jacklyn@yahoo.com','80422532'),
('39446398','Marlin','Vivienne','annamarie43@gmail.com','78259294'),
('49336696','Lexus','Nedra','rhoda81@hotmail.com','17234634'),
('40627311','Joey','Kara','kaley.dibbert@hotmail.com','39735706'),
('64893815','Jace','Trycia','homenick.christ@gmail.com','28881209'),
('10874745','Humberto','Glenna','uschaden@yahoo.com','92508446'),
('97702023','Roderick','Dena','javon.feil@yahoo.com','70459067'),
('05496617','Cristina','Aliyah','joel.schuppe@gmail.com','98870622'),
('21199776','Bertrand','Bernita','sweimann@hotmail.com','11250852'),
('21201943','Morgan','Jackeline','victoria.west@yahoo.com','95807447'),
('00266628','Barrett','Stefanie','lkunze@hotmail.com','25403114'),
('57998589','Abel','Carlee','dlesch@gmail.com','54159945'),
('27792971','Ron','Whitney','wilburn.gibson@yahoo.com','10673737'),
('25663716','Pietro','Hellen','coralie65@yahoo.com','14544125'),
('16924949','Lafayette','Etha','morissette.loraine@hotmail.com','72408377'),
('20565909','Monserrate','Sally','preinger@yahoo.com','91562869'),
('68215705','Dangelo','Laisha','kautzer.wyman@hotmail.com','83557576'),
('35505457','Jacey','Claudia','rkovacek@gmail.com','79639101'),
('56076264','Harrison','Lucinda','erica90@yahoo.com','14932625'),
('04291879','Jasmin','Giovanna','albina37@hotmail.com','10316948'),
('70309003','Jayden','Rachelle','raina27@gmail.com','99567484'),
('81713530','Grayce','Ebony','demond.willms@hotmail.com','77750051'),
('34530740','Axel','Misty','dejuan85@hotmail.com','22124111'),
('32801644','Dean','Henriette','kian15@gmail.com','52582639'),
('93165020','Jedediah','Makenzie','kelly.wilderman@gmail.com','88267517'),
('78365803','Dell','Lavina','katharina.homenick@hotmail.com','55613118'),
('95471624','Mac','Dayna','major.homenick@gmail.com','47537392'),
('72977002','Vance','Maeve','carol.renner@hotmail.com','6865368'),
('25237139','Trevion','Novella','hilpert.hardy@yahoo.com','51149574'),
('96775592','Ryan','Greta','nia81@gmail.com','94609011'),
('71849799','Darion','Retha','macie.ernser@yahoo.com','88026510'),
('93836609','Nikolas','Lauretta','zullrich@hotmail.com','43884193'),
('93964203','Soledad','Tina','modesto26@gmail.com','48261388'),
('74896455','Edwardo','Lori','jameson00@hotmail.com','64676425'),
('48455985','Ole','Litzy','edward95@gmail.com','83586026'),
('74920785','Emmett','Opal','kaela.renner@yahoo.com','19380711'),
('80204671','Neal','Loraine','farrell.grady@hotmail.com','10884461'),
('93089784','Hugh','Felicita','euna59@gmail.com','18177008'),
('56751406','Bradford','Carlotta','akovacek@gmail.com','34134092'),
('11573159','Dimitri','Elda','vschulist@gmail.com','28481027'),
('62719896','Timothy','Alysa','lisandro.schmidt@hotmail.com','19254098'),
('60321381','Elliot','Melyna','fharris@gmail.com','37793531'),
('61533554','Jevon','Fay','nicholaus.pouros@hotmail.com','63804881'),
('67962693','Adonis','Alivia','hilll.lonzo@hotmail.com','95547480'),
('59142201','John','Litzy','zmarks@gmail.com','46012739'),
('56731163','Morris','Lilly','joanny.swaniawski@hotmail.com','36261109'),
('57738307','Monty','Aurelie','hayley.walker@gmail.com','15856876'),
('43424566','Carey','Vincenza','udaugherty@hotmail.com','48000260'),
('08387219','Jack','Magdalena','volson@yahoo.com','58323380'),
('71686264','Brady','Tara','wolf.sincere@gmail.com','22245564'),
('08764942','Woodrow','Noelia','corwin.serenity@gmail.com','53055408'),
('41327920','Elijah','Estel','maritza.koch@yahoo.com','59370710'),
('60175434','Weston','Madisyn','murray.mercedes@hotmail.com','23501171'),
('99728021','Nash','Dayana','mozell.ruecker@gmail.com','31052689'),
('80369455','Paris','Margot','mariana70@hotmail.com','46574855'),
('51438265','Madisen','Roma','schamberger.talia@hotmail.com','12615520'),
('10039809','Nathanial','Carolyne','krajcik.blaze@yahoo.com','15634504'),
('62676922','Doyle','Anabel','ggoodwin@hotmail.com','52891540'),
('64147376','Nicholas','Maryse','rowland.gaylord@yahoo.com','42193951'),
('12440108','Wyatt','Lyda','abeahan@gmail.com','23352537'),
('41457375','Hans','Piper','halvorson.amari@hotmail.com','45299049'),
('45443251','Ike','Carley','lamar86@hotmail.com','72533901'),
('20508869','Emmett','Kali','wilhelmine42@yahoo.com','79262729'),
('49558166','Khalil','Ethelyn','alf.abbott@yahoo.com','89075616'),
('34753866','Holden','Zora','saige65@yahoo.com','50953431'),
('09022539','Roman','Brandy','pete.turcotte@gmail.com','95604268'),
('00175227','Jeffry','Wanda','dbednar@yahoo.com','22397669'),
('35968559','Quentin','Eloise','mdenesik@gmail.com','77609793'),
('40872810','Cecil','Krista','ziemann.elisha@yahoo.com','88936666'),
('92985438','Virgil','Lura','edwin37@yahoo.com','21845147'),
('46625076','Elmo','Mariah','kayden.walter@gmail.com','96821930'),
('27758717','Odell','Abbie','cquitzon@yahoo.com','78337336'),
('73686965','Rafael','Rae','lsteuber@yahoo.com','71023113'),
('46250698','Emilio','Bridgette','yconn@yahoo.com','20990992'),
('98726288','Webster','Aida','chadrick55@yahoo.com','77214683'),
('32499704','Chad','Syble','runolfsson.mercedes@yahoo.com','33029610'),
('93683159','Elbert','Tracy','kilback.edythe@gmail.com','27608340'),
('84684882','Gianni','Lorine','slang@gmail.com','38276569'),
('20308933','Ali','Maryjane','lucius.stanton@yahoo.com','80792017'),
('70664720','Joey','Concepcion','trantow.katherine@gmail.com','42528357'),
('28647249','Vance','Marilou','bnitzsche@gmail.com','76676833'),
('52861383','Nick','Ernestine','gilbert92@yahoo.com','32588934'),
('1238626AB4','Nick Fury','Emma Watson','nick_fury69@gmail.com','68944123'),
('17694544','Gussie','Juanita','gabe87@hotmail.com','88522142');''')
conn.commit()