--
-- Host: localhost    Database: assessment
-- ------------------------------------------------------


--
-- Dumping data for table `courses`
--

INSERT INTO `courses` VALUES (1,4,'135','Fundamentals of Computing I',1),(2,4,'136','Fundamentals of Computing II',1),(3,4,'246','Discrete Structures',1),(4,4,'255','Embedded Systems',1),(5,5,'326','Software Maintenance',1),(6,4,'172','Calculus I',1),(7,5,'411','Verification and Validation',1);

--
-- Dumping data for table `intervals`
--

INSERT INTO `intervals` VALUES (1,1,11),(2,1,3),(3,4,6),(4,7,9),(5,4,9);

--
-- Dumping data for table `measures`
--


--
-- Dumping data for table `outcomes`
--


--
-- Dumping data for table `permissions`
--


--
-- Dumping data for table `prefixes`
--


--
-- Dumping data for table `program_courses`
--

INSERT INTO `program_courses` VALUES (1,1,1,1),(2,2,1,1),(3,1,2,1),(4,2,2,1),(5,1,3,1),(6,2,3,1),(10,1,4,1),(11,2,4,1),(12,3,4,1),(13,1,5,1),(14,2,5,1),(15,2,6,1),(16,3,6,1),(17,1,6,1),(18,1,7,1);

--
-- Dumping data for table `program_outcomes`
--


--
-- Dumping data for table `programs`
--

INSERT INTO `programs` VALUES (1,'SE','Software Engineering',11,1),(2,'CS','Computer Science',11,1),(3,'EE','Electrical Engineering',11,1);

--
-- Dumping data for table `roles`
--


--
-- Dumping data for table `semesters`
--

INSERT INTO `semesters` VALUES (1,'Fall 2016'),(4,'Fall 2017'),(7,'Fall 2018'),(10,'Fall 2019'),(2,'Spring 2017'),(5,'Spring 2018'),(8,'Spring 2019'),(11,'Spring 2020'),(3,'Summer 2017'),(6,'Summer 2018'),(9,'Summer 2019');

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` VALUES (4,'CSCI'),(5,'ESOF'),(6,'M');

--
-- Dumping data for table `users`
--



