View original (French)

School management application

Camara Mohamed Maimouna -  
 AdmiSco -
Hello, I want to create a School Management application (private institution) for all levels of education in VB6 with SQL Server 2000. For this, I would like to obtain a conceptual model or a similar software in order to gather useful information for management.
Thank you! I am counting on your help.

17 réponses

Réponse 1 / 17
piaf666 Posted messages 12 Status Membre 21
 
For an ERD, you will find resources at metho.fr
3
Réponse 2 / 17
mami
 
Hello, I saw your message and I would like to share with you the results of your research because I am doing the same study at the moment. Could you please send me the mdc?
Thank you.
2
MGH
 
Following your question, please consult
www.vbfrance.com
0
mgh1100
 
sorry
I work with UML as a design model (unified process)
but I can give you a comment on how to see the ERD:
from the source code (it's a zipped file) that you will download from vbfrance.com
you will find an Access file that contains the relational model (ERD).
good luck.
0
Réponse 3 / 17
AdmiSco
 
Hello

I invite you to try the AdmiSco software in its demo version, available for download here: http://shamsoft.perso.sfr.fr/FR/logiciel_admisco.php

Here is a brief description:
AdmiSco is a comprehensive software for School Administration. It can be used to manage high schools or middle schools.

AdmiSco is bilingual, available in Arabic and French.
The AdmiSco software was developed with two major constraints in mind: efficiency and simplicity.

It allows for very complex processing in a secure and simple way. Its interface is truly intuitive and suitable for all types of users.

AdmiSco allows you, among other things, to:

- Automatically create timetables with the possibility of modifying them manually,
- Manage students' grades, averages, and report cards in a customizable and secure manner,
- Manage student absences,
- Manage teacher absences,
- Close school years and carry out student progression,
- Manage the progress of each student,
- Print report cards, certificates of enrollment, timetables, absences, ...
- Print the RGF,
- Print the entry register,
- Print the exit register,
- Print the status as of October 1st,
- Print students present on a specific date,
- Print students absent for a month,
- Print the daily report,
- ...
admisco is disconnected Send a private message Reply with citation
2
Réponse 4 / 17
Ousmo
 
Hello Camara, how are you? I hope you're doing well. I saw your message, I don't know if I can be of help to you. By the way, I created a similar application (School Management) on Access and on Windev 7. In case you are interested in these different experiences, reply and we will see how to get in touch, okay, bye.
1
lisamelle
 
Hello Ousmo, actually I'm in the same situation as Camara, I think you can be of help. I'm developing a web application to manage school administration. Right now I'm really struggling to find a solution that works, and I would like to get an idea from someone else to finalize my work. So I need the MTC, words, and MCD to compare and of course to catch up on my mistakes. Thank you.
I'm using MERISE.
Thank you for your assistance.
0
lisamelle
 
Salut Ousmo, je suis en train de faire un travail sous Merise pour la gestion de la scolarité et mon MCD n'est toujours pas correct. J'ai réussi à faire mes MCT, mais je bute sur le MCD. Je te serais reconnaissante de me faire parvenir par mon email des informations et pourquoi pas ton MCD pour voir comment ça marche. Merci, c'est très urgent.
Ou si c'est possible, je t'envoie mon modèle pour correction.
0
dikeydi
 
Salut ! Je dois aussi développer une application sous Access puis en langage C pour la gestion d'une section informatique dans une faculté. Si quelqu'un a des tuyaux, ce serait vraiment chouette ! Merci d'avance.
0
simplice
 
Hello Ousmo,
I am very interested in this application.
Thank you in advance.
0
Réponse 5 / 17
Techys
 
``` - --------------------------------------------------------

--
-- Structure of table `TB_abs_rtd_aucun`
--

DROP TABLE IF EXISTS `TB_abs_rtd_aucun`;
CREATE TABLE `TB_abs_rtd_aucun` (
`id` int(11) NOT NULL auto_increment,
`classe` varchar(30) NOT NULL,
`date` date NOT NULL,
`heure` time default NULL,
`matiere` varchar(50) NOT NULL,
`enseignant` varchar(80) default NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_abs_rtd_aucun`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_absences`
--

DROP TABLE IF EXISTS `TB_absences`;
CREATE TABLE `TB_absences` (
`elev_id` int(11) NOT NULL,
`date_ab` date NOT NULL,
`date_saisie` date NOT NULL,
`duree_ab` double NOT NULL,
`origin_saisie` varchar(30) default NULL,
`date_fin` date default NULL,
`motif` text,
`duree_heure` int(11) default NULL,
`id_matiere` int(11) default NULL,
`time` time default NULL,
KEY `elev_id` (`elev_id`,`date_ab`,`date_fin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_absences`
--

INSERT INTO `TB_absences` (`elev_id`, `date_ab`, `date_saisie`, `duree_ab`, `origin_saisie`, `date_fin`, `motif`, `duree_heure`, `id_matiere`, `time`) VALUES
(-4, '0000-00-00', '0000-00-00', 0, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure of table `TB_affectations`
--

DROP TABLE IF EXISTS `TB_affectations`;
CREATE TABLE `TB_affectations` (
`ordre_affichage` smallint(6) NOT NULL,
`code_matiere` smallint(6) NOT NULL,
`code_prof` int(11) NOT NULL,
`code_classe` smallint(6) NOT NULL,
`coef` decimal(30,2) NOT NULL,
`code_groupe` int(11) default NULL,
`langue` varchar(20) default NULL,
`avec_sous_matiere` tinyint(1) NOT NULL,
PRIMARY KEY (`code_classe`,`code_matiere`,`code_prof`,`ordre_affichage`),
KEY `code_classe` (`code_classe`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_affectations`
--

-- --------------------------------------------------------
--
-- Structure of table `TB_avertissement`
--

DROP TABLE IF EXISTS `TB_avertissement`;
CREATE TABLE `TB_avertissement` (
`id_pers` int(11) NOT NULL,
`type_pers` varchar(20) NOT NULL,
`parametrage` varchar(30) NOT NULL,
`valeur` varchar(30) NOT NULL,
UNIQUE KEY `id_pers` (`id_pers`,`type_pers`,`parametrage`,`valeur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_avertissement`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_blacklist`
--

DROP TABLE IF EXISTS `TB_blacklist`;
CREATE TABLE `TB_blacklist` (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(50) NOT NULL,
`prenom` varchar(50) NOT NULL,
`ip` varchar(30) default NULL,
`navigateur` text,
`date` date NOT NULL,
`nb_tentative` int(11) NOT NULL,
`membre` varchar(20) NOT NULL,
`cause` text,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_blacklist`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bug`
--

DROP TABLE IF EXISTS `TB_bug`;
CREATE TABLE `TB_bug` (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(30) NOT NULL,
`prenom` varchar(30) NOT NULL,
`date` date NOT NULL,
`membre` varchar(30) default NULL,
`action` varchar(30) default NULL,
`service` varchar(30) default NULL,
`commentaire` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_bug`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bulletin_direction_com`
--

DROP TABLE IF EXISTS `TB_bulletin_direction_com`;
CREATE TABLE `TB_bulletin_direction_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
`montessori` varchar(30) default NULL,
`type_bulletin` varchar(30) default NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`,`type_bulletin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_bulletin_direction_com`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bulletin_prof_com`
--

DROP TABLE IF EXISTS `TB_bulletin_prof_com`;
CREATE TABLE `TB_bulletin_prof_com` (
`idmatiere` int(11) NOT NULL,
`idclasse` int(11) NOT NULL,
`trimestre` varchar(30) NOT NULL,
`com` text,
`ideleve` int(11) NOT NULL,
`idprof` int(11) NOT NULL,
`idgroupe` int(11) default NULL,
UNIQUE KEY `idmatiere` (`idmatiere`,`idclasse`,`trimestre`,`ideleve`,`idprof`,`idgroupe`),
KEY `idclasse` (`idclasse`,`idprof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_bulletin_prof_com`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bulletin_prof_param`
--

DROP TABLE IF EXISTS `TB_bulletin_prof_param`;
CREATE TABLE `TB_bulletin_prof_param` (
`id` int(11) NOT NULL auto_increment,
`idprof` int(11) NOT NULL,
`com` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idprof` (`idprof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_bulletin_prof_param`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bulletin_profp_com`
--

DROP TABLE IF EXISTS `TB_bulletin_profp_com`;
CREATE TABLE `TB_bulletin_profp_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_bulletin_profp_com`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_bulletin_scolaire_com`
--

DROP TABLE IF EXISTS `TB_bulletin_scolaire_com`;
CREATE TABLE `TB_bulletin_scolaire_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_bulletin_scolaire_com`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_calend_evenement`
--

DROP TABLE IF EXISTS `TB_calend_evenement`;
CREATE TABLE `TB_calend_evenement` (
`id_evenement` int(11) NOT NULL auto_increment,
`date` date NOT NULL,
`evenement` text NOT NULL,
PRIMARY KEY (`id_evenement`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_calend_evenement`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_calendrier_dst`
--

DROP TABLE IF EXISTS `TB_calendrier_dst`;
CREATE TABLE `TB_calendrier_dst` (
`id_dst` int(11) NOT NULL auto_increment,
`date` date NOT NULL,
`matiere` varchar(30) NOT NULL,
`code_classe` varchar(30) default NULL,
`heure` time default NULL,
`duree` int(11) default NULL,
PRIMARY KEY (`id_dst`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_calendrier_dst`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_carnet_competence`
--

DROP TABLE IF EXISTS `TB_carnet_competence`;
CREATE TABLE `TB_carnet_competence` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`libelle` varchar(50) NOT NULL,
`ordre` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `libelle` (`libelle`,`idcarnet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_carnet_competence`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_carnet_descriptif`
--

DROP TABLE IF EXISTS `TB_carnet_descriptif`;
CREATE TABLE `TB_carnet_descriptif` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`idcompetence` int(11) NOT NULL,
`libelle` varchar(150) NOT NULL,
`bold` tinyint(4) NOT NULL,
`ordre` decimal(6,0) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idcarnet` (`idcarnet`,`idcompetence`,`libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_carnet_descriptif`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_carnet_evaluation`
--

DROP TABLE IF EXISTS `TB_carnet_evaluation`;
CREATE TABLE `TB_carnet_evaluation` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`idcompetence` int(11) NOT NULL,
`iddescriptif` int(11) NOT NULL,
`note` varchar(20) NOT NULL,
`periode` smallint(6) NOT NULL,
`ideleve` int(11) NOT NULL,
`idclasse` int(11) NOT NULL,
`type_notation` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idcarnet` (`idcarnet`,`idcompetence`,`iddescriptif`,`periode`,`ideleve`,`idclasse`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_carnet_evaluation`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_carnet_section`
--

DROP TABLE IF EXISTS `TB_carnet_section`;
CREATE TABLE `TB_carnet_section` (
`id` int(11) NOT NULL auto_increment,
`libelle` varchar(10) NOT NULL,
`listeidclasse` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `libelle` (`libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_carnet_section`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_carnet_suivi`
--

DROP TABLE IF EXISTS `TB_carnet_suivi`;
CREATE TABLE `TB_carnet_suivi` (
`id` int(11) NOT NULL auto_increment,
`nom_carnet` varchar(40) NOT NULL,
`code_lettre` tinyint(4) NOT NULL,
`code_chiffre` tinyint(4) NOT NULL,
`code_couleur` tinyint(4) NOT NULL,
`code_note` tinyint(4) NOT NULL,
`section` varchar(50) NOT NULL,
`nb_periode` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nom_carnet` (`nom_carnet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of table `TB_carnet_suivi`
--

-- --------------------------------------------------------

--
-- Structure of table `TB_checksum`
--

DROP TABLE IF EXISTS `TB_checksum`;
CREATE TABLE `TB_checksum` (
`sum` varchar(50) NOT NULL,
`fichier` varchar(255) NOT NULL,
`etat` int(11) NOT NULL,
KEY `fichier` (`fichier`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of table `TB_checksum`
--

INSERT INTO `TB_checksum` (`sum`, `fichier`, `etat`) VALUES
('a28eb6e965d295c4b7af00273fdf0c92', './acces.php\n', 0),
('84528465212d1f268a40eb4f76b47e95', './acces2.php\n', 0),
('2694ca36d7010e20c76d0ac7dfbdb2e1', './acces_depart.php\n', 0),
('9d32962364e039ce74f2bac6d4383a2d', './acces_refuse.php\n', 0),
('2bd97aef41bf0c39a2a81d980ece28aa', './accrobat.php\n', 0),
( ```
1
Réponse 6 / 17
ERIC
 
I would like to have a school management software model that includes student grades, behavior, all results, payment...
Thank you.
1
Réponse 7 / 17
djan
 
Go check this site, I think you might find a similar software.
1
Réponse 8 / 17
golddream
 
Hello colleagues
allow me to join you on the objective of designing an application for the management of an establishment. Personally, I just acquired WinDev 9.0, it will do the job except that I am currently solving a problem with coding in the Arabic language
please help me svp golddream@hotmail.fr
0
Réponse 9 / 17
illojic
 
Hello everyone, actually I'm in the same boat, I can't find a coherent solution.
Every time I'm denied the MCD because it doesn't meet all the requirements, I would be grateful if one of you could help me.
If possible, contact me by email
thank you in advance ;)
0
Réponse 10 / 17
Techys
 
Hello,
Hi everyone, this is Techys. Apparently, everyone is in the same boat, as they say, so we can help each other out. First of all, Ousmo seems to have the solution since he says he has developed a similar solution on Access and Windev 7.
The issue now lies on two levels:
The first is the functionalities provided by the software, the second is the modeling of the application, and the third is its development (implementation solution and programming language used).
As it always seems easier to start from what already exists.
I would say that it would be good for OUSMO to shed some light on these three points precisely, then it would be necessary to come to an agreement on starting principles and finally a common development for code harmonization.

That was my contribution, so if you agree, don't hesitate to let me know.
0
Réponse 11 / 17
magi123 Posted messages 18 Status Membre 8
 
sos
merise course (Organizational Treatment Model)
0
Réponse 12 / 17
Techys
 
```sql -- --------------------------------------------------------

--
-- Structure of the table `TB_abs_rtd_aucun`
--

DROP TABLE IF EXISTS `TB_abs_rtd_aucun`;
CREATE TABLE `TB_abs_rtd_aucun` (
`id` int(11) NOT NULL auto_increment,
`classe` varchar(30) NOT NULL,
`date` date NOT NULL,
`heure` time default NULL,
`matiere` varchar(50) NOT NULL,
`enseignant` varchar(80) default NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_abs_rtd_aucun`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_absences`
--

DROP TABLE IF EXISTS `TB_absences`;
CREATE TABLE `TB_absences` (
`elev_id` int(11) NOT NULL,
`date_ab` date NOT NULL,
`date_saisie` date NOT NULL,
`duree_ab` double NOT NULL,
`origin_saisie` varchar(30) default NULL,
`date_fin` date default NULL,
`motif` text,
`duree_heure` int(11) default NULL,
`id_matiere` int(11) default NULL,
`time` time default NULL,
KEY `elev_id` (`elev_id`,`date_ab`,`date_fin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_absences`
--

INSERT INTO `TB_absences` (`elev_id`, `date_ab`, `date_saisie`, `duree_ab`, `origin_saisie`, `date_fin`, `motif`, `duree_heure`, `id_matiere`, `time`) VALUES
(-4, '0000-00-00', '0000-00-00', 0, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure of the table `TB_affectations`
--

DROP TABLE IF EXISTS `TB_affectations`;
CREATE TABLE `TB_affectations` (
`ordre_affichage` smallint(6) NOT NULL,
`code_matiere` smallint(6) NOT NULL,
`code_prof` int(11) NOT NULL,
`code_classe` smallint(6) NOT NULL,
`coef` decimal(30,2) NOT NULL,
`code_groupe` int(11) default NULL,
`langue` varchar(20) default NULL,
`avec_sous_matiere` tinyint(1) NOT NULL,
PRIMARY KEY (`code_classe`,`code_matiere`,`code_prof`,`ordre_affichage`),
KEY `code_classe` (`code_classe`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_affectations`
--

-- --------------------------------------------------------
--
-- Structure of the table `TB_avertissement`
--

DROP TABLE IF EXISTS `TB_avertissement`;
CREATE TABLE `TB_avertissement` (
`id_pers` int(11) NOT NULL,
`type_pers` varchar(20) NOT NULL,
`parametrage` varchar(30) NOT NULL,
`valeur` varchar(30) NOT NULL,
UNIQUE KEY `id_pers` (`id_pers`,`type_pers`,`parametrage`,`valeur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_avertissement`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_blacklist`
--

DROP TABLE IF EXISTS `TB_blacklist`;
CREATE TABLE `TB_blacklist` (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(50) NOT NULL,
`prenom` varchar(50) NOT NULL,
`ip` varchar(30) default NULL,
`navigateur` text,
`date` date NOT NULL,
`nb_tentative` int(11) NOT NULL,
`membre` varchar(20) NOT NULL,
`cause` text,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_blacklist`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bug`
--

DROP TABLE IF EXISTS `TB_bug`;
CREATE TABLE `TB_bug` (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(30) NOT NULL,
`prenom` varchar(30) NOT NULL,
`date` date NOT NULL,
`membre` varchar(30) default NULL,
`action` varchar(30) default NULL,
`service` varchar(30) default NULL,
`commentaire` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_bug`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bulletin_direction_com`
--

DROP TABLE IF EXISTS `TB_bulletin_direction_com`;
CREATE TABLE `TB_bulletin_direction_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
`montessori` varchar(30) default NULL,
`type_bulletin` varchar(30) default NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`,`type_bulletin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_bulletin_direction_com`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bulletin_prof_com`
--

DROP TABLE IF EXISTS `TB_bulletin_prof_com`;
CREATE TABLE `TB_bulletin_prof_com` (
`idmatiere` int(11) NOT NULL,
`idclasse` int(11) NOT NULL,
`trimestre` varchar(30) NOT NULL,
`com` text,
`ideleve` int(11) NOT NULL,
`idprof` int(11) NOT NULL,
`idgroupe` int(11) default NULL,
UNIQUE KEY `idmatiere` (`idmatiere`,`idclasse`,`trimestre`,`ideleve`,`idprof`,`idgroupe`),
KEY `idclasse` (`idclasse`,`idprof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_bulletin_prof_com`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bulletin_prof_param`
--

DROP TABLE IF EXISTS `TB_bulletin_prof_param`;
CREATE TABLE `TB_bulletin_prof_param` (
`id` int(11) NOT NULL auto_increment,
`idprof` int(11) NOT NULL,
`com` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idprof` (`idprof`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_bulletin_prof_param`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bulletin_profp_com`
--

DROP TABLE IF EXISTS `TB_bulletin_profp_com`;
CREATE TABLE `TB_bulletin_profp_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_bulletin_profp_com`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_bulletin_scolaire_com`
--

DROP TABLE IF EXISTS `TB_bulletin_scolaire_com`;
CREATE TABLE `TB_bulletin_scolaire_com` (
`ideleve` int(11) NOT NULL,
`trimestre` varchar(20) NOT NULL,
`commentaire` text NOT NULL,
UNIQUE KEY `ideleve` (`ideleve`,`trimestre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_bulletin_scolaire_com`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_calend_evenement`
--

DROP TABLE IF EXISTS `TB_calend_evenement`;
CREATE TABLE `TB_calend_evenement` (
`id_evenement` int(11) NOT NULL auto_increment,
`date` date NOT NULL,
`evenement` text NOT NULL,
PRIMARY KEY (`id_evenement`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_calend_evenement`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_calendrier_dst`
--

DROP TABLE IF EXISTS `TB_calendrier_dst`;
CREATE TABLE `TB_calendrier_dst` (
`id_dst` int(11) NOT NULL auto_increment,
`date` date NOT NULL,
`matiere` varchar(30) NOT NULL,
`code_classe` varchar(30) default NULL,
`heure` time default NULL,
`duree` int(11) default NULL,
PRIMARY KEY (`id_dst`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_calendrier_dst`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_carnet_competence`
--

DROP TABLE IF EXISTS `TB_carnet_competence`;
CREATE TABLE `TB_carnet_competence` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`libelle` varchar(50) NOT NULL,
`ordre` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `libelle` (`libelle`,`idcarnet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_carnet_competence`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_carnet_descriptif`
--

DROP TABLE IF EXISTS `TB_carnet_descriptif`;
CREATE TABLE `TB_carnet_descriptif` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`idcompetence` int(11) NOT NULL,
`libelle` varchar(150) NOT NULL,
`bold` tinyint(4) NOT NULL,
`ordre` decimal(6,0) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idcarnet` (`idcarnet`,`idcompetence`,`libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_carnet_descriptif`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_carnet_evaluation`
--

DROP TABLE IF EXISTS `TB_carnet_evaluation`;
CREATE TABLE `TB_carnet_evaluation` (
`id` int(11) NOT NULL auto_increment,
`idcarnet` int(11) NOT NULL,
`idcompetence` int(11) NOT NULL,
`iddescriptif` int(11) NOT NULL,
`note` varchar(20) NOT NULL,
`periode` smallint(6) NOT NULL,
`ideleve` int(11) NOT NULL,
`idclasse` int(11) NOT NULL,
`type_notation` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idcarnet` (`idcarnet`,`idcompetence`,`iddescriptif`,`periode`,`ideleve`,`idclasse`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_carnet_evaluation`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_carnet_section`
--

DROP TABLE IF EXISTS `TB_carnet_section`;
CREATE TABLE `TB_carnet_section` (
`id` int(11) NOT NULL auto_increment,
`libelle` varchar(10) NOT NULL,
`listeidclasse` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `libelle` (`libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_carnet_section`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_carnet_suivi`
--

DROP TABLE IF EXISTS `TB_carnet_suivi`;
CREATE TABLE `TB_carnet_suivi` (
`id` int(11) NOT NULL auto_increment,
`nom_carnet` varchar(40) NOT NULL,
`code_lettre` tinyint(4) NOT NULL,
`code_chiffre` tinyint(4) NOT NULL,
`code_couleur` tinyint(4) NOT NULL,
`code_note` tinyint(4) NOT NULL,
`section` varchar(50) NOT NULL,
`nb_periode` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nom_carnet` (`nom_carnet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Content of the table `TB_carnet_suivi`
--

-- --------------------------------------------------------

--
-- Structure of the table `TB_checksum`
--

DROP TABLE IF EXISTS `TB_checksum`;
CREATE TABLE `TB_checksum` (
`sum` varchar(50) NOT NULL,
`fichier` varchar(255) NOT NULL,
`etat` int(11) NOT NULL,
KEY `fichier` (`fichier`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Content of the table `TB_checksum`
--

INSERT INTO `TB_checksum` (`sum`, `fichier`, `etat`) VALUES
('a28eb6e965d295c4b7af00273fdf0c92', './acces.php\n', 0),
('84528465212d1f268a40eb4f76b47e95', './acces2.php\n', 0),
('2694ca36d7010e20c76d0ac7dfbdb2e1', './acces_depart.php\n', 0),
('9d32962364e039ce74f2bac6d4383a2d', './acces_refuse.php\n', 0),
('2bd97aef41bf0c39a2a81d980ece28aa', './accrobat.php\n', 0),
( ```
0
Réponse 13 / 17
luchador Posted messages 22 Status Membre 9
 
Hi
can I get the UML model that you worked on?
thank you ;)
0
Réponse 14 / 17
Techys
 
This is a MySQL file for the school's management application database.
There are a total of 99 tables. It is possible to perform reverse engineering on this file to obtain the MLD and MDC and adapt it to personal needs.

Good luck!
0
Réponse 15 / 17
aggouni
 
I am looking for software to manage my high school, thank you.
0
Réponse 16 / 17
sidifils Posted messages 3 Status Membre
 
Hi, I'm Siddi. I'm also in the same situation as you.
But before that, I'm looking to understand the needs assessment, so if you could help me.
0
Réponse 17 / 17
bmy1982 Posted messages 5 Status Membre 1
 
Hi,
if you still want to have a sample software
to get an idea of what needs to be done, you can
for example download Academy System and install it
https://cloud.bitang.net/FR/acceuil.aspx
0