Case study-logic and programming


Case Study- Logic and programming

Brief Case Study For The Requirements Specification Document

Project description:

Brief Case Study For The Requirements Specification Document

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.

Determine the user views and their requirements following the example in Chapter 11. Click on the link for more directions/instructions.
Requirement Specification

You are required to identify at least two possible user views and how to best manage the requirements for these user views. – objectives & major views. With this task in mind, create a report that identifies high-level requirements for each user view and shows the relationship between the user views.

Conclude the report by identifying and justifying the best approach to managing the multi-user view requirements.

Note: Common business practice allows the reader to make assumptions. Therefore, you must document your assumptions and then proceed to develop your conceptual and logical design models.

Solution Preview :

Prepared by a verified Expert
Other Subject: Case study-logic and programming
Reference No:- TGS01437891

Now Priced at $15 (50% Discount)

This paper describes about conceptual and logical design of sales database system. A Sales database is a system which maintains information about the customers who made an order about particular product.It also maintains status of the product delivery like outstanding,fully delivered,and invoiced. To accomplish this work I worked with Lucidchart tool which is a open source online tool and final result have been converted into pdf format.

Recommended (99%)

Rated (4.3/5)