Database Management Use the case study below prepare a Requirement Specification

Question

Database Management

Use the case study below prepare a Requirement Specification report, you are required to

Identify two possible user views, determine a mission statement for a database.

Determine mission objectives, determine the functional or user requirement for each user view.

Discuss how to best manage the requirements for these user views.

Note: 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

Explanation / Answer

Every database is intended to perform some specific task to solve some issue. The mission statements provide the purpose of the database and mission objectives are general tasks the user perform in the data available from the database.

Mission statement for the database
"The main goal or mission of this database to improve the process involved in sales and to make the database more effective by eliminating anomalies, inconsistencies, duplication in the data so that it can be effectively used for making business decisions"

Mission Objectives
-> To remove database anomalies
-> To provide high data availability and accessibility
-> To maintain data consistency
-> To remove data duplication
-> To use the data for business decisions
-> To perform analytics on the data

Assumptions
There are 4 entities
Customer -> Stores customer personal information
Product -> Stores product information
Orders -> Store order details
Payment -> Stores payment information

2 User Views
1. Place an order
-> The customer can place an order for the valid items available in the Product entity.
-> The customer cannot place an order if the "Product" is out of stock or not available in the "Product" entity.
-> The customer cannot place an order for another customer on behalf.
-> The order number cannot be same.
-> Customer cannot order more than credit limits.

2. View order
-> Can view the details of order.
-> Can view the status of order information and payment details
-> Cannot view the order details of other customers

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.