CS 107 Introduction to Data Processing

Fall 2005

An Exercise in Systems Analysis and Design

UNH Home Page Computer Science Department Home Page Contact Instructor

Syllabus

Assignments

Lectures

In 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:
  • A list of the computer reports that this system will produce
  • The data needed to produce the desired reports
  • A brief description of the computer programs that will be needed for this system.
  • A list of the data items that will be included in the system.
  • Anything else your team determines is necessary to make this project a success.


Bulldog Auto Parts

Bulldog Auto Parts, the leading supplier of auto parts in the Northeast, is looking for a new computer system to help them handle their massive inventory. Your consulting firm has been hired to create the computer system needed. Bulldog has the following requirements for this system.

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