Am about writing my final year project and my topic is student transcript generation system. The problem now is that I don't know how a transcript generation system works. someone please put me through on how to go about it using VB. NET.
That's not how it works in the real world. You need to identify your requirements and then figure out how to translate that into a program. How does one do that? Here are some steps to get you started:
Get a copy of your transcript--so you know what one looks like
Make an appointment with a few of your teachers. Tell them briefly about your project and ask them about the process they use to submit your grades. Ask him/her if there are any features that he/she would like that don't currently exist.
Make an appointment with someone in the registrar's office, and find out as much as you can about the process they use to process student grades--you may need to meet with different people as they may do/use different parts. Take pictures or draw sketches of what you see. If a computer system already exists, you may be able to mimic what currently exists. If no computer system exists, document the current process--make sure to meet with multiple people to identify "best practices".
Read a book on software engineering.
Identify approximately how much data there will be. How does one do that? How many students are there at the university? Approximately how many classes does each student take each semester/quarter? Identify the best data structure to hold your data. In this case, it is probably a database. If we use a database, identify which database software can handle the amount of data that will be produced.
Note: Ensure your program provides user access that restricts access to the system. Each user should only have access to the information that is necessary to do his/her job--not to all of the information. Furthermore, if he/she leaves his/her job, access needs to be revoked.