The analysis of the data should be stored in the Student Management System. The previous post (“Part-I Introduction to general aspect of create Database“) and part II itself(“Part II-Step by Step to Create Student Management System using VBA programming“) has created three tables already, please take a look to the other tables:
Score information - Student ID - Subject ID - Attendance - Homework - Assignment - Quiz - Midterm - Final - Project - Academic Year
Enrol information - Enrol ID - Subject ID - Subject Name - Credits - Enrol Date - Scholarship (YES or No), - Scholarship Percentage(%)
Teacher information - Teacher ID - Teacher Name - Gender - Experts/Skills - Faculty ID - Experiences - Contact - Current Address
Students Attedance Information ( Daily) Weekly or monthly (Query Total Attendance) - Student ID - Student Name - Subject ID - Subject Name - Class-Day ( Monday, Tues....) - Class-Timein - Class-Timeout - Permission ( YES or NO) - Reason
Payment information - Invoice ID - Invoice Name - Student ID - Subject ID - Issue Date - Expired Date
In conclusion, this analyze does not mean all information is needed and it depend on your business concepts or model. There are eight tables which will be used in our system which is not included table of user who will be the system users.