-
Notifications
You must be signed in to change notification settings - Fork 1
/
README.md~
47 lines (41 loc) · 1.44 KB
/
README.md~
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
#SchoolSys
Open source, Web based Management Information System for schools
##Installation
##Database structure
<pre>
+----------------+
| studentDetails |
+----------------+-------+---------------+
| uniqueID | VARCHAR( 5 ) |<-----|
| name | VARCHAR( 80 ) | |
| yearOfStudyAtAdmission | INT | |
| gender | INT | |
| dateOfAdmission | TIMESTAMP | |
+------------------------+---------------+ |
|
+------------+ |
| testScores | |
+-----------++-------------+ |
| studentID | VARCHAR( 5 ) |<-------------------|
|------>| testID | VARCHAR( 5 ) |
| | subjectID | VARCHAR( 5 ) |<-------------------|
| | score | INT | |
| +-----------+--------------+ |
| |
| +-------------+ |
| | testDetails | |
| +-----------+-+------------+ |
|------>| uniqueID | VARCHAR( 5 ) | |
| type | INT | |
| startDate | TIMESTAMP | |
+-----------+--------------+ |
|
+----------------+ |
| subjectDetails | |
+-------------+--+------------+ |
| uniqueID | VARCHAR( 5 ) |<----------------|
| code | VARCHAR( 3 ) |
| name | VARCHAR( 80 ) |
| description | TEXT |
+-------------+---------------+
</pre>