Online result process system

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

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 ).