Secretarial knowledge > Graduation design

Graduation design task book

Topic: Shaoguan TV University Archives Management System Objective: To establish a file computer management according to the requirements of the current file management of Shaoguan TV University. Through the design of a practical system, developers can use the professional theoretical knowledge they have learned to solve the actual application problems. Tasks: First, the file management system specific requirements are as follows:, file input According to the characteristics of the file file, you can enter the volume directory and file directory, save it in the database, and wait for the supervisor to sign. Modifying the data The user has the right to modify the input data that has not been signed. Once the data signed is read-only, it cannot be modified. Query statistics can be queried according to the field or setting conditions, such as query by file number, title, responsibility, date, etc.; statistics on related fields, such as the number of directory records in the volume, the number of files in the file directory; The statistics of the number of files in the volume and the number of files in the annual. Print reports Print and preview according to the actual output form, including the in-volume directory and file directory output in standard format. The system maintenance system maintenance should have user password modification, user registration form and data backup. Changing the password allows the user to change their own password. The user registration form is used to record the date and time the user entered the system, and the registration form can be accessed only by the supervisor. Data backup is used to back up each library table. Other requirements 1 system username and password should be reflected in the data dictionary. 2 requires a beautiful interface and easy operation. It is necessary to provide online help information. Second, the database structure design and requirements 1, table structure list, file list: serial number, C, 3 file number, C, 15 title, C, 70 start and end date, D pages, C, 3 retention period, C, 10 Audit, L Remarks, M, 4, Volume Table: Serial Number, C, 10 File Number, C, 15 File Number, C, 14 Responsible C, 26 Title, C, 70 Date, D Review, L Page, C3 Remarks, M, 4 use registration form: number, N, 10 name, C, 10 use date and time, time and date type, user password table: job number, C, 2 name, C, 8 position, C, 6 password, N 2, 2, the establishment of the data dictionary, given in the form of a table: module description module name module meaning parameter name type value range meaning is called by the following module call the following module file description file description type function or meaning format database Structure Description Field Name Meaning Type Width Value Range Key Field Same Name Field Database Memory Variable Description Variable Name Meaning Type Width Value Range Array The number of modules using instructions encoded encoding variable name you meaning and the range of the width of the type used in database design schedule graduation requirements 1, the preparation phase to determine the issues, gather information, prepare reference materials. 2. System analysis and determination of the implementation plan stage Through the demonstration and analysis of the subject, the technology used is compared with the solution used, and the better solution is selected from a variety of possible solutions. 3. Write programs, perform calculations and experimental analysis stages. Based on design requirements, apply newer theoretical knowledge to determine design principles, calculation methods, and write standardized program flow charts, compile source programs, program debugging and case analysis. Fully meet design requirements. 4. Compile the graduation design specification in accordance with the writing outline in the stage of writing the graduation design specification. 5. Prepare for the defense stage 6. Students who participate in the graduation design at the graduation design stage will be concentrated once a week, and the instructor will give guidance or answer questions. References 1, database base and application Wang Li editor-edited Central Radio and Television University Press 2, VISUAL FOXPRO 6. 0 Practical tutorial Zhou Yimin and other editors of the Science Press 3, Shaoguan TV University archives comprehensive management work regulations and management methods 4, other relevant information Appendix I graduation design paper writing guide Appendix II graduation design writing outline

recommended article

popular articles