DROP TABLE IF EXISTS `demo`.`student_course_info`;
CREATE TABLE  `demo`.`student_course_info` (
  `student_name` varchar(45) NOT NULL,
  `student_id` varchar(45) NOT NULL,
  `course` varchar(45) NOT NULL,
  `duration` varchar(45) NOT NULL,
  PRIMARY KEY (`student_id`,`course`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;