TOPIC-7 : SYSTEM DESIGN (Elearning Project)

7.1 ER-Diagram 7.2 Class Diagram 7.3 Table Structure Results Field Name Data Type course_id Number trainee_id Text Marks Number qn1 Number qn2 Number qn2 Number ans1 Number ans2 Number ans3 Number paper_id Number Attempt_id Number Result Number x_masterListOfCategory Field Name Data Type Course_category_id Number Course_category Text x_masterListOfCourses Field Name Data Type Course_id Number Course_category_id Number Course_name Text Course_description Text No_of_papers Number x_masterListOfPapers Field Name Data Type Paper_id Number Paper_no Number Paper_name Text Course_id Number Paper_description Text x_masterListOfDocuments Field Name Data Type Document_id Number Paper_id Number Paper_no Number Document_name Text Document_filename Text Document_description Text _masterListOfQuestions Field Name Data Type Paper_id Number Question_id Number Question Text Choice1 Text Choice2 Text Choice3 Text Choice4 Text Ans Number _master_elearning_user Field Name Data Type User_name Text Pass_word Text First_name Text Designation Text Email Text City Text Country Text _master_trainee_detail_online Field Name Data Type Trainee_id Number Is_regiteres Number Is_attended_exam Number Is_successfully_completed Number Course_completed_date Date Total_marks Number Doe Date User_name Text Course_id Number Paper1_no_of_attempts Number Paper2_no_of_attempts Number Paper3_no_of_attempts Number Paper1_marks Number Paper2_marks Number Paper3_marks Number Paper1_completed_date Date Paper2_completed_date Date Paper3_completed_date Date Paper_id1 Number Paper_id2 Number Paper_id3 Number Is_paper1_completed Number Is_paper2_completed Number Is_paper3_completed Number Paper1_appeared_on Date Paper2_appeared_on Date Paper3_appeared_on Date Is_paper1_tutorial_viewed Number Is_paper2_tutorial_viewed Number Is_paper3_tutorial_viewed Number No_of_papers Number