Design of Database Teaching Model

Running head: SYSTEM ANALYSIS AND DESIGN
Stage 2: Requirement Specification
Name of the Student
Name of the University
Author Note

1
SYSTEM ANALYSIS AND DESIGN
Table of Contents
Functional requirements..................................................................................................................2
Technical requirements....................................................................................................................4
System scope diagrams....................................................................................................................6
Context diagram...........................................................................................................................6
Use case diagram.........................................................................................................................7
Data flow diagram...........................................................................................................................8
Process models.................................................................................................................................9
Structure English.........................................................................................................................9
Decision table..............................................................................................................................9
Decision tree..............................................................................................................................10
Bibliography..................................................................................................................................11

2
SYSTEM ANALYSIS AND DESIGN
Functional requirements
The main objective of PEP is to track the invoice and inventory results and to ensure that all the
payments of customers are collected efficiently. With the use of functional requirements it will
become easy to design the new system that will enhance the overall business activities.
1. Output requirements
Invoicing report: Displays the status of the marketing department on the monthly basis.
Accounts receivable report: the payments processed by the customers are processed within the
Accounts receivable department.
Overdue report: Invoice associates are responsible for finding the accounts that haven’t paid the
money.
2. Input requirements
2.1. For invoice report the data that are needed includes o Customer Organization Name
Customer Street Address
Products Ordered
Product Ordered Date
Quantity
Product Pricing
2.2. Accounts receivable report requires certain data for proper processing. This includes:
Customer Organization Name
Quantity

3
SYSTEM ANALYSIS AND DESIGN
Products Ordered
Quantity Discount (Calculated Field
Electronic Invoicing (Check Box)
Electronic Payment (Check Box)
Product Pricing
Products Shipped
Product Ship Date
Amount Paid
2.3. For the purpose of managing data in overdue report, the data elements required are:
Customer Organization Name
Product Ordered Date
Amount Due (Calculated Field)
Amount 30 Days Overdue (Calculated Field)
Amount 60 Days Overdue (Calculated Field)
Amount Greater Than 60 Days Overdue (Calculated Field)
2% Overdue Amount (Calculated Field)
Product Ship Date
Quantity
Product Pricing
Calculated Price (Calculated Field)
3. Processing requirements