Question

Task 2 introduction to software engineering

A nursery wants to keep track of all its products, including plants, fountains, garden hardware (wheelbarrow, shovels etc) and also soil and sand which they sell. They buy all stock from the wholesalers. The management wants to know which staff members have been selling what, and from which wholesaler the products were purchased. There are also times when a customer returns a product for a refund, and such information should be available in the system. The nursery also delivers some items to customers, and they would like to integrate the booking process with the purchasing process. The nursery requires to lodge a business activity for each quarter to the Tax authority (ATO). If there is any inconsistencies or disputes ATO seek clarification from the nursery.

Based on the above scenario

a. Identify all the requirements and categorize them into functional and non-functional.

******b. Draw Context Level and Diagram 0 DFDs. *********

Note : It is important that you state any assumptions you made to justify your model.

for your information :

1. table: Product
   ProductId(Primary Key),
   ProductType(plants, fountains, garden hardware and Soil NOT NULL),
   ProductName(wheelbarrow, shovels etc NOTNULL),
   Description

2. table: ProductSale
   ProductSaleId(Primary Key),
   ProductId(Foreign Key stating which product),
   SaleType(Buy/Sell),
   EmployeeId (If SaleType is Buy, then it will be wholesalerId or if it is sale StaffMemberId),
   ProductPrice,
   TransactionDate(For Audit purpose)
   Quantity
  
3. table: Return
   ReturnId(Primary Key),
   ProductId(Product which is returned; whenever needs to find available products a query of products brought - products sold from ProductSale table + Returns accepted will give remaining stock).
   RefundAmount,
   RefundStatus(Eg: Initiated, Settled and InProgress),
   Quantity(Size of returned product)
  
4. table: Booking
   OrderId(Primary Key)
   ProductId(Product which is ordered),
   Quantity(Information of required product quantity),
   Price(Amount)
   Status(OrderPlaced(Means purchase table has been updated with purchase), InDelivery, Delivered)
   DeliveryCharges(Amount as this is an extra charge)
   CustomerId(For the column EmployeeId in table ProductSale)

With the above table, the nursery can monitor all the above requirements. And for the business activity, they can get all the required information about the buy/sell, refund, profit/loss from the query.

Answer 1

SOLUTION:

Functional Requirements

1. Buy new stock

• Update new product(plants, fountains, garden hardware, sand soil) details
• Update transaction date
• Update wholesaler details (from where the product is bought)
• Update staff member (who bought the product)

2. Sell product

• Update price, quantity & other details of product sold
• Update transaction date
• Update staff member details who sold it
• Update customer details who bought it

3. Return product

• Update quantity & other details of product returned
• Update refund amount
• Check refund status
• Update customer details who returned it

4. Deliver product

• Update quantity & other details of product to be delivered
• Calculate delivery charges
• Check booking status
• Update customer details who booked the product for delivery

5. Lodge business activity

• Update the quarter of the year for the business
• Calculate profit/loss and record it
• Record the buy/sell/return details of the product

Non-Functional Requirements

1. Usability

The most common operations have been streamlined to be performed quickly. The validation and error messages can be understood easily.

2. Maintainability

Modifications to the project can be done in a timely manner and its easy to maintain.

3. Scalability

It is the ability for the program to accommodate high number of products and transactions details.

4. Security Requirements

System will use secured database. The application has the ability to run on numerous platforms. This is can include actual application hosting, viewing, or data portability.