API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 5th, 2019
177
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 65.97 KB | None | 0 0
raw download clone embed print report
  1. use project;
  2. -- MySQL Workbench Forward Engineering
  3.  
  4. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  5. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  6. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
  7.  
  8. -- -----------------------------------------------------
  9. -- Schema project
  10. -- -----------------------------------------------------
  11. DROP SCHEMA IF EXISTS `project` ;
  12.  
  13. -- -----------------------------------------------------
  14. -- Schema project
  15. -- -----------------------------------------------------
  16.  
  17. Create DataBase if not exists project;
  18. USE `project` ;
  19.  
  20. -- -----------------------------------------------------
  21. -- Table `project`.`Person`
  22. -- -----------------------------------------------------
  23.  
  24. CREATE TABLE person (
  25.   personID mediumint,
  26.   FName varchar(255) default NULL,
  27.   LName varchar(255) default NULL,
  28.   Gender varchar(255) default NULL,
  29.   StreetAddress varchar(255) default NULL,
  30.   Phone varchar(100) default NULL,
  31.   Email varchar(255) default NULL,
  32.   PRIMARY KEY (personID)
  33. );
  34. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (1,"Karleigh","Bright","M","5136 Pretium Avenue","(705) 935-8781","nec.urna.suscipit@scelerisque.edu");
  35. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (2,"Yardley","Fischer","M","448-8439 Gravida Street","(884) 430-0762","at@arcuvel.net");
  36. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (3,"Gloria","Maynard","F","P.O. Box 981, 7046 Mus. Ave","(135) 154-3652","euismod.urna@Vivamussit.ca");
  37. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (4,"Stewart","Parsons","M","517-9268 Proin Road","(169) 843-5948","vel@arcuVestibulumante.org");
  38. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (5,"Heather","Shelton","F","5089 Rhoncus St.","(694) 702-3223","elit.pede.malesuada@pharetrafelis.co.uk");
  39. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (6,"Nomlanga","Mcguire","F","4407 Aliquet St.","(555) 141-3324","mauris@mi.edu");
  40. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (7,"Inez","Hyde","F","P.O. Box 116, 5738 Ullamcorper St.","(197) 673-1798","ipsum.sodales@scelerisquesed.ca");
  41. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (8,"Fatima","Holland","F","Ap #345-8833 Aliquam St.","(821) 760-6516","lobortis@malesuada.org");
  42. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (9,"Martha","Bolton","M","P.O. Box 227, 9062 Et Av.","(549) 990-2265","lobortis.nisi@liberoProin.net");
  43. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (10,"Fritz","Odonnell","M","P.O. Box 364, 689 Integer St.","(602) 510-3952","non.lorem.vitae@ipsum.net");
  44. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (11,"Nicholas","Conway","F","P.O. Box 288, 8761 In Av.","(416) 652-8838","mauris@gravidanuncsed.org");
  45. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (12,"Rigel","Bauer","M","Ap #805-1120 Nunc. Rd.","(450) 737-6365","vitae@lorem.net");
  46. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (13,"Blake","Wolfe","M","Ap #650-7395 Rhoncus. St.","(593) 673-2936","ut.ipsum@dolorQuisque.co.uk");
  47. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (14,"Colette","Fleming","F","4179 Suspendisse St.","(652) 330-7575","a.magna@malesuada.edu");
  48. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (15,"Grady","Floyd","M","P.O. Box 444, 1561 Purus St.","(290) 478-1082","auctor.odio@nisl.org");
  49. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (16,"Morgan","Norton","M","872-6202 Tristique St.","(841) 360-5059","luctus.et.ultrices@senectus.ca");
  50. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (17,"Boris","Best","M","P.O. Box 351, 3116 Elit Ave","(384) 857-5633","Vivamus@sed.org");
  51. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (18,"Lysandra","Pacheco","F","P.O. Box 220, 8514 Lectus. Avenue","(613) 626-4943","eu@ipsumSuspendissesagittis.co.uk");
  52. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (19,"Ferris","Morse","F","682-2819 Ultricies Road","(559) 282-9370","eu.metus@sitametconsectetuer.com");
  53. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (20,"Amery","Downs","M","8812 Mauris Street","(862) 656-2094","amet.consectetuer.adipiscing@Etiam.net");
  54. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (21,"Ali","Velasquez","F","Ap #627-1617 Ante. Rd.","(124) 381-1025","pharetra.Quisque.ac@egestasblandit.ca");
  55. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (22,"Suki","Sosa","F","Ap #322-2465 Congue Road","(884) 920-0070","hendrerit.Donec.porttitor@egestasrhoncusProin.org");
  56. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (23,"Pandora","Fitzpatrick","M","6175 In Ave","(756) 918-6948","lobortis.augue@dictumaugue.ca");
  57. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (24,"Doris","Garner","M","Ap #888-5841 Ornare. Ave","(470) 796-4023","ullamcorper.velit@Integerin.com");
  58. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (25,"Cameran","Goodwin","M","3929 Tincidunt Ave","(454) 606-0677","dictum.augue.malesuada@consectetueradipiscing.co.uk");
  59. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (26,"Alyssa","Duncan","M","Ap #499-6628 Proin Street","(556) 212-4617","Cras.pellentesque.Sed@tristiquepharetraQuisque.net");
  60. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (27,"Beau","Booker","F","Ap #693-7039 Et, St.","(606) 222-2159","Suspendisse@mus.edu");
  61. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (28,"Wyoming","Navarro","F","339-645 Congue Road","(472) 469-2948","litora@ligula.ca");
  62. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (29,"Hashim","Sawyer","M","390 Dui, Road","(201) 883-6585","Nulla.facilisi.Sed@enimEtiam.org");
  63. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (30,"Randall","Banks","M","2521 Luctus Rd.","(919) 446-7104","urna.nec.luctus@sagittisfelisDonec.org");
  64. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (31,"Harrison","Kerr","F","9803 Et Avenue","(103) 976-7228","Suspendisse@suscipit.net");
  65. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (32,"Isaac","Mcguire","F","Ap #667-8510 Parturient Av.","(712) 825-1833","ornare@parturientmontes.edu");
  66. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (33,"Jamal","Knox","M","Ap #943-3570 Velit. St.","(825) 752-2839","turpis.non.enim@sociisnatoquepenatibus.com");
  67. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (34,"Leila","Dale","M","P.O. Box 225, 759 Sed St.","(552) 908-2354","ridiculus@pedenecante.co.uk");
  68. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (35,"Steven","Chandler","M","4248 Cras Av.","(626) 233-4791","Duis.elementum.dui@dictumPhasellusin.edu");
  69. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (36,"Wyatt","Davis","M","278-6335 Turpis St.","(514) 528-2492","Nunc@mollis.edu");
  70. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (37,"Katelyn","Ball","M","5732 Mauris Ave","(239) 118-8736","est.vitae.sodales@adipiscing.org");
  71. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (38,"Alvin","Greer","F","P.O. Box 333, 9811 Sed Road","(257) 661-9412","id.libero.Donec@velit.com");
  72. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (39,"Quintessa","Perkins","F","4136 Eu Av.","(480) 617-3319","Donec@lobortis.co.uk");
  73. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (40,"Charde","Humphrey","M","Ap #432-640 Lorem Rd.","(467) 265-1533","egestas.urna.justo@sitamet.ca");
  74. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (41,"Yolanda","Rocha","M","P.O. Box 204, 6643 Mattis St.","(333) 492-9679","libero.est.congue@gravidamaurisut.edu");
  75. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (42,"Fiona","Pena","F","365-212 In Road","(167) 681-5475","vitae.aliquam@nuncest.ca");
  76. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (43,"Bell","Ramirez","F","9799 Enim Rd.","(325) 812-6314","et.commodo@netus.edu");
  77. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (44,"Benjamin","Evans","F","8671 Mauris, Rd.","(227) 460-4366","odio@mattisornare.ca");
  78. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (45,"Jermaine","Massey","M","Ap #471-1687 Ligula. Av.","(551) 160-1335","sapien.gravida.non@dui.edu");
  79. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (46,"Henry","Hyde","M","P.O. Box 718, 4739 Suspendisse Road","(991) 252-5162","aliquet.lobortis.nisi@sollicitudina.edu");
  80. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (47,"Winifred","Roach","F","3239 Suspendisse Avenue","(461) 866-9367","dictum@porttitortellus.net");
  81. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (48,"Carl","Galloway","F","4419 Massa. St.","(446) 938-5992","Donec@dictumeueleifend.edu");
  82. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (49,"Castor","Rivers","F","5785 Amet St.","(952) 215-9086","vel.arcu.Curabitur@intempuseu.co.uk");
  83. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (50,"Adam","Soto","F","1193 Odio Road","(137) 674-8092","Mauris.ut.quam@eratvolutpatNulla.co.uk");
  84. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (51,"Austin","Paul","M","1116 Eleifend Rd.","(522) 158-9556","habitant.morbi@elitpedemalesuada.org");
  85. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (52,"Stephanie","Mccray","M","4180 Non Street","(829) 249-6528","a.nunc@Proin.co.uk");
  86. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (53,"Candice","Johns","M","P.O. Box 778, 9738 Purus, Road","(851) 541-9550","fringilla.cursus@utmi.net");
  87. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (54,"Philip","Mckinney","M","P.O. Box 644, 5595 Porttitor St.","(465) 188-8499","vulputate.ullamcorper@quis.co.uk");
  88. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (55,"Clark","Owen","F","P.O. Box 167, 5369 Viverra. St.","(929) 132-8602","velit@Nullam.org");
  89. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (56,"Brady","Manning","M","1740 Curabitur Av.","(916) 443-2902","arcu.Vivamus@in.co.uk");
  90. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (57,"Tashya","Banks","M","P.O. Box 880, 655 Nec Rd.","(150) 208-7881","non.ante.bibendum@diam.co.uk");
  91. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (58,"Alec","Sherman","M","9756 Magna St.","(737) 321-7168","ligula@SuspendisseduiFusce.ca");
  92. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (59,"Nolan","Ayers","F","Ap #996-346 Cras Road","(872) 267-6422","erat@iaculisquispede.org");
  93. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (60,"Bevis","Hester","F","P.O. Box 473, 2950 Neque Rd.","(140) 477-9498","mauris.erat@Morbi.net");
  94. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (61,"Fitzgerald","Bowen","M","P.O. Box 802, 7254 Aliquet, Av.","(594) 661-0613","sollicitudin@nequeNullamnisl.net");
  95. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (62,"Rafael","Clemons","M","751-9448 Metus Road","(241) 851-3235","vel.lectus.Cum@auctorMaurisvel.co.uk");
  96. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (63,"Janna","Knight","M","511-4875 Nisl. St.","(712) 720-2673","consequat@eterosProin.net");
  97. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (64,"Maggie","Sanders","F","664-3685 Felis St.","(811) 960-7560","lorem@metus.edu");
  98. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (65,"Tobias","Lynn","F","757-2535 Dictum Street","(335) 599-4879","malesuada@purus.co.uk");
  99. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (66,"Eaton","Sosa","M","239-5237 Nulla Ave","(563) 694-6458","egestas.urna@euismodmauriseu.net");
  100. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (67,"Adam","Little","M","Ap #837-187 Mauris, St.","(927) 946-6885","elit@senectusetnetus.org");
  101. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (68,"Quail","Gardner","F","Ap #268-4396 Fusce Road","(781) 256-8081","Nunc.pulvinar.arcu@luctus.com");
  102. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (69,"Dolan","Tucker","M","P.O. Box 928, 3595 Quisque Street","(464) 198-1314","magna@PhasellusnullaInteger.org");
  103. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (70,"Jin","Ward","M","359-807 Tincidunt St.","(798) 162-7826","tellus.Aenean.egestas@mattis.net");
  104. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (71,"Sean","Payne","M","P.O. Box 287, 7816 Lacinia Ave","(354) 553-1837","netus.et@odioAliquam.org");
  105. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (72,"Roanna","Ryan","M","1993 Integer St.","(920) 811-0466","non@ullamcorpervelit.com");
  106. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (73,"Brody","Carter","F","755 Nec Rd.","(329) 209-2445","Integer.mollis.Integer@semper.edu");
  107. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (74,"Chantale","Craig","F","P.O. Box 204, 5630 Ultrices Street","(693) 285-3416","Aenean@accumsaninterdum.edu");
  108. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (75,"Fay","Burgess","F","P.O. Box 911, 838 Eleifend. Av.","(334) 745-0849","Quisque.tincidunt@Sed.org");
  109. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (76,"Hyacinth","Hewitt","M","P.O. Box 385, 6404 Vehicula Avenue","(142) 535-2332","vitae@sollicitudinorcisem.com");
  110. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (77,"Wynne","Hill","F","Ap #414-2731 Placerat, Ave","(804) 950-3211","magnis.dis.parturient@fringillami.net");
  111. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (78,"Mara","Wood","M","Ap #436-5205 Et Street","(657) 497-2096","sit.amet@Curabiturconsequatlectus.com");
  112. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (79,"Marny","Orr","F","Ap #712-9616 Nisi Street","(758) 221-1619","neque.tellus@egetvolutpatornare.co.uk");
  113. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (80,"Chase","Haney","F","Ap #889-2223 Feugiat Av.","(207) 196-2352","sed@vestibulum.net");
  114. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (81,"Gregory","Good","F","P.O. Box 453, 7302 Odio. Rd.","(312) 974-0427","enim@Inscelerisquescelerisque.com");
  115. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (82,"Xenos","Walter","M","666-1283 Auctor, Street","(485) 243-5816","semper.erat.in@sapien.co.uk");
  116. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (83,"Keaton","Watts","M","P.O. Box 966, 2199 Consequat Rd.","(452) 828-9435","metus@placeratCrasdictum.ca");
  117. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (84,"Cara","Trevino","M","Ap #267-8653 Risus. Road","(874) 477-0349","ligula@atvelitPellentesque.edu");
  118. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (85,"Amir","Parker","M","P.O. Box 936, 4725 Mus. St.","(965) 940-9435","pede@velitinaliquet.ca");
  119. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (86,"Leah","Ray","F","656-9028 Dis Av.","(562) 415-5681","et.pede@velconvallisin.edu");
  120. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (87,"Clarke","Whitfield","M","399-3297 Faucibus Rd.","(587) 973-1462","erat.Sed@Nunc.com");
  121. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (88,"Brady","Ingram","F","Ap #709-6153 Neque. Avenue","(617) 867-3749","fermentum.metus.Aenean@rhoncusNullamvelit.com");
  122. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (89,"Fuller","Moore","F","P.O. Box 677, 6762 Nullam Rd.","(871) 587-3288","est@DuisgravidaPraesent.ca");
  123. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (90,"Channing","Head","F","732-190 Erat Rd.","(153) 407-5132","faucibus.id@Aeneaneuismodmauris.com");
  124. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (91,"Hunter","Jackson","F","P.O. Box 233, 2575 Erat Rd.","(104) 441-6023","auctor.Mauris@et.edu");
  125. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (92,"Kirsten","Macdonald","M","718-3750 Imperdiet Road","(509) 542-6094","mauris.id@In.com");
  126. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (93,"Sophia","Bryant","M","Ap #531-7768 Montes, Street","(818) 921-1841","senectus@aauctornon.edu");
  127. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (94,"Idola","Rosa","F","P.O. Box 863, 6687 Lacus. St.","(403) 355-8174","ac.risus.Morbi@Mauris.net");
  128. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (95,"Hayes","Clay","M","Ap #943-6573 Molestie Road","(933) 152-3780","ullamcorper.velit@Cumsociis.org");
  129. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (96,"Indigo","Lopez","M","543-1859 Molestie Street","(774) 692-6011","sem.Pellentesque@magnaSed.com");
  130. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (97,"Curran","Ratliff","F","7423 Natoque St.","(290) 524-0334","ante.dictum@eu.org");
  131. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (98,"Lysandra","Herrera","M","746-8525 Dictum Rd.","(690) 745-8243","erat.semper.rutrum@convallisest.org");
  132. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (99,"Caldwell","Berg","M","8578 Neque St.","(162) 289-9486","Phasellus@tincidunt.org");
  133. INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (100,"John","Grant","M","166-9079 Aenean Ave","(133) 694-2434","cursus.luctus@montesnascetur.net");
  134. -- Table `project`.`Student`
  135. -- -----------------------------------------------------
  136. select* from person;
  137.  
  138. CREATE TABLE Student (
  139.   StudentID mediumint,
  140.   Major varchar(255) default NULL,
  141.   GPA mediumint default NULL,
  142.   Grad_year varchar(255),
  143.   honors_YorN varchar(255) default NULL,
  144.   personID mediumint,
  145.   PRIMARY KEY (StudentID),
  146.     constraint stuID FOREIGN KEY (personID) REFERENCES person(personID)
  147.     );
  148.    
  149.  
  150. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (1,"Finances",3,"25/10/2019","Y");
  151. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (2,"Computer Science",3,"28/10/2019","Y");
  152. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (3,"Management",4,"20/01/2018","N");
  153. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (4,"Computer Science",1,"28/01/2019","Y");
  154. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (5,"Law",1,"17/11/2018","N");
  155. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (6,"Computer Science",3,"27/05/2018","N");
  156. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (7,"Accounting",4,"05/10/2018","N");
  157. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (8,"Management",4,"09/12/2018","Y");
  158. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (9,"Finances",3,"21/09/2018","N");
  159. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (10,"Computer Science",1,"21/07/2018","Y");
  160. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (11,"Finances",3,"19/01/2019","N");
  161. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (12,"Accounting",2,"30/12/2018","N");
  162. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (13,"Accounting",4,"26/04/2019","Y");
  163. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (14,"Law",2,"09/11/2018","Y");
  164. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (15,"Accounting",3,"28/03/2019","N");
  165. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (16,"Accounting",4,"31/08/2018","N");
  166. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (17,"Computer Science",3,"01/06/2019","N");
  167. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (18,"Management",3,"03/10/2018","N");
  168. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (19,"Law",1,"26/05/2018","N");
  169. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (20,"Accounting",2,"17/05/2018","N");
  170. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (21,"Law",3,"26/04/2018","N");
  171. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (22,"Accounting",3,"11/01/2019","N");
  172. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (23,"Computer Science",3,"17/06/2019","Y");
  173. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (24,"Computer Science",2,"25/12/2018","N");
  174. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (25,"Finances",4,"27/06/2018","Y");
  175. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (26,"Management",2,"28/05/2019","Y");
  176. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (27,"Law",4,"27/06/2019","N");
  177. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (28,"Accounting",3,"09/11/2018","Y");
  178. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (29,"Computer Science",3,"09/11/2018","N");
  179. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (30,"Management",4,"06/12/2017","N");
  180. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (31,"Accounting",3,"07/05/2018","N");
  181. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (32,"Computer Science",1,"17/06/2019","Y");
  182. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (33,"Finances",2,"12/12/2018","N");
  183. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (34,"Computer Science",4,"10/12/2017","Y");
  184. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (35,"Computer Science",2,"10/09/2018","N");
  185. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (36,"Management",4,"29/04/2019","Y");
  186. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (37,"Accounting",2,"18/09/2018","N");
  187. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (38,"Computer Science",2,"28/08/2019","Y");
  188. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (39,"Management",1,"25/04/2019","N");
  189. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (40,"Computer Science",1,"27/09/2018","Y");
  190. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (41,"Accounting",2,"27/08/2019","N");
  191. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (42,"Management",2,"02/12/2017","Y");
  192. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (43,"Accounting",2,"19/07/2018","N");
  193. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (44,"Finances",4,"26/07/2018","N");
  194. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (45,"Management",3,"01/07/2018","Y");
  195. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (46,"Computer Science",4,"15/03/2019","N");
  196. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (47,"Law",4,"10/03/2019","Y");
  197. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (48,"Finances",1,"14/10/2018","Y");
  198. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (49,"Law",1,"13/11/2018","N");
  199. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (50,"Law",2,"13/08/2019","N");
  200. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (51,"Computer Science",4,"21/02/2019","Y");
  201. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (52,"Accounting",3,"23/09/2018","N");
  202. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (53,"Management",3,"06/11/2019","N");
  203. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (54,"Finances",3,"17/11/2017","N");
  204. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (55,"Finances",2,"31/12/2018","Y");
  205. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (56,"Finances",1,"13/04/2018","Y");
  206. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (57,"Management",3,"17/08/2019","Y");
  207. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (58,"Finances",2,"05/11/2018","N");
  208. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (59,"Accounting",3,"18/01/2018","N");
  209. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (60,"Finances",3,"17/09/2019","N");
  210. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (61,"Accounting",1,"21/09/2018","Y");
  211. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (62,"Accounting",3,"22/05/2019","N");
  212. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (63,"Computer Science",4,"26/07/2018","N");
  213. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (64,"Law",3,"17/11/2018","N");
  214. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (65,"Accounting",4,"07/06/2018","Y");
  215. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (66,"Law",1,"20/10/2018","Y");
  216. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (67,"Law",2,"28/07/2018","N");
  217. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (68,"Accounting",4,"28/11/2018","Y");
  218. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (69,"Management",4,"21/06/2019","N");
  219. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (70,"Computer Science",2,"18/05/2018","N");
  220. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (71,"Finances",3,"02/01/2018","N");
  221. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (72,"Accounting",4,"03/05/2018","N");
  222. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (73,"Law",2,"01/09/2019","N");
  223. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (74,"Finances",3,"27/06/2018","N");
  224. INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (75,"Law",4,"25/01/2019","Y");
  225.  
  226.  
  227. -- -----------------------------------------------------
  228. -- Table `project`.`Mentor`
  229. -- -----------------------------------------------------
  230.  
  231. CREATE TABLE Mentor (
  232.   mentorID mediumint,
  233.   highest_degree VARCHAR(100) default NULL,
  234.   business VARCHAR(200) default NULL,
  235.   positions VARCHAR(200) default NULL,
  236.   personID mediumint,
  237.   PRIMARY KEY (mentorID),
  238.     constraint mentID FOREIGN KEY (personID) REFERENCES person(personID)
  239.  
  240.     )
  241. ENGINE = InnoDB;
  242. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (76,"phD","Advising","Associated");
  243. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (77,"Bachelor","Accounting","PartTime");
  244. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (78,"Bachelor","Advising","PartTime");
  245. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (79,"phD","Accounting","FullTime");
  246. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (80,"phD","Mathematics","PartTime");
  247. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (81,"phD","Accounting","Associated");
  248. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (82,"Bachelor","Mathematics","FullTime");
  249. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (83,"phD","ComputerScience","FullTime");
  250. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (84,"Bachelor","ComputerScience","PartTime");
  251. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (85,"Master","ComputerScience","PartTime");
  252. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (86,"Bachelor","Advising","PartTime");
  253. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (87,"Master","Mathematics","Associated");
  254. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (88,"Bachelor","Mathematics","Associated");
  255. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (89,"phD","ComputerScience","PartTime");
  256. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (90,"phD","Mathematics","PartTime");
  257. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (91,"phD","Advising","Associated");
  258. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (92,"Master","Mathematics","FullTime");
  259. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (93,"Bachelor","Accounting","FullTime");
  260. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (94,"Master","Advising","PartTime");
  261. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (95,"Bachelor","Advising","Associated");
  262. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (96,"Master","Advising","FullTime");
  263. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (97,"Master","ComputerScience","FullTime");
  264. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (98,"Master","ComputerScience","PartTime");
  265. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (99,"phD","Accounting","PartTime");
  266. INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (100,"phD","Accounting","Associated");
  267. -- -----------------------------------------------------
  268. -- Table `project`.`Assign`
  269. -- -----------------------------------------------------
  270.  
  271. CREATE TABLE Assign (
  272.   assignID mediumint,
  273.   year varchar(200),
  274.   S_P_M int not NULL,
  275.   rating INT NULL,
  276.   StudentID mediumint,
  277.   mentorID mediumint,  
  278.     PRIMARY KEY (assignID),
  279.     constraint studID_assign FOREIGN KEY (StudentID) REFERENCES Student(StudentID),
  280.     constraint mentID_assign FOREIGN KEY (mentorID) REFERENCES Mentor(mentorID)
  281.     )
  282. ENGINE = InnoDB;
  283. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (1,"Sep 23, 2019",7,8);
  284. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (2,"Jan 15, 2018",6,3);
  285. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (3,"Jun 15, 2019",8,1);
  286. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (4,"May 23, 2018",7,5);
  287. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (5,"Dec 25, 2018",7,1);
  288. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (6,"Jul 18, 2019",10,8);
  289. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (7,"Oct 18, 2019",3,10);
  290. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (8,"Jan 25, 2019",4,2);
  291. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (9,"Mar 28, 2018",5,6);
  292. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (10,"Jul 17, 2019",7,7);
  293. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (11,"Dec 4, 2018",8,2);
  294. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (12,"Dec 22, 2017",3,2);
  295. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (13,"Sep 22, 2019",3,4);
  296. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (14,"Oct 23, 2018",4,10);
  297. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (15,"Jul 18, 2019",7,5);
  298. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (16,"Feb 27, 2019",10,5);
  299. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (17,"Apr 9, 2019",1,9);
  300. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (18,"Sep 18, 2018",7,10);
  301. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (19,"Jul 31, 2018",5,1);
  302. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (20,"Jun 30, 2019",2,3);
  303. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (21,"Mar 13, 2018",5,6);
  304. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (22,"Mar 26, 2019",7,1);
  305. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (23,"Jan 22, 2018",3,8);
  306. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (24,"Aug 19, 2018",10,7);
  307. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (25,"Jun 1, 2018",9,6);
  308. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (26,"Jun 30, 2019",4,4);
  309. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (27,"May 17, 2018",10,2);
  310. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (28,"Mar 18, 2019",3,4);
  311. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (29,"Jun 23, 2019",10,10);
  312. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (30,"Aug 4, 2019",9,4);
  313. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (31,"Jul 27, 2018",2,7);
  314. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (32,"Nov 5, 2018",2,7);
  315. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (33,"Mar 31, 2018",1,3);
  316. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (34,"Jan 16, 2019",8,9);
  317. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (35,"Mar 9, 2018",9,4);
  318. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (36,"Aug 3, 2018",2,8);
  319. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (37,"May 4, 2019",3,2);
  320. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (38,"Apr 8, 2018",2,1);
  321. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (39,"Jun 12, 2019",4,8);
  322. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (40,"Jun 23, 2019",6,4);
  323. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (41,"Feb 26, 2018",10,4);
  324. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (42,"Apr 28, 2018",6,7);
  325. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (43,"Mar 11, 2019",1,4);
  326. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (44,"Nov 17, 2019",5,3);
  327. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (45,"Dec 7, 2018",9,10);
  328. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (46,"Jan 9, 2018",5,4);
  329. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (47,"Aug 6, 2018",2,4);
  330. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (48,"Aug 5, 2019",1,6);
  331. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (49,"Nov 30, 2018",10,4);
  332. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (50,"Feb 27, 2018",2,1);
  333. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (51,"May 30, 2019",10,1);
  334. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (52,"Dec 2, 2017",8,3);
  335. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (53,"Jun 29, 2019",1,6);
  336. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (54,"Jul 13, 2018",5,3);
  337. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (55,"Apr 27, 2018",8,7);
  338. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (56,"Aug 16, 2018",10,2);
  339. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (57,"Jan 12, 2018",1,6);
  340. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (58,"Nov 25, 2018",4,3);
  341. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (59,"Mar 4, 2018",2,4);
  342. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (60,"Jun 19, 2019",8,2);
  343. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (61,"Apr 19, 2019",4,3);
  344. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (62,"May 17, 2019",5,9);
  345. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (63,"Dec 14, 2017",9,8);
  346. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (64,"Aug 17, 2018",3,4);
  347. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (65,"Oct 6, 2018",1,8);
  348. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (66,"Jul 2, 2019",9,4);
  349. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (67,"Sep 2, 2018",7,2);
  350. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (68,"Mar 22, 2018",10,10);
  351. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (69,"Apr 13, 2018",8,7);
  352. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (70,"Jun 6, 2018",3,9);
  353. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (71,"Sep 27, 2018",8,4);
  354. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (72,"Sep 14, 2019",7,4);
  355. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (73,"Mar 16, 2018",8,5);
  356. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (74,"Jun 2, 2019",7,5);
  357. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (75,"Jul 25, 2019",8,9);
  358. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (76,"Oct 4, 2019",4,4);
  359. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (77,"Sep 21, 2018",1,3);
  360. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (78,"Sep 9, 2019",6,3);
  361. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (79,"Dec 15, 2018",6,7);
  362. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (80,"Nov 13, 2019",9,6);
  363. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (81,"Sep 17, 2018",9,4);
  364. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (82,"Jun 19, 2018",5,6);
  365. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (83,"Jul 29, 2018",8,9);
  366. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (84,"Oct 26, 2019",4,1);
  367. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (85,"Jun 18, 2018",7,1);
  368. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (86,"Nov 12, 2019",9,3);
  369. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (87,"Feb 27, 2019",5,4);
  370. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (88,"Sep 11, 2019",1,7);
  371. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (89,"Dec 20, 2017",3,3);
  372. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (90,"May 14, 2019",4,2);
  373. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (91,"Jun 15, 2019",5,8);
  374. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (92,"Apr 26, 2018",4,3);
  375. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (93,"Apr 14, 2018",6,9);
  376. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (94,"Sep 20, 2019",5,8);
  377. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (95,"Jun 13, 2019",4,1);
  378. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (96,"Sep 25, 2018",7,1);
  379. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (97,"Jun 4, 2019",8,5);
  380. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (98,"Apr 26, 2019",8,5);
  381. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (99,"Jan 27, 2018",8,6);
  382. INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (100,"Jun 8, 2019",5,5);
  383. -- -----------------------------------------------------
  384. -- Table `project`.`Events`
  385. -- -----------------------------------------------------
  386.  
  387. CREATE TABLE Event (
  388.   eventID mediumint,
  389.   Title varchar(255) default NULL,
  390.   eventDescription TEXT default NULL,
  391.   Date_Time varchar(255),
  392.   lenght_min mediumint default NULL,
  393.   locationDescription varchar(255) default NULL,
  394.   ticketCost varchar(100) default NULL,
  395.   PRIMARY KEY (eventID))
  396. ENGINE = InnoDB;
  397.  
  398. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (1,"Festival","adipiscing, enim mi tempor lorem, eget mollis lectus pede et","May 22, 2018",60,"","$55.13");
  399. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (2,"Festival","consequat enim diam vel arcu. Curabitur ut odio vel est","Jun 12, 2018",35,"InCampus","$49.83");
  400. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (3,"Festival","ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate,","Jul 25, 2019",45,"InCampus","$40.21");
  401. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (4,"Volunteering","ac nulla. In tincidunt congue turpis. In condimentum. Donec at","Jun 16, 2018",45,"","$83.59");
  402. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (5,"Volunteering","Sed neque. Sed eget lacus. Mauris non dui nec urna","Jul 6, 2019",52,"","$15.61");
  403. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (6,"Festival","Sed congue, elit sed consequat auctor, nunc nulla vulputate dui,","Feb 13, 2019",43,"InCampus","$40.10");
  404. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (7,"Volunteering","et arcu imperdiet ullamcorper. Duis at lacus. Quisque purus sapien,","Mar 8, 2019",60,"InCampus","$9.42");
  405. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (8,"Festival","varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla","Nov 3, 2018",39,"InCampus","$29.70");
  406. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (9,"Volunteering","massa. Quisque porttitor eros nec tellus. Nunc lectus pede, ultrices","Sep 29, 2019",26,"InCampus","$77.03");
  407. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (10,"Festival","Duis mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum.","Nov 13, 2018",46,"InCampus","$92.23");
  408. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (11,"Volunteering","amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor","Jul 12, 2018",40,"","$41.29");
  409. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (12,"SportGames","a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu.","Feb 28, 2018",51,"OffCampus","$59.29");
  410. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (13,"Volunteering","leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis,","Jun 19, 2018",19,"InCampus","$4.44");
  411. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (14,"Volunteering","mi fringilla mi lacinia mattis. Integer eu lacus. Quisque imperdiet,","Jul 19, 2019",55,"","$96.48");
  412. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (15,"Festival","molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris.","Oct 29, 2019",59,"OffCampus","$95.86");
  413. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (16,"Volunteering","sit amet ultricies sem magna nec quam. Curabitur vel lectus.","Jan 11, 2019",54,"InCampus","$26.89");
  414. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (17,"Festival","risus, at fringilla purus mauris a nunc. In at pede.","Apr 3, 2018",56,"","$45.97");
  415. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (18,"SportGames","luctus lobortis. Class aptent taciti sociosqu ad litora torquent per","Jul 19, 2018",15,"OffCampus","$21.13");
  416. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (19,"Volunteering","semper. Nam tempor diam dictum sapien. Aenean massa. Integer vitae","Nov 27, 2017",34,"InCampus","$4.33");
  417. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (20,"Festival","dapibus id, blandit at, nisi. Cum sociis natoque penatibus et","Sep 24, 2019",23,"OffCampus","$66.04");
  418. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (21,"SportGames","Maecenas ornare egestas ligula. Nullam feugiat placerat velit. Quisque varius.","Jan 25, 2019",36,"InCampus","$7.36");
  419. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (22,"Volunteering","quis accumsan convallis, ante lectus convallis est, vitae sodales nisi","May 8, 2019",34,"OffCampus","$2.32");
  420. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (23,"Festival","mus. Donec dignissim magna a tortor. Nunc commodo auctor velit.","May 13, 2019",44,"","$4.08");
  421. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (24,"Volunteering","lectus rutrum urna, nec luctus felis purus ac tellus. Suspendisse","Oct 4, 2018",14,"InCampus","$69.31");
  422. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (25,"Volunteering","quis lectus. Nullam suscipit, est ac facilisis facilisis, magna tellus","May 1, 2019",47,"InCampus","$60.39");
  423. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (26,"SportGames","ac mi eleifend egestas. Sed pharetra, felis eget varius ultrices,","Feb 14, 2018",11,"OffCampus","$87.06");
  424. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (27,"Festival","in faucibus orci luctus et ultrices posuere cubilia Curae; Donec","Jun 19, 2018",28,"","$13.94");
  425. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (28,"Festival","mauris erat eget ipsum. Suspendisse sagittis. Nullam vitae diam. Proin","Mar 24, 2018",21,"OffCampus","$50.91");
  426. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (29,"SportGames","dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero.","Oct 28, 2019",47,"InCampus","$88.04");
  427. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (30,"SportGames","Nulla semper tellus id nunc interdum feugiat. Sed nec metus","Mar 1, 2019",40,"OffCampus","$44.96");
  428. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (31,"Festival","Phasellus at augue id ante dictum cursus. Nunc mauris elit,","Dec 1, 2017",32,"InCampus","$51.50");
  429. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (32,"Volunteering","tempor bibendum. Donec felis orci, adipiscing non, luctus sit amet,","Jul 7, 2018",52,"InCampus","$37.68");
  430. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (33,"SportGames","vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non","Aug 7, 2019",59,"","$1.35");
  431. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (34,"Volunteering","velit in aliquet lobortis, nisi nibh lacinia orci, consectetuer euismod","Jan 3, 2018",27,"OffCampus","$79.98");
  432. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (35,"Volunteering","nostra, per inceptos hymenaeos. Mauris ut quam vel sapien imperdiet","Dec 20, 2018",43,"","$17.42");
  433. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (36,"Volunteering","erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse","Dec 28, 2018",47,"InCampus","$32.49");
  434. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (37,"Volunteering","mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent","Oct 22, 2018",52,"OffCampus","$57.71");
  435. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (38,"Festival","lorem vitae odio sagittis semper. Nam tempor diam dictum sapien.","Aug 19, 2018",25,"InCampus","$28.19");
  436. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (39,"Volunteering","consectetuer adipiscing elit. Curabitur sed tortor. Integer aliquam adipiscing lacus.","Nov 29, 2017",23,"","$3.37");
  437. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (40,"SportGames","erat neque non quam. Pellentesque habitant morbi tristique senectus et","Apr 21, 2018",50,"InCampus","$13.93");
  438. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (41,"Festival","leo. Cras vehicula aliquet libero. Integer in magna. Phasellus dolor","May 5, 2018",37,"InCampus","$91.73");
  439. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (42,"Festival","ipsum cursus vestibulum. Mauris magna. Duis dignissim tempor arcu. Vestibulum","Sep 5, 2018",13,"InCampus","$38.97");
  440. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (43,"Festival","taciti sociosqu ad litora torquent per conubia nostra, per inceptos","Oct 22, 2018",34,"OffCampus","$28.61");
  441. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (44,"SportGames","nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis","Sep 24, 2019",28,"","$90.04");
  442. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (45,"Volunteering","ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam lorem, auctor","Apr 3, 2019",59,"OffCampus","$18.95");
  443. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (46,"SportGames","enim non nisi. Aenean eget metus. In nec orci. Donec","Sep 24, 2018",53,"InCampus","$4.70");
  444. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (47,"Volunteering","dolor vitae dolor. Donec fringilla. Donec feugiat metus sit amet","Apr 15, 2019",12,"InCampus","$39.73");
  445. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (48,"Festival","Nulla semper tellus id nunc interdum feugiat. Sed nec metus","Oct 13, 2019",15,"","$11.09");
  446. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (49,"SportGames","dui. Cum sociis natoque penatibus et magnis dis parturient montes,","Feb 24, 2018",47,"OffCampus","$72.88");
  447. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (50,"Festival","lectus justo eu arcu. Morbi sit amet massa. Quisque porttitor","Jun 21, 2018",16,"OffCampus","$45.51");
  448. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (51,"Festival","ridiculus mus. Proin vel nisl. Quisque fringilla euismod enim. Etiam","Jan 17, 2019",41,"InCampus","$78.17");
  449. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (52,"Festival","vel, mauris. Integer sem elit, pharetra ut, pharetra sed, hendrerit","Jan 15, 2019",58,"InCampus","$7.28");
  450. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (53,"Volunteering","ante blandit viverra. Donec tempus, lorem fringilla ornare placerat, orci","Apr 4, 2019",52,"InCampus","$84.50");
  451. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (54,"SportGames","morbi tristique senectus et netus et malesuada fames ac turpis","May 12, 2018",29,"OffCampus","$40.10");
  452. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (55,"SportGames","quis turpis vitae purus gravida sagittis. Duis gravida. Praesent eu","Dec 10, 2018",31,"InCampus","$38.71");
  453. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (56,"Volunteering","et, commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur consequat,","Aug 27, 2019",56,"InCampus","$0.72");
  454. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (57,"SportGames","Nam ac nulla. In tincidunt congue turpis. In condimentum. Donec","Aug 8, 2019",38,"InCampus","$95.02");
  455. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (58,"SportGames","neque. Sed eget lacus. Mauris non dui nec urna suscipit","Jun 9, 2018",13,"OffCampus","$90.79");
  456. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (59,"Volunteering","Duis ac arcu. Nunc mauris. Morbi non sapien molestie orci","Feb 14, 2018",59,"InCampus","$35.34");
  457. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (60,"Volunteering","hendrerit neque. In ornare sagittis felis. Donec tempor, est ac","Mar 22, 2019",32,"InCampus","$93.40");
  458. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (61,"Festival","mi. Duis risus odio, auctor vitae, aliquet nec, imperdiet nec,","Aug 10, 2018",37,"InCampus","$90.79");
  459. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (62,"SportGames","Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi","Oct 28, 2019",51,"","$65.30");
  460. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (63,"Festival","lorem vitae odio sagittis semper. Nam tempor diam dictum sapien.","Jun 21, 2019",33,"","$55.55");
  461. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (64,"SportGames","Phasellus dolor elit, pellentesque a, facilisis non, bibendum sed, est.","Mar 22, 2018",29,"OffCampus","$34.51");
  462. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (65,"Volunteering","ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula.","Feb 9, 2019",24,"","$14.44");
  463. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (66,"Festival","Donec egestas. Duis ac arcu. Nunc mauris. Morbi non sapien","Aug 23, 2019",54,"InCampus","$19.64");
  464. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (67,"Festival","In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec egestas.","Jul 12, 2019",29,"InCampus","$55.44");
  465. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (68,"SportGames","amet ante. Vivamus non lorem vitae odio sagittis semper. Nam","Jun 30, 2018",11,"","$83.58");
  466. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (69,"Festival","pretium neque. Morbi quis urna. Nunc quis arcu vel quam","Sep 19, 2019",29,"InCampus","$58.94");
  467. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (70,"Festival","sed consequat auctor, nunc nulla vulputate dui, nec tempus mauris","Dec 21, 2017",41,"InCampus","$92.10");
  468. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (71,"Volunteering","at, nisi. Cum sociis natoque penatibus et magnis dis parturient","Feb 27, 2019",12,"InCampus","$22.81");
  469. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (72,"Festival","eu erat semper rutrum. Fusce dolor quam, elementum at, egestas","Jan 30, 2019",40,"InCampus","$72.39");
  470. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (73,"Festival","lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in","Dec 30, 2017",16,"InCampus","$89.24");
  471. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (74,"Festival","ut mi. Duis risus odio, auctor vitae, aliquet nec, imperdiet","Apr 16, 2019",36,"OffCampus","$68.88");
  472. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (75,"Volunteering","Proin vel arcu eu odio tristique pharetra. Quisque ac libero","Feb 21, 2019",40,"OffCampus","$77.03");
  473. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (76,"SportGames","tincidunt tempus risus. Donec egestas. Duis ac arcu. Nunc mauris.","May 5, 2018",54,"","$75.84");
  474. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (77,"Festival","molestie orci tincidunt adipiscing. Mauris molestie pharetra nibh. Aliquam ornare,","Jun 25, 2019",13,"InCampus","$52.56");
  475. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (78,"SportGames","egestas, urna justo faucibus lectus, a sollicitudin orci sem eget","Jun 12, 2019",32,"","$74.62");
  476. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (79,"SportGames","orci. Phasellus dapibus quam quis diam. Pellentesque habitant morbi tristique","Jun 23, 2019",30,"","$66.86");
  477. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (80,"SportGames","erat nonummy ultricies ornare, elit elit fermentum risus, at fringilla","Apr 20, 2019",44,"InCampus","$43.57");
  478. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (81,"SportGames","risus. Duis a mi fringilla mi lacinia mattis. Integer eu","Nov 18, 2018",18,"InCampus","$92.78");
  479. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (82,"SportGames","nunc sed pede. Cum sociis natoque penatibus et magnis dis","Mar 20, 2019",55,"OffCampus","$82.55");
  480. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (83,"SportGames","Sed nunc est, mollis non, cursus non, egestas a, dui.","Jun 20, 2018",33,"InCampus","$8.81");
  481. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (84,"Festival","nunc, ullamcorper eu, euismod ac, fermentum vel, mauris. Integer sem","Oct 12, 2019",35,"InCampus","$73.49");
  482. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (85,"SportGames","ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula.","May 20, 2019",16,"","$96.29");
  483. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (86,"Festival","id ante dictum cursus. Nunc mauris elit, dictum eu, eleifend","Mar 2, 2018",50,"","$82.48");
  484. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (87,"Volunteering","elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu","Apr 6, 2019",33,"OffCampus","$5.73");
  485. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (88,"SportGames","ornare, lectus ante dictum mi, ac mattis velit justo nec","Aug 8, 2019",24,"OffCampus","$75.96");
  486. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (89,"Volunteering","Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor","Jun 18, 2018",32,"OffCampus","$86.12");
  487. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (90,"Volunteering","molestie. Sed id risus quis diam luctus lobortis. Class aptent","Jul 21, 2018",19,"","$49.44");
  488. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (91,"Volunteering","lobortis. Class aptent taciti sociosqu ad litora torquent per conubia","Aug 1, 2019",43,"InCampus","$4.36");
  489. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (92,"Volunteering","semper rutrum. Fusce dolor quam, elementum at, egestas a, scelerisque","Jan 2, 2019",21,"","$19.97");
  490. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (93,"SportGames","ante dictum cursus. Nunc mauris elit, dictum eu, eleifend nec,","Aug 7, 2018",32,"","$99.67");
  491. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (94,"Festival","eu, euismod ac, fermentum vel, mauris. Integer sem elit, pharetra","Sep 29, 2019",28,"InCampus","$51.59");
  492. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (95,"Volunteering","Aenean gravida nunc sed pede. Cum sociis natoque penatibus et","May 7, 2019",37,"OffCampus","$76.31");
  493. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (96,"Festival","sem. Nulla interdum. Curabitur dictum. Phasellus in felis. Nulla tempor","Jul 19, 2019",36,"InCampus","$82.93");
  494. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (97,"SportGames","varius et, euismod et, commodo at, libero. Morbi accumsan laoreet","Nov 18, 2017",34,"OffCampus","$37.79");
  495. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (98,"Volunteering","velit eget laoreet posuere, enim nisl elementum purus, accumsan interdum","Jan 16, 2019",29,"","$53.08");
  496. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (99,"Festival","eget, dictum placerat, augue. Sed molestie. Sed id risus quis","Jun 23, 2018",59,"InCampus","$91.80");
  497. INSERT INTO Event (eventID,Title,eventDescription,Date_Time,lenght_min,locationDescription,ticketCost) VALUES (100,"Volunteering","odio sagittis semper. Nam tempor diam dictum sapien. Aenean massa.","Aug 26, 2019",37,"OffCampus","$18.98");
  498.  
  499. -- -----------------------------------------------------
  500. -- Table `project`.`Attend`
  501. -- -----------------------------------------------------
  502.  
  503.  
  504.  
  505. CREATE TABLE Attend (
  506.   assignID mediumint,
  507.   attendID mediumint,
  508.   eventID mediumint,
  509.   PRIMARY KEY (assignID, attendID),
  510.     constraint assignID_attend FOREIGN KEY (assignID) REFERENCES Assign(assignID),
  511.     constraint eventID_attend FOREIGN KEY (eventID) REFERENCES Event(eventID)
  512. )    
  513.  
  514. ENGINE = InnoDB;
  515.  
  516.  
  517.  
  518.  
  519. SET SQL_MODE=@OLD_SQL_MODE;
  520. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  521. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
  522.  
  523.  
  524. CREATE INDEX name_index  
  525.     ON project.person(Fname);
  526. SHOW index from project.person;
  527.  
  528. -- CREATE TRIGGER FOR UPDATE AND DELETE EXAMPLE
  529. CREATE TRIGGER ahead_insert
  530. After INSERT ON person
  531. FOR EACH ROW
  532. insert into person (personID,FName,LName,Gender,StreetAddress,Phone,Email)
  533. VALUES (101,"Bobby","John","M","701 Faith Avenue","(704) 982-5485","aac.Lorth.BJohn@unca.edu");
  534.  
  535. -- UPDATE
  536. UPDATE `project`.`event`
  537. SET `Title` = 'Mock Interview'
  538. WHERE eventID =100;
  539.  
  540. SELECT * FROM event;
  541.  
  542. -- DELETE
  543. DELETE FROM person
  544. WHERE personID = 101;
  545.  
  546.  
  547. -- REPORT 1
  548. SELECT  StudentID, GPA, major
  549. FROM student
  550. WHERE GPA = 3
  551. ORDER BY StudentID DESC;
  552.  
  553. -- REPORT 2
  554. SELECT  person.personID,Fname, Lname, Assign.rating, Event.title
  555. FROM person
  556. JOIN Assign ON person.personID = Assign.assignID
  557. JOIN Event On event.eventID = person.personID;
  558.  
  559. -- REPORT 3
  560. SELECT mentorID, positions, student.StudentID
  561. FROM mentor, student;
  562.  
  563. -- Creates studentArchive table:
  564. Use project;
  565. DROP TABLE IF EXISTS `studentArchive`;
  566. /*!40101 SET @saved_cs_client = @@character_set_client */;
  567. /*!40101 SET character_set_client = utf8 */;
  568.  CREATE TABLE `studentArchive` ( `ID`
  569.     int(11) NOT NULL AUTO_INCREMENT,
  570.     `Major` varchar(255) DEFAULT NULL,
  571.     `action` varchar(25) DEFAULT NULL,
  572.     `changedon` datetime DEFAULT NULL,
  573.     PRIMARY KEY (`ID`)
  574.     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  575.     /*!40101 SET character_set_client = @saved_cs_client */;
  576.    
  577.  -- Trigger Execution:
  578. Use project;
  579. DROP TRIGGER IF EXISTS triggerAfterUpdate;
  580. DELIMITER $$
  581. CREATE TRIGGER triggerAfterUpdate
  582. BEFORE UPDATE ON student
  583. FOR EACH ROW BEGIN
  584. INSERT INTO studentArchive
  585.     SET action = 'update',
  586.     Major = OLD.Major,
  587.     changedon = NOW();
  588.     END$$
  589.     DELIMITER ;
  590.  
  591. use project;
  592. UPDATE student
  593. SET Major = 'Finances'
  594. WHERE StudentID = 33;
  595.  
  596. SELECT * FROM project.student;
  597.  
  598. -- Query 1
  599. SELECT StudentID
  600. FROM Student
  601. WHERE Major = 'Accounting';
  602.  
  603. -- Query 2
  604. SELECT Title
  605. FROM Event
  606. WHERE locationDescription = 'OffCampus';
  607.  
  608.  -- Query 3                                  
  609. SELECT student.StudentID
  610. FROM Assign
  611. JOIN student ON Assign.assignID = student.StudentID
  612. WHERE rating = 7;
  613.  
  614. -- Query 4
  615. SELECT StudentID, GPA, Grad_year
  616. FROM Student
  617. WHERE honors_YorN = 'Y' AND GPA = 4;
  618.  
  619. -- Report 3
  620. SELECT  eventID, Title, locationDescription, Date_Time, ticketCost
  621. FROM Event WHERE ticketCost = (
  622.                                     SELECT min(ticketCost)
  623.                                     FROM Event
  624.                                     WHERE Title = 'Festival' AND locationDescription = 'InCampus');
  625.  
  626. -- Report 4
  627. SELECT assignID, AVG(rating), year
  628. FROM Assign
  629. WHERE year > 'Sep 2, 2018'
  630. GROUP BY assignID, rating
  631. ORDER BY assignID, rating;
  632.  
  633.  
  634. -- Stored Procedure
  635. DELIMITER //
  636.  
  637. CREATE PROCEDURE Rating()
  638. begin
  639.  
  640. select * from assign where rating = '4';
  641.  
  642.  
  643. end //
  644.  
  645. DELIMITER ;
  646.  
  647. call Rating();
  648.  
  649. drop procedure Rating;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!