Database script

students.sql

CREATE DATABASE `students` /*!40100 DEFAULT CHARACTER SET utf8 */;
use students;
CREATE TABLE `career` (
  `career_id` varchar(25) NOT NULL,
  `career_name` varchar(100) NOT NULL,
  PRIMARY KEY (`career_id`),
  UNIQUE KEY `career_name_UNIQUE` (`career_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `section` (
  `section_id` varchar(25) NOT NULL,
  `section_name` varchar(45) NOT NULL,
  PRIMARY KEY (`section_id`),
  UNIQUE KEY `section_name_UNIQUE` (`section_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `student` (
  `student_id` varchar(50) NOT NULL,
  `student_name` varchar(100) NOT NULL,
  `student_career` varchar(100) NOT NULL,
  `student_section` varchar(100) NOT NULL,
  PRIMARY KEY (`student_id`),
  UNIQUE KEY `idstudent_UNIQUE` (`student_id`),
  KEY `fk_student_section_idx` (`student_section`),
  KEY `fk_student_career_idx` (`student_career`),
  CONSTRAINT `fk_student_career` FOREIGN KEY (`student_career`) REFERENCES `career` (`career_name`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_student_section` FOREIGN KEY (`student_section`) REFERENCES `section` (`section_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;