杂志订阅系统课程设计报告.docVIP

管理信息系统(英文) 课程设计报告 专业：信息管理与信息系统 班级 学号：1042803109 姓名：王静娴 题目名称：杂志订阅系统 指导老师：吴水娟 完成日期：2013年6月23日 经管院信管班 实验六 Magazine Subscription System (杂志订阅系统) 实验学时：10学时 实验类型：综合 实验要求：必修 一、实验目的 1. Cultivate the ability of analyzing, designing, and developing an entire information system. 2. Enhance the capability to analyze problems and solve the problems 3. Train student to prepare documents 二、实验内容和步骤 The Magnif-mag Magazine Subscription Company has operated for a number of years and has always allowed subscribers to subscribe to a wide variety of up-to-date sought after magazine titles. You have been asked to set up a prototype magazine subscription system using VISUAL-FOXPRO. The following tables and relevant fields have been provided. You may add other relevant fields where appropriate. Subscriber SubscriberID, Subscribername, Address Subscription SubscriberID, MagazineID, Begin-date, End-date Magazine MagazineID, Magazinename, Category, Qtyinstock Magedition MageditionID, MagazineID, Editionnumber, Offering Question 1 a) Draw an E-R diagram of your proposed database structure. b) d) Enter at least 10 subscribers, 8 magazines and 25 magazine editions and at least 15 subscriptions. e) Draw the DFDs for this system Question 2 Use VISUAL-FOXPRO. to create an input screen Question 3 Use the VISUAL-FOXPRO report generator to produce the following reports: a) A list of all subscribers who have subscriptions beginning after a certain date. b) A list of all subscribers with their corresponding subscriptions. c) A report of your own choice. Describe who will use your report, its purpose, and how it is suitable for this purpose. Question 4 a) Draw a diagram of a menu hierarchy for your system. Question Question 5 Produce a section of a user manual for the entry screen you created in question 2. The manual is to be used mainly by staff that has had li