150 likes | 159 Views
LICEA MEXICANA CANADIENSE CASE STUDY. Chandra S. Amaravadi. DATABASE PLANNING. BACKGROUND. Elementary School in Quaretero, Mexico:. Currently 200, expect 600 Six grades/classes, two sections each Each grade/class has two teachers Total staff is 18; 12 teachers and rest custodial.
E N D
LICEA MEXICANA CANADIENSE CASE STUDY Chandra S. Amaravadi
BACKGROUND Elementary School in Quaretero, Mexico: • Currently 200, expect 600 • Six grades/classes, two sections each • Each grade/class has two teachers • Total staff is 18; 12 teachers and rest custodial
MAJOR PROCESSES • Recording fees, payroll • Ordering uniforms • Monthly planning meetings • Teaching • Reporting to the government • Extra-curricular activities
ECLASSES • Parents • Students • Fees • inscription • uniforms • books • Subjects • Grades • Teachers
ENTERPRISE DATA MODEL.. attend PARENT STUDENTS CLASS participate in pays fees ACTIVITIES FEES Insert uniforms, subjects, grades
PLANNING ISSUES • Database size • Estimated time line • Software • Personnel requirements?
ER MODEL Subjects orders Parent Uniform makes pmt evaluated Student Grade Fees participates taught Class Co-rdi-nated Employee Activity