32 -
-- Création de la table Eleve
CREATE TABLE Eleve (
id INT PRIMARY KEY,
nom VARCHAR(255),
prenom VARCHAR(255),
date_naissance DATE
);
-- Création de la table Note
CREATE TABLE Note (
id INT PRIMARY KEY,
id_eleve INT,
matiere VARCHAR(255),
note INT,
FOREIGN KEY (id_eleve) REFERENCES Eleve(id)
);
-- Insertion de données dans la table Eleve
INSERT INTO Eleve VALUES
(1, 'El Kaddouri', 'Mohammed', '2005-01-15'),
(2, 'Zahraoui', 'Fatima', '2004-05-22'),
(3, 'Bouhaddou', 'Youssef', '2006-03-10');
-- Insertion de données dans la table "Notes"
INSERT INTO Note VALUES
(1, 1, 'Math', 18),
(2, 1, 'Francais', 14),
(3, 2, 'Math', 16),
(4, 2, 'Francais', 19),
(5, 3, 'Math', 20),
(6, 3, 'Francais', 17);
00:00 Introduction
00:21 Enoncé de l'exercice
01:19 Script de création
02:27 Jeu de données
03:07 Questions
06:25 Solution
10:42 Question 1
18:21 Question 2
29:02 Question 3
33:40 Question 4
35:41 Resumé de la solution
37:58 Conclusion
Watch video 32 - online without registration, duration hours minute second in high quality. This video was added by user Amine Abbaoui 10 December 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 51 once and liked it 1 people.