This assignment is based on the analysis and design


This assignment is based on the analysis and design of a computerised stock control system for a stationery shop that sells a variety of paper, folders, envelopes, printer cartridges, pens, etc. The Scenario The stationery shop requires a computerised record system for the monitoring and ordering of stock. The current system is a manual system for recording purchases made and for monitoring stock levels and determining when to order new stock and how much to order. Customers who wish to pay by debit card, credit card or cheque must register with the store. Many customers opt to pay by cash and not give their details to the store. It is hoped that the computerised system will ensure that sufficient stock levels are maintained for all items in the store. The generation of reports will allow the manager to target the marketing of products to specific customers based on their previous purchases (for example small businesses may order printer cartridges and paper in bulk) and keep a close check on the financial performance of the shop. The manager will have overall control of the system but the sales staff will be responsible for updating all records as new customers are added, as customers make new purchases, and as new stock is delivered. The sales staff will require access to view customer records and stock records in order to check details of specific customers and stock items. The manager will want regular reports of total items bought in each month by stock item, and also the total stock in the shop at any time. Task 1 - 30 Marks The shop manager requires the following reports: Report 1 A monthly list of the total number of items purchased, by stock item, listing number sold, purchase price and total payment received for each stock item. Report 2 A list of the total stock in the shop, by stock item, listing stock item and number in the shop. This list can be generated at any time for stocktaking purposes. Using JSP techniques and methodology analyse the requirements for both reports. Produce diagrams for each report showing the step-wise progression. Diagrams should include: • logical data structure diagrams (DSDs) (5 marks for each report) • preliminary program structures (PSDs) • the detailed program specification for each report (5 marks for each report) Task 2 - 20 Marks a) Write the pseudocode for both reports. (5 marks for each report) b) Draw a flowchart for both reports.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: This assignment is based on the analysis and design
Reference No:- TGS0146217

Expected delivery within 24 Hours