Page 98 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

# of # of
Table Name Size Description of Tables
Cols Indexes
C_STUDENT_NO 12 0 64K Enrolment, attendance, repeater data
C_SPECIAL_SUB 11 1 320K Enrolment data of special subject
C_ST_DROP_OUT 19 2 4M Enrolment, promotion, fail, dropout data for earlier year
C_TEACHER_STAFF_NO 17 2 4M Teacher and staff number information
C_TEACH_NO_QUAL 20 2 640K Number of teacher by qualification of highest degree
C_TEC_TRAIN 14 1 192K Number of trained teacher data
C_T_INFO 33 1 19M Teachers and employees individual basic information
H_M_STU_NO 21 1 640K Enrolment information of Honors and master’s degree
RESULT_DEEG 19 2 2M Examination result of Degree (Pass)
RESULT_HONS_MST 17 2 640K Examination results of Honors and Masters'
RESULT_HSC 19 2 5M Examination result of HSC
SUBJ_T_STU 27 1 6M Subject-wide Teacher and Enrolment by level
TEACH_APP 19 1 6M Approved and Working post by designation

Madrasah Database in BANBEIS

# of # of
Table Name Size Description of table
Cols Indexes
MBUILD_INFO 24 2 3M Academic Building information
MBUIL_USE 18 1 64K Use of the academic building
MCOMMUNITY_SERVICES 15 1 2M Community service information
MFURNITURE_TOOLS 10 1 10M Furniture, equipment information
MGIS_INFORMATION 47 1 4M GIS location information of the school
MGOVT_FACILITY_DEVELOPMENT 14 1 2M Gov’t. Development facilities information
MGRADE 37 1 4M Description of grade
MINC_EXP_INFO 13 1 17M Income and Expenditure information
MINST_ADD_INFO 17 1 2M Additional data of the school
MINST_INFO 45 2 8M Basic information of the school
MMONTHLY_FEES 20 1 2M Student Fees information
MPHYSICAL_ADV 50 2 3M Physical facilities information
MRESULT_SSC 25 2 14M Examination result of Dakhil (SSC)
MSHADOW_MPO 5 1 448K USERS
MSPECIAL_SUB 11 1 2M Enrolment in special subject
MSTUDENT_NO 25 2 22M Enrolment data
MST_DROP_OUT 19 1 12M Enrolment, promotion, fail and dropout data of earlier year
MTEACHER_STAFF_NO 17 2 21M Number of teacher and staff by designation
MTEACH_NO_QUAL 22 2 5M Number of teacher by highest academic degree
MTEC_TRAIN 14 1 512K Number of trained teacher
MT_INFO 29 1 26M Teacher and Employee individual information

- 91 -