Determine the functional or user requirement for each user

Assignment Help Management Information Sys

Reference no: EM131925880

Using the case study presented below prepare a Requirement Specification report:

You are required to identify two possible user views, determine mission statement for a database, determine mission objectives, determine the functional or user requirement for each user view, and discuss how to best manage the requirements for these user views.

Note that common business practice allows the reader to make assumptions.

Therefore, you must document your assumptions.

Case Study For The Requirements Specification

A Sales Department has a file of products that they provide to their customers. Each type of product has a unique product number, as well as a description, a cost and a price. The number of the product in stock and the number allocated are updated regularly. When the number in stock decreases to the reorder level, the product is reordered in a pre-decided quantity. The other operations of the Departments can be described as follows:

1. They have a file of customers. Each customer is given a unique customer number. This file also contains customer names that consist of their first and last names, and customer addresses composed of street, city and postcode and the customer telephone number. Each customer has a credit limit, which is used to validate their orders.

2. A customer may place zero, one or more orders at a time, and an order is always placed by one customer alone. Each order is identified by a unique order number. Other information as to orders includes the date due, the total price, and the status, that is, an order may be outstanding, partially delivered, or fully delivered and invoiced.

3. An order may involve one or more than one type of products, and a type of products may be involved in more than one order. For each product being ordered in an order, its quantity, total price, and status (i.e., outstanding, partially delivered, or fully delivered) are recorded and updated regularly.

Reference no: EM131925880

Questions Cloud

Potential markets-business markets : After reviewing the Module Seven resources, compare and contrast brand strategies for at least three different markets. Potential markets include business.

Expensive and magnificent solutions : Compare and contrast Rory Sutherland's concept of "frame of reference" marketing to that of expensive and magnificent solutions.

Did the current ratio increase or decrease : Course Name: FIN 320 Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease?

Decisions about investing in human capital : How might increasing payroll tax rates affect young individuals' decisions about investing in their human capital by pursuing higher education

Determine the functional or user requirement for each user : Determine the functional or user requirement for each user view, and discuss how to best manage the requirements for these user views.

Inflation rate and unemployment rate : There is a short-run tradeoff between inflation rate and unemployment rate. In the short-run the tradeoff of between inflation rate and unemployment rate

Calculate savings apc aps mpc mps and autonomous consumption : Calculate Savings, APC, APS, MPC, MPS, and autonomous consumption from the above given information.

Answer the questions put to john : Answer the questions put to John - hospital be shut down when I don't think it should be? Do I go along? Do I blow the whistle

Pequod production function and its costs : Is there a theoretical relationship between the Pequod's production function and its costs? Discuss.

User Account

All Pages