Online result process system

Question

Hello My Project is Online Result Processing System in asp.net using C# there is problem/confusion about database Design and architecture there is three module 1. Admin 2. Authorized Staff 3. Student Admin Actions Add/Update Staff Add/Update Student Update Own Profile Staff Actions Add/Update Student Update Own Profile Fill Student Result In Student Exam Result Form Student Actions Enter PRN No and Clicks on Submit button and see the whole result.. then i want when Staff enter PRN inStudent Exam Result Form then all the Subjects can be fetch from DB which is Given PRN gives exams of all subjects For example I am Giving FY Second semister(Sem) and my first sem 3 subjects are fail then second sem all subjects and first sem 3subjects are also fetched when the staff enter this PRN please suggest require database for this system

Shubham Kumar · Answer

hi vaibhav result process is heavier process you have to lots of logic to process the result like semester wise  yearly wise special exam(like supplimentery or else) and then you have to make the rule for process result like (just think : in BA exam you pass in all subject but in BEd exam you just have to pass over all no like if full arks is 500 if you gain 300 so you are pass no matter you are fail in a subject or not ) so that type of rule you have make. I will suggest you first gether the all information like 1. How many Course run the college 2. Which course is sem wise  year wise 3. Any course have special condition (Like Environmental Paper) 4. student view (Full info student course of student Subject of student student is regular or private IsExampted or not ).