· 6 years ago · Apr 05, 2019, 01:40 PM
1use project;
2-- MySQL Workbench Forward Engineering
3
4SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
6SET @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-- -----------------------------------------------------
11DROP SCHEMA IF EXISTS `project` ;
12
13-- -----------------------------------------------------
14-- Schema project
15-- -----------------------------------------------------
16
17Create DataBase if not exists project;
18USE `project` ;
19
20-- -----------------------------------------------------
21-- Table `project`.`Person`
22-- -----------------------------------------------------
23
24CREATE 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);
34INSERT 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");
35INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (2,"Yardley","Fischer","M","448-8439 Gravida Street","(884) 430-0762","at@arcuvel.net");
36INSERT 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");
37INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (4,"Stewart","Parsons","M","517-9268 Proin Road","(169) 843-5948","vel@arcuVestibulumante.org");
38INSERT 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");
39INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (6,"Nomlanga","Mcguire","F","4407 Aliquet St.","(555) 141-3324","mauris@mi.edu");
40INSERT 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");
41INSERT 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");
42INSERT 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");
43INSERT 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");
44INSERT 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");
45INSERT 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");
46INSERT 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");
47INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (14,"Colette","Fleming","F","4179 Suspendisse St.","(652) 330-7575","a.magna@malesuada.edu");
48INSERT 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");
49INSERT 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");
50INSERT 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");
51INSERT 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");
52INSERT 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");
53INSERT 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");
54INSERT 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");
55INSERT 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");
56INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (23,"Pandora","Fitzpatrick","M","6175 In Ave","(756) 918-6948","lobortis.augue@dictumaugue.ca");
57INSERT 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");
58INSERT 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");
59INSERT 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");
60INSERT 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");
61INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (28,"Wyoming","Navarro","F","339-645 Congue Road","(472) 469-2948","litora@ligula.ca");
62INSERT 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");
63INSERT 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");
64INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (31,"Harrison","Kerr","F","9803 Et Avenue","(103) 976-7228","Suspendisse@suscipit.net");
65INSERT 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");
66INSERT 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");
67INSERT 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");
68INSERT 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");
69INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (36,"Wyatt","Davis","M","278-6335 Turpis St.","(514) 528-2492","Nunc@mollis.edu");
70INSERT 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");
71INSERT 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");
72INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (39,"Quintessa","Perkins","F","4136 Eu Av.","(480) 617-3319","Donec@lobortis.co.uk");
73INSERT 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");
74INSERT 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");
75INSERT 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");
76INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (43,"Bell","Ramirez","F","9799 Enim Rd.","(325) 812-6314","et.commodo@netus.edu");
77INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (44,"Benjamin","Evans","F","8671 Mauris, Rd.","(227) 460-4366","odio@mattisornare.ca");
78INSERT 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");
79INSERT 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");
80INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (47,"Winifred","Roach","F","3239 Suspendisse Avenue","(461) 866-9367","dictum@porttitortellus.net");
81INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (48,"Carl","Galloway","F","4419 Massa. St.","(446) 938-5992","Donec@dictumeueleifend.edu");
82INSERT 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");
83INSERT 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");
84INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (51,"Austin","Paul","M","1116 Eleifend Rd.","(522) 158-9556","habitant.morbi@elitpedemalesuada.org");
85INSERT 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");
86INSERT 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");
87INSERT 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");
88INSERT 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");
89INSERT 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");
90INSERT 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");
91INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (58,"Alec","Sherman","M","9756 Magna St.","(737) 321-7168","ligula@SuspendisseduiFusce.ca");
92INSERT 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");
93INSERT 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");
94INSERT 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");
95INSERT 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");
96INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (63,"Janna","Knight","M","511-4875 Nisl. St.","(712) 720-2673","consequat@eterosProin.net");
97INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (64,"Maggie","Sanders","F","664-3685 Felis St.","(811) 960-7560","lorem@metus.edu");
98INSERT 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");
99INSERT 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");
100INSERT 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");
101INSERT 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");
102INSERT 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");
103INSERT 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");
104INSERT 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");
105INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (72,"Roanna","Ryan","M","1993 Integer St.","(920) 811-0466","non@ullamcorpervelit.com");
106INSERT 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");
107INSERT 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");
108INSERT 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");
109INSERT 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");
110INSERT 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");
111INSERT 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");
112INSERT 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");
113INSERT 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");
114INSERT 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");
115INSERT 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");
116INSERT 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");
117INSERT 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");
118INSERT 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");
119INSERT 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");
120INSERT 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");
121INSERT 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");
122INSERT 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");
123INSERT 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");
124INSERT 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");
125INSERT 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");
126INSERT 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");
127INSERT 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");
128INSERT 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");
129INSERT 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");
130INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (97,"Curran","Ratliff","F","7423 Natoque St.","(290) 524-0334","ante.dictum@eu.org");
131INSERT 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");
132INSERT INTO person (personID,FName,LName,Gender,StreetAddress,Phone,Email) VALUES (99,"Caldwell","Berg","M","8578 Neque St.","(162) 289-9486","Phasellus@tincidunt.org");
133INSERT 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-- -----------------------------------------------------
136select* from person;
137
138CREATE 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
150INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (1,"Finances",3,"25/10/2019","Y");
151INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (2,"Computer Science",3,"28/10/2019","Y");
152INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (3,"Management",4,"20/01/2018","N");
153INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (4,"Computer Science",1,"28/01/2019","Y");
154INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (5,"Law",1,"17/11/2018","N");
155INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (6,"Computer Science",3,"27/05/2018","N");
156INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (7,"Accounting",4,"05/10/2018","N");
157INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (8,"Management",4,"09/12/2018","Y");
158INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (9,"Finances",3,"21/09/2018","N");
159INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (10,"Computer Science",1,"21/07/2018","Y");
160INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (11,"Finances",3,"19/01/2019","N");
161INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (12,"Accounting",2,"30/12/2018","N");
162INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (13,"Accounting",4,"26/04/2019","Y");
163INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (14,"Law",2,"09/11/2018","Y");
164INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (15,"Accounting",3,"28/03/2019","N");
165INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (16,"Accounting",4,"31/08/2018","N");
166INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (17,"Computer Science",3,"01/06/2019","N");
167INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (18,"Management",3,"03/10/2018","N");
168INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (19,"Law",1,"26/05/2018","N");
169INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (20,"Accounting",2,"17/05/2018","N");
170INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (21,"Law",3,"26/04/2018","N");
171INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (22,"Accounting",3,"11/01/2019","N");
172INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (23,"Computer Science",3,"17/06/2019","Y");
173INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (24,"Computer Science",2,"25/12/2018","N");
174INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (25,"Finances",4,"27/06/2018","Y");
175INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (26,"Management",2,"28/05/2019","Y");
176INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (27,"Law",4,"27/06/2019","N");
177INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (28,"Accounting",3,"09/11/2018","Y");
178INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (29,"Computer Science",3,"09/11/2018","N");
179INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (30,"Management",4,"06/12/2017","N");
180INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (31,"Accounting",3,"07/05/2018","N");
181INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (32,"Computer Science",1,"17/06/2019","Y");
182INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (33,"Finances",2,"12/12/2018","N");
183INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (34,"Computer Science",4,"10/12/2017","Y");
184INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (35,"Computer Science",2,"10/09/2018","N");
185INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (36,"Management",4,"29/04/2019","Y");
186INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (37,"Accounting",2,"18/09/2018","N");
187INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (38,"Computer Science",2,"28/08/2019","Y");
188INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (39,"Management",1,"25/04/2019","N");
189INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (40,"Computer Science",1,"27/09/2018","Y");
190INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (41,"Accounting",2,"27/08/2019","N");
191INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (42,"Management",2,"02/12/2017","Y");
192INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (43,"Accounting",2,"19/07/2018","N");
193INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (44,"Finances",4,"26/07/2018","N");
194INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (45,"Management",3,"01/07/2018","Y");
195INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (46,"Computer Science",4,"15/03/2019","N");
196INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (47,"Law",4,"10/03/2019","Y");
197INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (48,"Finances",1,"14/10/2018","Y");
198INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (49,"Law",1,"13/11/2018","N");
199INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (50,"Law",2,"13/08/2019","N");
200INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (51,"Computer Science",4,"21/02/2019","Y");
201INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (52,"Accounting",3,"23/09/2018","N");
202INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (53,"Management",3,"06/11/2019","N");
203INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (54,"Finances",3,"17/11/2017","N");
204INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (55,"Finances",2,"31/12/2018","Y");
205INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (56,"Finances",1,"13/04/2018","Y");
206INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (57,"Management",3,"17/08/2019","Y");
207INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (58,"Finances",2,"05/11/2018","N");
208INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (59,"Accounting",3,"18/01/2018","N");
209INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (60,"Finances",3,"17/09/2019","N");
210INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (61,"Accounting",1,"21/09/2018","Y");
211INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (62,"Accounting",3,"22/05/2019","N");
212INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (63,"Computer Science",4,"26/07/2018","N");
213INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (64,"Law",3,"17/11/2018","N");
214INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (65,"Accounting",4,"07/06/2018","Y");
215INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (66,"Law",1,"20/10/2018","Y");
216INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (67,"Law",2,"28/07/2018","N");
217INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (68,"Accounting",4,"28/11/2018","Y");
218INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (69,"Management",4,"21/06/2019","N");
219INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (70,"Computer Science",2,"18/05/2018","N");
220INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (71,"Finances",3,"02/01/2018","N");
221INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (72,"Accounting",4,"03/05/2018","N");
222INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (73,"Law",2,"01/09/2019","N");
223INSERT INTO student (StudentID,Major,GPA,Grad_year,honors_YorN) VALUES (74,"Finances",3,"27/06/2018","N");
224INSERT 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
231CREATE 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 )
241ENGINE = InnoDB;
242INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (76,"phD","Advising","Associated");
243INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (77,"Bachelor","Accounting","PartTime");
244INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (78,"Bachelor","Advising","PartTime");
245INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (79,"phD","Accounting","FullTime");
246INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (80,"phD","Mathematics","PartTime");
247INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (81,"phD","Accounting","Associated");
248INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (82,"Bachelor","Mathematics","FullTime");
249INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (83,"phD","ComputerScience","FullTime");
250INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (84,"Bachelor","ComputerScience","PartTime");
251INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (85,"Master","ComputerScience","PartTime");
252INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (86,"Bachelor","Advising","PartTime");
253INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (87,"Master","Mathematics","Associated");
254INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (88,"Bachelor","Mathematics","Associated");
255INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (89,"phD","ComputerScience","PartTime");
256INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (90,"phD","Mathematics","PartTime");
257INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (91,"phD","Advising","Associated");
258INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (92,"Master","Mathematics","FullTime");
259INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (93,"Bachelor","Accounting","FullTime");
260INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (94,"Master","Advising","PartTime");
261INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (95,"Bachelor","Advising","Associated");
262INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (96,"Master","Advising","FullTime");
263INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (97,"Master","ComputerScience","FullTime");
264INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (98,"Master","ComputerScience","PartTime");
265INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (99,"phD","Accounting","PartTime");
266INSERT INTO Mentor (mentorID,highest_degree,business,positions) VALUES (100,"phD","Accounting","Associated");
267-- -----------------------------------------------------
268-- Table `project`.`Assign`
269-- -----------------------------------------------------
270
271CREATE 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 )
282ENGINE = InnoDB;
283INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (1,"Sep 23, 2019",7,8);
284INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (2,"Jan 15, 2018",6,3);
285INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (3,"Jun 15, 2019",8,1);
286INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (4,"May 23, 2018",7,5);
287INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (5,"Dec 25, 2018",7,1);
288INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (6,"Jul 18, 2019",10,8);
289INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (7,"Oct 18, 2019",3,10);
290INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (8,"Jan 25, 2019",4,2);
291INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (9,"Mar 28, 2018",5,6);
292INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (10,"Jul 17, 2019",7,7);
293INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (11,"Dec 4, 2018",8,2);
294INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (12,"Dec 22, 2017",3,2);
295INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (13,"Sep 22, 2019",3,4);
296INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (14,"Oct 23, 2018",4,10);
297INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (15,"Jul 18, 2019",7,5);
298INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (16,"Feb 27, 2019",10,5);
299INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (17,"Apr 9, 2019",1,9);
300INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (18,"Sep 18, 2018",7,10);
301INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (19,"Jul 31, 2018",5,1);
302INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (20,"Jun 30, 2019",2,3);
303INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (21,"Mar 13, 2018",5,6);
304INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (22,"Mar 26, 2019",7,1);
305INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (23,"Jan 22, 2018",3,8);
306INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (24,"Aug 19, 2018",10,7);
307INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (25,"Jun 1, 2018",9,6);
308INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (26,"Jun 30, 2019",4,4);
309INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (27,"May 17, 2018",10,2);
310INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (28,"Mar 18, 2019",3,4);
311INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (29,"Jun 23, 2019",10,10);
312INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (30,"Aug 4, 2019",9,4);
313INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (31,"Jul 27, 2018",2,7);
314INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (32,"Nov 5, 2018",2,7);
315INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (33,"Mar 31, 2018",1,3);
316INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (34,"Jan 16, 2019",8,9);
317INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (35,"Mar 9, 2018",9,4);
318INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (36,"Aug 3, 2018",2,8);
319INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (37,"May 4, 2019",3,2);
320INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (38,"Apr 8, 2018",2,1);
321INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (39,"Jun 12, 2019",4,8);
322INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (40,"Jun 23, 2019",6,4);
323INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (41,"Feb 26, 2018",10,4);
324INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (42,"Apr 28, 2018",6,7);
325INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (43,"Mar 11, 2019",1,4);
326INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (44,"Nov 17, 2019",5,3);
327INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (45,"Dec 7, 2018",9,10);
328INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (46,"Jan 9, 2018",5,4);
329INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (47,"Aug 6, 2018",2,4);
330INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (48,"Aug 5, 2019",1,6);
331INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (49,"Nov 30, 2018",10,4);
332INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (50,"Feb 27, 2018",2,1);
333INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (51,"May 30, 2019",10,1);
334INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (52,"Dec 2, 2017",8,3);
335INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (53,"Jun 29, 2019",1,6);
336INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (54,"Jul 13, 2018",5,3);
337INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (55,"Apr 27, 2018",8,7);
338INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (56,"Aug 16, 2018",10,2);
339INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (57,"Jan 12, 2018",1,6);
340INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (58,"Nov 25, 2018",4,3);
341INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (59,"Mar 4, 2018",2,4);
342INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (60,"Jun 19, 2019",8,2);
343INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (61,"Apr 19, 2019",4,3);
344INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (62,"May 17, 2019",5,9);
345INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (63,"Dec 14, 2017",9,8);
346INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (64,"Aug 17, 2018",3,4);
347INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (65,"Oct 6, 2018",1,8);
348INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (66,"Jul 2, 2019",9,4);
349INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (67,"Sep 2, 2018",7,2);
350INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (68,"Mar 22, 2018",10,10);
351INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (69,"Apr 13, 2018",8,7);
352INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (70,"Jun 6, 2018",3,9);
353INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (71,"Sep 27, 2018",8,4);
354INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (72,"Sep 14, 2019",7,4);
355INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (73,"Mar 16, 2018",8,5);
356INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (74,"Jun 2, 2019",7,5);
357INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (75,"Jul 25, 2019",8,9);
358INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (76,"Oct 4, 2019",4,4);
359INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (77,"Sep 21, 2018",1,3);
360INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (78,"Sep 9, 2019",6,3);
361INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (79,"Dec 15, 2018",6,7);
362INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (80,"Nov 13, 2019",9,6);
363INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (81,"Sep 17, 2018",9,4);
364INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (82,"Jun 19, 2018",5,6);
365INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (83,"Jul 29, 2018",8,9);
366INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (84,"Oct 26, 2019",4,1);
367INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (85,"Jun 18, 2018",7,1);
368INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (86,"Nov 12, 2019",9,3);
369INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (87,"Feb 27, 2019",5,4);
370INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (88,"Sep 11, 2019",1,7);
371INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (89,"Dec 20, 2017",3,3);
372INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (90,"May 14, 2019",4,2);
373INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (91,"Jun 15, 2019",5,8);
374INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (92,"Apr 26, 2018",4,3);
375INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (93,"Apr 14, 2018",6,9);
376INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (94,"Sep 20, 2019",5,8);
377INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (95,"Jun 13, 2019",4,1);
378INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (96,"Sep 25, 2018",7,1);
379INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (97,"Jun 4, 2019",8,5);
380INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (98,"Apr 26, 2019",8,5);
381INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (99,"Jan 27, 2018",8,6);
382INSERT INTO Assign (assignID,year,S_P_M,rating) VALUES (100,"Jun 8, 2019",5,5);
383-- -----------------------------------------------------
384-- Table `project`.`Events`
385-- -----------------------------------------------------
386
387CREATE 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))
396ENGINE = InnoDB;
397
398INSERT 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");
399INSERT 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");
400INSERT 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");
401INSERT 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");
402INSERT 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");
403INSERT 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");
404INSERT 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");
405INSERT 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");
406INSERT 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");
407INSERT 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");
408INSERT 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");
409INSERT 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");
410INSERT 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");
411INSERT 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");
412INSERT 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");
413INSERT 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");
414INSERT 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");
415INSERT 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");
416INSERT 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");
417INSERT 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");
418INSERT 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");
419INSERT 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");
420INSERT 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");
421INSERT 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");
422INSERT 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");
423INSERT 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");
424INSERT 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");
425INSERT 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");
426INSERT 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");
427INSERT 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");
428INSERT 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");
429INSERT 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");
430INSERT 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");
431INSERT 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");
432INSERT 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");
433INSERT 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");
434INSERT 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");
435INSERT 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");
436INSERT 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");
437INSERT 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");
438INSERT 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");
439INSERT 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");
440INSERT 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");
441INSERT 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");
442INSERT 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");
443INSERT 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");
444INSERT 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");
445INSERT 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");
446INSERT 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");
447INSERT 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");
448INSERT 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");
449INSERT 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");
450INSERT 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");
451INSERT 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");
452INSERT 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");
453INSERT 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");
454INSERT 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");
455INSERT 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");
456INSERT 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");
457INSERT 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");
458INSERT 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");
459INSERT 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");
460INSERT 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");
461INSERT 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");
462INSERT 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");
463INSERT 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");
464INSERT 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");
465INSERT 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");
466INSERT 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");
467INSERT 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");
468INSERT 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");
469INSERT 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");
470INSERT 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");
471INSERT 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");
472INSERT 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");
473INSERT 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");
474INSERT 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");
475INSERT 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");
476INSERT 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");
477INSERT 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");
478INSERT 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");
479INSERT 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");
480INSERT 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");
481INSERT 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");
482INSERT 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");
483INSERT 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");
484INSERT 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");
485INSERT 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");
486INSERT 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");
487INSERT 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");
488INSERT 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");
489INSERT 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");
490INSERT 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");
491INSERT 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");
492INSERT 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");
493INSERT 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");
494INSERT 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");
495INSERT 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");
496INSERT 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");
497INSERT 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
505CREATE 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
514ENGINE = InnoDB;
515
516
517
518
519SET SQL_MODE=@OLD_SQL_MODE;
520SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
521SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
522
523
524CREATE INDEX name_index
525 ON project.person(Fname);
526SHOW index from project.person;
527
528-- CREATE TRIGGER FOR UPDATE AND DELETE EXAMPLE
529CREATE TRIGGER ahead_insert
530After INSERT ON person
531FOR EACH ROW
532insert into person (personID,FName,LName,Gender,StreetAddress,Phone,Email)
533VALUES (101,"Bobby","John","M","701 Faith Avenue","(704) 982-5485","aac.Lorth.BJohn@unca.edu");
534
535-- UPDATE
536UPDATE `project`.`event`
537SET `Title` = 'Mock Interview'
538WHERE eventID =100;
539
540SELECT * FROM event;
541
542-- DELETE
543DELETE FROM person
544WHERE personID = 101;
545
546
547-- REPORT 1
548SELECT StudentID, GPA, major
549FROM student
550WHERE GPA = 3
551ORDER BY StudentID DESC;
552
553-- REPORT 2
554SELECT person.personID,Fname, Lname, Assign.rating, Event.title
555FROM person
556JOIN Assign ON person.personID = Assign.assignID
557JOIN Event On event.eventID = person.personID;
558
559-- REPORT 3
560SELECT mentorID, positions, student.StudentID
561FROM mentor, student;
562
563-- Creates studentArchive table:
564Use project;
565DROP 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:
578Use project;
579DROP TRIGGER IF EXISTS triggerAfterUpdate;
580DELIMITER $$
581CREATE TRIGGER triggerAfterUpdate
582BEFORE UPDATE ON student
583FOR EACH ROW BEGIN
584INSERT INTO studentArchive
585 SET action = 'update',
586 Major = OLD.Major,
587 changedon = NOW();
588 END$$
589 DELIMITER ;
590
591use project;
592UPDATE student
593SET Major = 'Finances'
594WHERE StudentID = 33;
595
596SELECT * FROM project.student;
597
598-- Query 1
599SELECT StudentID
600FROM Student
601WHERE Major = 'Accounting';
602
603-- Query 2
604SELECT Title
605FROM Event
606WHERE locationDescription = 'OffCampus';
607
608 -- Query 3
609SELECT student.StudentID
610FROM Assign
611JOIN student ON Assign.assignID = student.StudentID
612WHERE rating = 7;
613
614-- Query 4
615SELECT StudentID, GPA, Grad_year
616FROM Student
617WHERE honors_YorN = 'Y' AND GPA = 4;
618
619-- Report 3
620SELECT eventID, Title, locationDescription, Date_Time, ticketCost
621FROM Event WHERE ticketCost = (
622 SELECT min(ticketCost)
623 FROM Event
624 WHERE Title = 'Festival' AND locationDescription = 'InCampus');
625
626-- Report 4
627SELECT assignID, AVG(rating), year
628FROM Assign
629WHERE year > 'Sep 2, 2018'
630GROUP BY assignID, rating
631ORDER BY assignID, rating;
632
633
634-- Stored Procedure
635DELIMITER //
636
637CREATE PROCEDURE Rating()
638begin
639
640select * from assign where rating = '4';
641
642
643end //
644
645DELIMITER ;
646
647call Rating();
648
649drop procedure Rating;