ccidata.sql

# Test data for study
# Generated with: https://www.generatedata.com/

CREATE TABLE `students` (
  `id` mediumint,
  `name` varchar(255) default NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `students` (`id`,`name`) VALUES (1,"Xerxes"),(2,"Scott"),(3,"Marvin"),(4,"Justin"),(5,"Idola"),(6,"Jaquelyn"),(7,"Doris"),(8,"Buffy"),(9,"Hyatt"),(10,"Gloria");
INSERT INTO `students` (`id`,`name`) VALUES (11,"Kim"),(12,"Judith"),(13,"Chanda"),(14,"Reece"),(15,"Stephen"),(16,"Halee"),(17,"Debra"),(18,"Chaim"),(19,"Joseph"),(20,"Zachery");
INSERT INTO `students` (`id`,`name`) VALUES (21,"Candice"),(22,"Ferris"),(23,"Garth"),(24,"Lane"),(25,"Cathleen"),(26,"Vincent"),(27,"Aquila"),(28,"Walker"),(29,"Vernon"),(30,"Ciaran");
INSERT INTO `students` (`id`,`name`) VALUES (31,"Christen"),(32,"Porter"),(33,"Remedios"),(34,"Nigel"),(35,"Brady"),(36,"Ramona"),(37,"Karleigh"),(38,"Jerry"),(39,"Ulric"),(40,"Rahim");
INSERT INTO `students` (`id`,`name`) VALUES (41,"Hiroko"),(42,"Nissim"),(43,"Patience"),(44,"Marny"),(45,"Christopher"),(46,"Larissa"),(47,"Anjolie"),(48,"Emi"),(49,"Scott"),(50,"Sage");
INSERT INTO `students` (`id`,`name`) VALUES (51,"Boris"),(52,"Camden"),(53,"Malik"),(54,"Daryl"),(55,"Karleigh"),(56,"Holly"),(57,"Mason"),(58,"Hall"),(59,"Shay"),(60,"Fuller");
INSERT INTO `students` (`id`,`name`) VALUES (61,"Martha"),(62,"Amos"),(63,"Karen"),(64,"Odysseus"),(65,"Autumn"),(66,"Vincent"),(67,"Frances"),(68,"Leo"),(69,"Ulysses"),(70,"Jolie");
INSERT INTO `students` (`id`,`name`) VALUES (71,"Beau"),(72,"Chastity"),(73,"Jerry"),(74,"Xantha"),(75,"Kyla"),(76,"Xenos"),(77,"Ahmed"),(78,"Minerva"),(79,"Donovan"),(80,"Georgia");
INSERT INTO `students` (`id`,`name`) VALUES (81,"Serina"),(82,"Burton"),(83,"Jolie"),(84,"Aurora"),(85,"Xena"),(86,"Hall"),(87,"Abdul"),(88,"Chava"),(89,"Abdul"),(90,"Aaron");
INSERT INTO `students` (`id`,`name`) VALUES (91,"Declan"),(92,"Quinn"),(93,"Oren"),(94,"Lionel"),(95,"Gareth"),(96,"Azalia"),(97,"Lana"),(98,"Lewis"),(99,"Ivan"),(100,"Ginger");


CREATE TABLE `teachers` (,
  `id` mediumint,
  `name` varchar(255) default NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `teachers` (`id`,`name`) VALUES (1,"Kelly"),(2,"Russell"),(3,"Giacomo"),(4,"Lenore"),(5,"Scarlett"),(6,"Kelsey"),(7,"Paki"),(8,"Kameko"),(9,"Sawyer"),(10,"Chaney");
INSERT INTO `teachers` (`id`,`name`) VALUES (11,"Odysseus"),(12,"Cairo"),(13,"Holmes"),(14,"Hanna"),(15,"Akeem"),(16,"Bianca"),(17,"Levi"),(18,"Ian"),(19,"Renee"),(20,"Audra");
INSERT INTO `teachers` (`id`,`name`) VALUES (21,"Macon"),(22,"Forrest"),(23,"TaShya"),(24,"Jemima"),(25,"Lionel"),(26,"Nell"),(27,"Damon"),(28,"Keith"),(29,"Lane"),(30,"Tana");
INSERT INTO `teachers` (`id`,`name`) VALUES (31,"Christian"),(32,"Harlan"),(33,"Rigel"),(34,"Armando"),(35,"Simone"),(36,"Rosalyn"),(37,"Hilary"),(38,"Yardley"),(39,"Stacey"),(40,"Chantale");
INSERT INTO `teachers` (`id`,`name`) VALUES (41,"Virginia"),(42,"Colt"),(43,"Kennedy"),(44,"Danielle"),(45,"Jana"),(46,"Beverly"),(47,"Len"),(48,"Maya"),(49,"Len"),(50,"Raymond");
INSERT INTO `teachers` (`id`,`name`) VALUES (51,"Colby"),(52,"Oren"),(53,"Chanda"),(54,"Melvin"),(55,"Jaime"),(56,"Macy"),(57,"Arden"),(58,"Yoko"),(59,"Stone"),(60,"Lunea");
INSERT INTO `teachers` (`id`,`name`) VALUES (61,"Jack"),(62,"Kasimir"),(63,"Hilel"),(64,"Magee"),(65,"Keane"),(66,"Maisie"),(67,"Cadman"),(68,"Michelle"),(69,"Michael"),(70,"May");
INSERT INTO `teachers` (`id`,`name`) VALUES (71,"Louis"),(72,"Richard"),(73,"Britanni"),(74,"Ebony"),(75,"Adele"),(76,"Claire"),(77,"Patricia"),(78,"Ali"),(79,"Carl"),(80,"Barrett");
INSERT INTO `teachers` (`id`,`name`) VALUES (81,"Joelle"),(82,"Patrick"),(83,"Cain"),(84,"Noah"),(85,"Hunter"),(86,"Charissa"),(87,"Clare"),(88,"Simon"),(89,"Malik"),(90,"Emerson");
INSERT INTO `teachers` (`id`,`name`) VALUES (91,"Leonard"),(92,"Jemima"),(93,"Adam"),(94,"Carson"),(95,"Celeste"),(96,"Vladimir"),(97,"Curran"),(98,"Brody"),(99,"Oren"),(100,"Adara");


CREATE TABLE `courses` (
  `id` mediumint,
  `name` varchar(255),
  `teacherid` mediumint default NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (1,"Consequat Inc.",15),(2,"Eu Dolor Inc.",62),(3,"Neque Nullam Corp.",42),(4,"Vestibulum Lorem Sit Associates",80),(5,"A PC",59),(6,"Mauris Magna Limited",16),(7,"Magnis Dis Parturient Incorporated",69),(8,"Ornare Sagittis Felis Institute",31),(9,"Nunc Corp.",87),(10,"Luctus Et Ultrices Consulting",38);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (11,"Eu Limited",90),(12,"Blandit Consulting",87),(13,"Molestie Orci Tincidunt LLP",93),(14,"Rutrum Eu Ultrices LLP",65),(15,"Integer Ltd",87),(16,"Tempor Bibendum Institute",85),(17,"Euismod Institute",55),(18,"Eu Enim PC",74),(19,"Aliquam Consulting",86),(20,"Purus Nullam Scelerisque Consulting",86);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (21,"Diam Vel Arcu Incorporated",83),(22,"Fringilla Donec Feugiat Incorporated",76),(23,"Malesuada Id Erat Institute",56),(24,"Libero Lacus Associates",84),(25,"Ligula Tortor Company",76),(26,"Velit Corporation",43),(27,"Non Company",34),(28,"Purus Inc.",52),(29,"Auctor Ullamcorper Nisl Institute",97),(30,"Tincidunt Donec Vitae Associates",32);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (31,"Justo Sit Amet Foundation",20),(32,"Ut Associates",52),(33,"Curabitur Ut Company",6),(34,"Aliquet Ltd",8),(35,"Eu Associates",17),(36,"Donec Non Inc.",1),(37,"Elementum At Egestas Associates",36),(38,"Lorem Ipsum Consulting",77),(39,"Convallis LLP",33),(40,"Ipsum Ac Mi LLP",48);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (41,"Interdum Curabitur PC",49),(42,"Magna A LLP",83),(43,"Rutrum Fusce Dolor Ltd",50),(44,"Nec Company",23),(45,"Turpis Aliquam Adipiscing Industries",13),(46,"Aenean Inc.",25),(47,"Quis Company",42),(48,"Ut Tincidunt Incorporated",62),(49,"Sociosqu Ad Litora Corp.",73),(50,"Sem Associates",92);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (51,"Vitae Aliquam Foundation",43),(52,"Et Foundation",79),(53,"In Consectetuer Ipsum Industries",70),(54,"Donec Luctus Institute",67),(55,"Ornare Libero Company",15),(56,"Quis Lectus Nullam Corp.",39),(57,"Suspendisse Sed Inc.",64),(58,"Facilisis Institute",5),(59,"Sit Amet Dapibus Corp.",10),(60,"Scelerisque Lorem Ipsum Incorporated",30);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (61,"Nisi Cum Sociis Limited",12),(62,"Malesuada Augue Ut Corporation",43),(63,"Erat Vivamus Limited",81),(64,"Velit Quisque Varius Foundation",17),(65,"Nulla Aliquet Proin LLC",16),(66,"Proin Ltd",93),(67,"Lacinia Sed Incorporated",8),(68,"In Ornare Sagittis Corporation",86),(69,"Nec Tempus Foundation",37),(70,"Cursus LLP",20);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (71,"Laoreet Industries",22),(72,"Penatibus Et Ltd",38),(73,"Duis Gravida Praesent Corp.",71),(74,"Dui Associates",16),(75,"Sapien LLC",63),(76,"Tincidunt Congue Turpis Limited",21),(77,"Mi PC",57),(78,"Iaculis Odio Limited",94),(79,"Mollis Nec Institute",29),(80,"Donec Egestas Aliquam Incorporated",93);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (81,"Mauris Vel Turpis Ltd",77),(82,"Nec Euismod In Foundation",56),(83,"Morbi Sit Amet Incorporated",16),(84,"Dapibus Quam Inc.",94),(85,"Urna Suscipit Inc.",51),(86,"Orci PC",21),(87,"Duis A Mi Corporation",91),(88,"Arcu Iaculis Corp.",94),(89,"Adipiscing Elit Industries",93),(90,"Amet Company",1);
INSERT INTO `courses` (`id`,`name`,`teacherid`) VALUES (91,"Semper Rutrum Fusce Corporation",22),(92,"Lacus Vestibulum Lorem Limited",100),(93,"Proin Company",64),(94,"Cras Dictum Ultricies LLP",37),(95,"Augue Scelerisque Associates",2),(96,"Dolor Nonummy Ac LLP",80),(97,"Pede Sagittis Augue Corp.",25),(98,"Mus Incorporated",51),(99,"Parturient Montes Nascetur PC",22),(100,"Libero Foundation",92);


CREATE TABLE `studentcourses` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `studentid` mediumint default NULL,
  `courseid` mediumint default NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (43,65),(66,22),(70,43),(68,81),(11,43),(13,66),(70,41),(27,21),(69,90),(100,41);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (40,39),(36,8),(36,41),(28,53),(2,81),(15,24),(32,93),(47,24),(38,63),(54,32);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (35,93),(59,27),(78,77),(82,25),(71,33),(29,13),(47,25),(63,45),(75,55),(89,68);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (85,21),(91,85),(15,11),(69,16),(9,93),(48,62),(63,24),(79,66),(37,22),(27,81);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (69,65),(84,15),(5,29),(62,40),(39,32),(23,83),(18,68),(55,4),(12,73),(94,84);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (32,26),(59,75),(98,51),(87,55),(82,33),(92,93),(66,19),(28,31),(82,87),(72,21);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (76,26),(32,46),(67,24),(82,37),(61,58),(86,73),(47,63),(87,11),(16,96),(78,14);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (50,83),(17,31),(28,1),(82,88),(24,65),(31,43),(72,36),(13,84),(39,26),(14,74);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (37,28),(41,76),(42,42),(80,61),(69,50),(43,82),(16,43),(80,20),(33,47),(45,17);
INSERT INTO `studentcourses` (`studentid`,`courseid`) VALUES (41,78),(79,51),(60,74),(88,29),(49,100),(81,64),(35,63),(39,99),(32,35),(3,47);