Les etapes de creation de base de
donnees :
1- La creation de base de donnees scolarité
Le code est comme suit :
create database scolarite
2- La creation des tables :
Le code est comme suit :
create table etudiant
(
Code_e INT PRIMARY KEY NOT NULL,
Nom_e VARCHAR(50),
Prenom VARCHAR(50),
Date_naissance DATE,
Lieu VARCHAR(100),
Adresse VARCHAR(255),
Doublant nchar(5) ,
Photo image,
Ref_classe int
)
create table professeur
(
Code_p INT PRIMARY KEY NOT NULL,
Nom_p VARCHAR(50),
Prenom_p VARCHAR(50),
Diplome VARCHAR(100),
Ref_Matiere int
)
create table matiere
(
Reference_m INT PRIMARY KEY NOT NULL,
Designation_m VARCHAR(50),
Coefficient int ,
Ref_specialite int
)
create table classe
(
Ref_classe INT PRIMARY KEY NOT NULL,
Designation_c VARCHAR(50),
Ref_specialite int
)
create table specialite
(
Ref_Specialite INT PRIMARY KEY NOT NULL,
Designation_s VARCHAR(50),
)
create table resultat
(
Code_etudiant int ,
FOREIGN KEY (Code_etudiant) REFERENCES etudiant (Code_e),
Ref_matiere int ,
FOREIGN KEY (Ref_matiere) REFERENCES matiere (Reference_m),
Trimestre int PRIMARY KEY NOT NULL ,
Devoir numeric ,
Composition numeric,
Observation varchar(50)
)
create Table protection
(
Password varchar(20) PRIMARY KEY NOT NULL
)
3- L’insertion des données au tables
1- L’insertion des donnees au tableau etudiant :
insert into etudiant (code_e,Nom_e,Prenom,Lieu,Adresse,Doublant,
Ref_classe)
values
(1,'Gherbi','Samir','2001-04-14','Biskra','cite cnep 50 log','non',NULL,1)
(2,'kediri','Amine','2002-02-13','Biskra','cite 1000 log','non',NULL,1)
(3,'Guesmi','Asma','2002-03-11','Biskra','cite 700','Non',NULL,2)
(4,'selmi','kheloud','2001-09-07','Biskra','cite cnep 50 log','non',NULL,1)
(5,'Ben Meddour','halim','2001-01-09','Biskra','cite dhalaa','non',NULL,1)
(6,'kerdoudi','Amina','2002-02-05','Biskra','cite 1000 log','non',NULL,4)
(7,'Abbas','Souria','2002-03-01','Batna','cite 700','Non',NULL,2)
(8,'selem','Amira','2001-09-03','Batna','cite cnep 50 log','non',NULL,3)
(9,'houcine','yacine','2001-04-14','Biskra','cite cnep 50
log','non',NULL,2)
(10,'lekhel','Ahmed','2002-09-17','Biskra','cite 1000 log','non',NULL,2)
(11,'Behaz','Lamine','2002-11-11','Biskra','cite 700','Non',NULL,2)
(12,'Ghecham','Adem','2001-06-09','Biskra','cite cnep 50 log','non',NULL,2)
(13,'Tammami','Djoud','2002-03-22','setif','cite cnep 50 log','non',NULL,3)
(14,'Lehoual','salim','2002-07-19','Annaba','cite 1000 log','non',NULL,3)
(15,'Saada','Loubna','2002-10-11','Biskra','cite 700','Non',NULL,3)
(16,'Zaeboubi','Tamer','2001-12-08','Biskra','cite cnep 50
log','oui',NULL,3)
(17,'Zekkour','Khaled','2001-04-14','Biskra','cite cnep 50
log','non',NULL,4)
(18,'Ben Abdallah','Karim','2002-05-12','Biskra','cite 1000
log','oui',NULL,4)
(19,'Selmoun','Mustapha','2002-03-11','Biskra','Boukhari','Non',NULL,4)
(20,'Jaber','Imen','2001-09-07','Biskra','Saiehi','non',NULL,4)
2- Table Matière
3- Table Professeurs
4- Tableau SPECIALITE :
