CS 107 Introduction to Data ProcessingFall 2005An Exercise in Systems Analysis and Design |
UNH Home Page | Computer Science Department Home Page | Contact Instructor |
SyllabusAssignmentsLecturesIn Class Work |
Your team of "consultants" is to design, to the best your ability, a computerized system to meet the needs of your "client". At the end of this exercise, your team should turn in the following information:
|
Customer orders will be entered via computer during the companyÕs business hours. Each order will have the following information.
Customer name
Customer # - unique
Customer address
For each part the customer is ordering
Part #
Quantity ordered
Bulldog currently has a manual inventory system that they wish to have computerized. For each of the parts in the warehouse, Bulldog maintains the current information:
Part # - unique
Part description
CustomerÕs price for the part
Number currently on hand
Re-order point
Supplier #
Part cost to Bulldog
At the end of the business day, an invoice is created for each customer. At the time that the invoice is created, the current inventory levels will be adjusted for the parts that have been ordered during the day. After all of the invoices have been processed, Bulldog needs to have a printed report showing all of the parts that have been sold, the total amount that customers owe for parts, the number of parts still in the warehouse, and some type of flag for any part that has fallen below a re-order point.
To recap, your companyÕs job is to create a system that will do the following:
Last Updated: 11/9/05 |