group:ECOLE

eleves = {
	N_Eleve:number, Nom:string, Prenom:string       
1	'SURENA'	'Adrienne'
2	'SAPIENCE'	'Alain'
3	'SONG'	'Aline'
4	'GIRARD'	'André'
5	'MARTI'	'Anne'
6	'FRANÇOIS'	'Anne-Marie'
7	'GIRON'	'Anne-Marie'
8	'THIAM'	'Anne-Marie'
9	'CHHUOR'	'Anne-Marie'
10	'CHARDON'	'Annick'
11	'LACHAUSSÉE'	'Annie'
12	'PAVARD'	'Annie'
13	'SINSEAU'	'Annie'
14	'DUROC'	'Annie'
15	'BAUDET'	'Arlette'
16	'KRIEF'	'Arlette'
17	'HARAULT'	'Armelle'
18	'TANG'	'Armelle'
19	'LEKA'	'Bernadette'
20	'SCHUSTER'	'Bernadette'
21	'NAIMI'	'Chantal'
}

cours= {
N_Cours:number, Matiere:string, Prof:string
1	'Français'	'DEAUCOURT'
2	'Anglais'	'KAC'
3	'Maths'	'PIDERIT'
4	'Physique'	'LADD'
5	'Maths'	'CAPRON'
6	'Anglais'	'POTRIQUET'
7	'Français'	'BERTOLO'

}

cours_eleves ={
N_CE:number, N_Cours:number, N_Eleve:number, Note:number
78	4	1	10
34	5	1	17
57	7	1	13
5	1	2	9
54	7	2	13
11	2	3	16
37	5	3	15
17	3	4	17
25	4	4	6
51	7	4	17
66	1	5	12
9	2	5	20
47	6	5	8
18	3	6	10
24	4	6	13
29	5	6	20
14	3	7	20
35	5	7	16
43	6	7	10
56	7	7	8
38	2	8	9
23	4	8	11
32	5	8	12
60	3	9	11
39	6	9	14
49	6	9	13
19	3	10	19
71	5	10	13
46	6	10	18
2	1	11	19
41	6	11	8
52	7	11	6
1	1	12	8
50	6	12	18
55	7	12	11
3	1	13	12
44	2	13	20
40	6	13	13
45	7	13	19
6	2	14	9
20	3	14	19
48	6	14	17
27	5	15	15
42	6	15	9
53	7	15	14
12	1	16	10
8	2	16	12
15	3	16	12
22	4	17	16
26	5	17	11
33	7	17	12
4	1	18	18
7	2	18	17
28	5	18	11
61	1	19	12
21	4	19	14
31	5	19	18
10	2	20	8
13	3	20	9
36	5	20	6

}

cours_reels ={
N_CR:number, N_Cours:number, Date:string
1	1	'2016-09-20'
2	3	'2016-09-22'
3	1	'2016-09-25'
4	4	'2016-09-27'
5	5	'2016-10-05'
6	7	'2016-10-09'
7	1	'2016-10-11'
8	6	'2016-10-14'
9	3	'2016-10-16'
10	7	'2016-10-26'

}

cours_eleves_reels = {
N_CER:number, N_Eleve:number, N_CR:number
1	12	1
2	11	1
3	13	1
4	18	1
5	2	1
6	7	3
7	16	3
8	2	3
9	6	3
10	10	3
11	14	3
12	17	4
13	8	4
14	6	4
15	4	4
16	1	4
17	17	5
18	15	5
19	18	5
20	6	5
21	1	5
22	7	5
23	11	6
24	15	6
25	2	6
26	10	6
27	13	6
28	4	6
29	4	7
30	11	7
31	15	7
32	2	7
33	16	1
34	19	1
35	4	2
36	5	6
37	14	6
38	9	6
39	12	6
40	20	3
41	9	3
42	19	3
43	20	7
44	14	7
45	12	7
46	7	7
47	5	8
48	7	8
49	9	8
50	9	8
51	10	8
52	11	8
53	4	9
54	6	9
55	7	9
56	9	9
57	10	9
58	1	9
59	1	10
60	2	10
61	4	10
62	7	10
63	11	10
64	12	10
65	15	10
66	14	10

}