Page 86 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

ANNEX IX - DATABASE STRUCTURE

Secondary School Database in BANBEIS (developed in Oracle 9i)
Description of Tables of data entry:

# of
Table Name # of Cols Size Description of Tables
Indexes
BUILDING_INFO 26 2 9M Academic Building information
BUILDING_USE 18 1 2M Use of the academic building
COMMUNITY_SERVICES 13 1 3M Community service information
FURNITURE_TOOLS 10 1 27M Furniture, equipment information
GIS_INFORMATION 47 2 13M GIS location information of the school
GOV’T_FACILITY_DEVELOPMENT 14 1 4M Gov’t. Development facilities information
INC_EXP_INFO 13 1 37M Income and Expenditure information
INST_ADD_INFO 16 2 4M Additional data of the school
INST_INFO 44 2 16M Basic information of the school
MONTHLY_FEES 16 2 6M Student Fees information
PHYSICAL_ADV 50 2 6M Physical facilities information
RESULT_SSC 24 2 20M Examination result of SSC
SPECIAL_SUB 11 1 6M Enrolment in special subject
STUDENT_NO. 24 2 32M Enrolment, attendance, repeater data
Enrolment, promotion, fail, dropout data for earlier
STUDENT_DROP_OUT 19 2 28M
year
TEACHER_STAFF_NO. 17 2 31M Teacher and staff number information
TEACH_NO._QUAL 22 2 7M Number of teacher by qualification of highest degree
TEC_TRAIN 14 1 2M Number of trained teacher data
T_INFO 31 1 53M Teacher and staff's individual basic data

Table BUILD_INFO
Col # Column Name Data Type Not Null? Col # Column Name Data Type

1 YEAR 1 NUMBER(4) Y 16 LIBRARY NUMBER(2)
CHAR(2) Y 17 PRAY_ROOM NUMBER(2)
2 DIV_CODE 2
3 DIST_CODE 3 CHAR(2) Y 18 HOSTEL NUMBER(3)
CHAR(2) Y 19 TEACHER_RES NUMBER(4)
4 THANA_CODE 4
CHAR(2) Y 20 LAB NUMBER(2)
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y 21 OTHERS NUMBER(2)
NUMBER(2) Y 22 COM_ID VARCHAR2(15)
7 BUILD_ID 7
8 BUILD_NO_NAME VARCHAR2(30) 23 G_ID NUMBER(1)
9 BUILD_OWNER CHAR(1) 24 BUILD_COND NUMBER(1)
10 BUILD_TYPE CHAR(1) 25 AGE_BUILD NUMBER(3)
11 FLOOR_NO NUMBER(2)
12 FLOOR_SPACE NUMBER(5)
13 CLASS_ROOM NUMBER(3)
14 OFFICE_ROOM NUMBER(3)
15 TEACH_ROOM NUMBER(3)
16 LIBRARY NUMBER(2)

- 79 -