CREATE TABLE IF NOT EXISTS `mydb`.`ETUDIANT` (
  `Num_etudiant` INT NOT NULL,
  `NomE` VARCHAR(45) NULL,
  `E-mail` VARCHAR(45) NULL,
  `Age` VARCHAR(45) NULL,
  `Moyenne` FLOAT NULL,
  PRIMARY KEY (`Num_etudiant`))
ENGINE = InnoDB

INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (1, 'Ahmed', 'ahmed@gmail.com', '18', 10);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (2, 'Ahlam', 'Ahlam@gmail.com', '24', 12);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (3, 'Nabila', 'Nabila@gmail.com', '20', 11);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (4, 'Mohamad', 'Mohamad@gmail.com', '22', 14);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (5, 'Assia', 'Assia@gmail.com', '23', 11);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (6, 'Salim', 'Salim@gmail.com', '24', 10);
INSERT INTO `mydb`.`ETUDIANT` (`Num_etudiant`, `NomE`, `E-mail`, `Age`, `Moyenne`) VALUES (7, 'Jamila', 'Jamila@gmail.com', '20', 11);

CREATE TABLE IF NOT EXISTS `mydb`.`PROF` (
  `Num_prof` INT NOT NULL,
  `NomP` VARCHAR(45) NULL,
  `Salaire` FLOAT NULL,
  PRIMARY KEY (`Num_prof`))
ENGINE = InnoDB

INSERT INTO `mydb`.`PROF` (`Num_prof`, `NomP`, `Salaire`) VALUES (1, 'Majid', 20000);
INSERT INTO `mydb`.`PROF` (`Num_prof`, `NomP`, `Salaire`) VALUES (2, 'Fadhila', 20000);
INSERT INTO `mydb`.`PROF` (`Num_prof`, `NomP`, `Salaire`) VALUES (3, 'Sami', 20000);
INSERT INTO `mydb`.`PROF` (`Num_prof`, `NomP`, `Salaire`) VALUES (4, 'Hafsa', 20000);

CREATE TABLE IF NOT EXISTS `mydb`.`MODULE` (
  `Num_module` INT NOT NULL,
  `NomM` VARCHAR(45) NULL,
  `DureeAnnuelle` TINYINT(4) NULL,
  PRIMARY KEY (`Num_module`))
ENGINE = InnoDB

INSERT INTO `mydb`.`MODULE` (`Num_module`, `NomM`, `DureeAnnuelle`) VALUES (1, 'bases de données', 6);
INSERT INTO `mydb`.`MODULE` (`Num_module`, `NomM`, `DureeAnnuelle`) VALUES (2, 'réseaux', 6);
INSERT INTO `mydb`.`MODULE` (`Num_module`, `NomM`, `DureeAnnuelle`) VALUES (3, 'anglais', 6);

CREATE TABLE IF NOT EXISTS `mydb`.`ENSEIGNE` (
  `Num_prof` INT NOT NULL,
  `Num_module` INT NOT NULL,
  `Section` VARCHAR(45) NULL,
  PRIMARY KEY (`Num_prof`, `Num_module`))
ENGINE = InnoDB

INSERT INTO `mydb`.`ENSEIGNE` (`Num_prof`, `Num_module`, `Section`) VALUES (1, 1, 'A');
INSERT INTO `mydb`.`ENSEIGNE` (`Num_prof`, `Num_module`, `Section`) VALUES (2, 2, 'A');
INSERT INTO `mydb`.`ENSEIGNE` (`Num_prof`, `Num_module`, `Section`) VALUES (3, 3, 'B');

CREATE TABLE IF NOT EXISTS `mydb`.`SUIT` (
  `Num_etudiant` INT NOT NULL,
  `Num_module` INT NOT NULL,
  `Section` VARCHAR(45) NULL,
  `Note` FLOAT NULL,
  PRIMARY KEY (`Num_etudiant`, `Num_module`))
ENGINE = InnoDB

INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (1, 1, 'A', 10);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (1, 3, 'A', 10);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (2, 1, 'A', 9);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (2, 3, 'A', 9);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (3, 1, 'B', 10);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (4, 1, 'B', 9);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (3, 3, 'B', 10);
INSERT INTO `mydb`.`SUIT` (`Num_etudiant`, `Num_module`, `Section`, `Note`) VALUES (4, 3, 'B', 10);