Data Dictionary.doc

Data Items Definition TableTable “Register”NameTypeLengthDescriptionm_IDvarchar10Username for register loginm_pwdvarchar10Password for register loginm_stuIDvarchar10Student ID or staff ID for registerm_truenamevarchar10Real name of registerm_Emailvarchar20Email of registerm_qqvarchar16QQ number of Studentm_typeint10 for student 1 for teacher 2 for administratorTable “Message”NameTypeLengthDescriptionsenderVarchar10the people who send the messagereceiverVarchar10The people who receive the messageMs_datedatetimeWhen send the messageMs_contentTextThe content of the messageTable “course_material”NameTypeLengthDescriptionA_IDvarchar10Username for administrator loginA_pwdvarchar10Password for administrator loginA_namevarchar10Real name of administratorA_Emailvarchar20Email of administratorA_Icardvarchar18Identity card number of administratorTable “Course”NameTypeLengthDescriptionC_IDvarchar10Number of courseC_namevarchar20Course nameTable “online_QA”NameTypeLengthDescriptionQA_IDvarchar8ID for online_QAStart_timedatetimeWhen QA startsEnd_timedatetimeWhen QA endscontentTextThe content of QATable “course_bulletin”NameTypeLengthDescriptionCb_IDvarchar10ID for course_bulletinCb_datedatetimeThe time course bulletin uploadCb_contentTextContent of course bulletinTable “Course_discuss”NameTypeLengthDescriptionCd_IDvarchar10ID for course discussCd_namevarchar10ID for who publish the discussCd_datedatetimeWhen publish the discussCd_contentTextContent of the discussTable “reply”NameTypeLengthDescriptionR_IDvarchar10Reply IDR_whoVarchar10Who publish the replyR_datedatetimeWhen publish the replyR_contentTextThe content of the replyTable “own_course”NameTypeLengthDescriptionC_IDvarchar10The course IDM_IDvarchar10The people who teach or learn this courseTable “own_QA”NameTypeLengthDescriptionQA_IDvarchar10The QA IDC_IDvarchar10The course which has this QATable “own_dis”NameTypeLengthDescriptionCd_IDvarchar10The course_discuss IDC_IDvarchar10The course which has this discussTable “get_reply”NameTypeLengthDescriptionCd_IDvarchar10The course_discuss IDR_IDvarchar10The reply which reply to this course discussTable “own_mt”NameTypeLengthDescriptionCm_IDvarchar10Course material IDC_IDvarchar10The course which has this materialTable “own_bu”NameTypeLengthDescriptionCb_IDvarchar10Course_bulletin IDC_IDvarchar10The course which has this bulletinData Flow Definition TableNO.NameData sourcesData destinationData Structure ConsistDescriptionF1Register information1.E3(Unregistered User)P1(Register Verify)Username+pwd+real name+student ID/teacher ID+Email+qq+ Identity card numberThe register information given by unregister userF2Match resultP2(UserActivate)E4(Teacher)E5(Student)The result of activate resultF3Stu login informationE5(Student)P3(Verify login)Username+passwordStudent login informationF4Teacher login informationE4(Teacher)P3(Verify login)Username+passwordTeacher login informationF5Admin login informationE2(Administrator)P3(Verify login)Username+passwordAdministrator login informationF6Requirement of Activate usersE2(Administrator)P2(UserActivate)Submit the Activateusers buttonF7Requirement of manage courseE2(Administrator)P12(Course management system)Submit the course manage buttonF8Requirement of process course materialE2(Administrator)P4(Course material system)Submit the course material buttonF9Requirement of process Teacher introductionE2(Administrator)P5(Teacher introduction system)Submit the Teacher introduction buttonF10Requirement of process course bulletinE2(Administrator)E4(teacher)P6(Course bulletin system)Submit the course bulletin buttonF11Requirement of process course Q&AE2(Administrator)E4(teacher)P7(Course Q&A system)Submit the course Q&A buttonF12Requirement of process course discussE2(Administrator)E4(teacher)P8(Course discuss system)Submit the course discuss buttonF13Requirement of process course introductionE2(Administrator)E4(teacher)P9(Course introduction system)Submit the course introduction buttonF14MessageE2(Administrator)E4(teacher)E5(Student)P10(Message management system)Sender+title+ content+receiverA short message between one user and anotherF15Requirement of process link introductionE2(Administrator)P11(Course link system)Requirement of adding, updating or deleting course F16resultP4/P5/P6/P7/P8/P9/P10/P11/ P12E6(Web)The content that system show to user requirementThe systems process resultF17Requirement of Get back passwordE4(teacher)E5(student)P14(Get back password system)Username+emailProcess the users requirement of get back passwordF18Requirement of change passwordE4(teacher)E5(student)P13(change password system)Username+old password+new passwordProcess the users requirement of changing passwordF19passwordP14(Get back password system)S2(Users email)The password that user get backF20New passwordP13(change password system)S1(ID database)The new password that user changeF21Requirement of attend course Q&AE5(student)P7(Course Q&A system)Requirement of attend the course Q&AF22instructionE5(student)P15(View the content of website)Student see the content of website(course introduction, teacher introduction and so on)F23Requirement of attend course discussE5(student)P8(Course discuss system)Requirement of attend the course discussF24New course bulletinE2(administrator)P16The New course bulletin given by teacherF25Edit instructionE2(administrator)P17/P20/P23/p26Requirement of Edit F26Delete instructionE2(administrator)P18/P21/P24/P27Requirement of delete F27New course topic or replyE2(administrator)P19New course topic or reply given by administratorF28New course introductionE2(administrator)P22New course introduction give by teacher upload by administratorF29New course linksE2(administrator)P25The new course links is asked to add to this webF30Course materialE2(administrator)P4(Course material system)The course material given by teacher upload by administratorF31Q&A TimeE2(administrator)P29(Set time)Date+hour+minuteThe Q&A time given by administrator according to teachers repuirementData Processing Definition TableNO.NameInputProcessingOutputDescriptionP1Register VerifyF1(Register information)Verify the register informationThe Verified Register informationThe system that verify the register informationP2UserActivateF1(register information)F6(Requirement of Activate users)Match the register information with user listF2(Match result)P3Verify loginF3(Stu login information)F4(Teacher login information)F5(Admin login information)Verify the login informationVerify the login informationP4Course material systemF8(Requirement of Process course material)F16(result)System that process the course materialP5Teacher introduction systemF9(Requirement of process teacher introduction)F16(result)System that process the Teacher introductionP6Course bulletin systemF10(Requirement of process Course bulletin)F16(result)System that process the Course bulletinP7Course Q&A systemF11(Requirement of process Course Q&A) F16(result)System that process the Course Q&AP8Course discuss systemF12(Requirement of process Course discuss)F16(result)System that process the Course discussP9Message management systemF14(Requirement of process Message management)F16(result)System that process the Message managementP10Course introduction systemF13(Requirement of process Course introduction)F16(result)System that process the Course introductionP11Course link systemF15(Requirement of process Course link )Add, delete, update courseF16(result)System that process the Course linkP12Course management systemF7(Requirement of Course management)F16(result)System that process the Course managementP13Change password systemF18(requirement of change password)Match the given information with register informationF20(password)Process the password changingP14Get back password systemF18(requirement of get back password)Match the given information with register informationF19(password)Process the password get backP15View the content of websiteF22(instruction)F16(result)Process the requirement of view website contentP16Publish new course topic or replyF24(New course bulletin)F16(result)Publish the new course bulletinP17Modify the content of discussF25(Edit instruction)F16(result)Edit the course bulletinP18Delete content of discussF26(Delete instruction)F16(result)Delete the course bulletinP19Publish new course topic or replyF27F16(result)Upload the new course discussP20Modify the content of discussF25F16(result)edit the new course discussP21Delete content of discussF26F16(result)delete the new course discussP22Publish new course introductionF28F16(result)Upload new course introductionP23Modify course introductionF25F16(result)Modify course introductionP24Delete course introductionF26F16(result)Delete course introductionP25Publish new course linksF29F16(resu