Stock Management | Database | Assignment

Running head: DATABASE
Database
Name of Student-
Name of University-
Author’s Note-

1DATABASE
Table of Contents
1. Two activity Diagrams................................................................................................................1
1.1 Activity Diagram 1................................................................................................................1
1.2 Activity Diagram 2................................................................................................................2
2. Event table...................................................................................................................................3
3. User Stories and acceptance Criteria...........................................................................................4
4. Data flow Diagram......................................................................................................................5
4.1 Context Diagram....................................................................................................................5
4.2 Level 0 DFD Diagram...........................................................................................................6
4.3 Level 1 DFD Diagram...........................................................................................................6
5. Data Dictionary............................................................................................................................7
6. Process Descriptions....................................................................................................................7
7. Use Cases.....................................................................................................................................8
7. 1 Use Case 1............................................................................................................................8
7.2 Use Case 2.............................................................................................................................9
7.3 Use Case 3...........................................................................................................................10
8. Use Case Descriptions...............................................................................................................10
Bibliography..................................................................................................................................13

2DATABASE
Note: The subsystem that is taken for this report is Stock Management
1. Two activity Diagrams
1.1 Activity Diagram 1
Figure 1: Activity Diagram
(Source: Created by Author using Visio)

3DATABASE
1.2 Activity Diagram 2
Figure 2: Activity Diagram
(Source: Created by Author using Visio)

4DATABASE
2. Event table
Event Use Case Source Action Destination
Customer login Login from
Ceylon Textile
Supplier Use
case
Customer The customer needs to login
in the new system so that
they can view all the
products that are available in
CTS
System
Customer
places order
Place Order Use
case from
Ceylon Textile
Supplier
Customer The customer places the
order over the phone or over
mail so that they can get the
product delivered.
Sales Team
Checking the
stock in the
inventory
Checks
Inventory
Sales
Team
The sales team after
receiving the purchase orders
checks the inventory if the
stock is available or not.
Purchase
Team
Short of stock
results to place
Order
Places Order Sales
Team
If the stock of a particular
item is below the stock level,
the order of the item is given
to supplier so that it could be
restocked as soon as
possible.
Supplier
Gives Delivery
Note
Provides
Delivery Note
Supplier The supplier provides the
delivery note after supplying
Stock Team

5DATABASE
the product to the company.
Generates
Return Note
Provides Return
Note
Customer The customer provides
return notes with which the
stock manager updates the
stock master file
Stock Team
3. User Stories and acceptance Criteria
User Story 1:
1. The system is to store the details of all the items that are present in the inventory.
2. The system need to get the details of Good In staffs and the Goods Out staffs so that they
can update the sales and the stock in the system.
Acceptance Criteria 1:
1. The customer needs to place an order so that check can be done for present inventory and
items packing can be done so that delivery of product to the customer sis done without any
difficulty.
2. The sales team need to provide the delivery note and the dispatch note to the stock team so
that further processes are carried out.
User Story 2:
1. The stock manager is to call the supplier can do purchase order if the stock level is low for a

6DATABASE
particular item in the inventory.
2. The stock manager has to check the products available with the supplier before placing the
order.
Acceptance Criteria 2:
1. Before placing the order, the stock manager has to make a list of all the products that are npt
available in the inventory.
4. Data flow Diagram

7DATABASE
4.1 Context Diagram
Figure 3: Context Diagram
(Source: Created by Author using Visio)

8DATABASE
4.2 Level 0 DFD Diagram
Figure 4: Level 0 Data Flow Diagram
(Source: Created by Author using Visio)
4.3 Level 1 DFD Diagram
Figure 5: Level 1 Data Flow Diagram
(Source: Created by Author using Visio)

9DATABASE
5. Data Dictionary
Table Column Data type Size
Orders Customer Account
Number
INT 10
Sales order Number INT 50
Delivery address VARCHAR 100
Special Instructions VARCHAR 100
Packer VARCHAR 50
Date Dispatched DATE
Product Name VARCHAR 50
ProductID INT 10
Size INT 10
Colour VARCHAR 20
6. Process Descriptions
1.0 Checks Stock: The stock manager checks the inventory stock so that he can update
on the product to get the details of the product. If the inventory is out of stock, the products are
restocked by providing purchase orders from the suppliers.
3.0 Update Stock File: This process is held by the stock manager so that the stock
present in the inventory is known to the stock master and the sales department. The stock file is
updated with the number of purchase order. This indicates that particular order number is in

10DATABASE
order. In this process, if supplier restocks a particular product, the delivery date for the product is
filled in.
7. Use Cases
7. 1 Use Case 1
Figure 6: Use Case Diagram of CTS
(Source: Created by Author using Visio)

11DATABASE
7.2 Use Case 2
Figure 7: Use Case Diagram of Stock Control
(Source: Created by Author using Visio)

12DATABASE
7.3 Use Case 3
Figure 8: Use Case Diagram of Stock Control
(Source: Created by Author using Visio)
8. Use Case Descriptions
Use Case Name Checks Inventory
Scenario Stock manager checks the inventory
Triggering
Event
The sales team provides sales order note and dispatch note and delivery
note to the stock manager.
Brief
Description
Stock so that he can update on the product to get the details of the
product. If the inventory is out of stock, the products are restocked by
providing purchase orders from the suppliers.
Actors Stock team

13DATABASE
Related Use
Case
Calls Supplier
Pre-conditions The sales team provides sales order to the stock team so that they can get
the details of the stocks that are to be restocked.
Post-Conditions The stocks are restocked for completing the purchase order for the
customer who have ordered products from the company.
Flow of
Activities
Actors System
Sales manager The sales manager checks the inventory and
completes the checking of the product sin the
system so that they stock can be restocked to get
the product from the supplier.
Use Case Name Update Stock Holding level
Scenario The stock holding level of the system is being updated.
Triggering
Event
When the stock manager gets the delivery note and the return note from
the customer and the supplier.
Brief
Description
This process is held by the stock manager so that the stock present in the
inventory is known to the stock master and the sales department. The
stock file is updated with the number of purchase order. This indicates
that particular order number is in order. In this process, if supplier
restocks a particular product, the delivery date for the product is filled in.
Actors Stock Team

14DATABASE
Related Use
Case
Provides delivery Note and Provides return Note
Pre-conditions Delivery Note and Provides return Note are to be present with the stock
manager to update.
Post-Conditions The stock level will be updated to complete the stock process.
Flow of
Activities
Actors System
Stock team The stock file of the company will be updated to
complete the process.

15DATABASE
Bibliography
Afanasyev, A.N., Voit, N.N., Voevodin, E.Y. and Gainullin, R.F., 2015, October. Control of
UML diagrams in designing automated systems software. In 2015 9th International Conference
on Application of Information and Communication Technologies (AICT) (pp. 285-288). IEEE.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-
oriented approach with UML. John wiley & sons.
Dhukaram, A.V. and Baber, C., 2016. A systematic approach for developing decision aids: From
cognitive work analysis to prototype design and development. Systems Engineering, 19(2),
pp.79-100.
Gulia, S. and Choudhury, T., 2016, January. An efficient automated design to generate UML
diagram from Natural Language Specifications. In 2016 6th International Conference-Cloud
System and Big Data Engineering (Confluence) (pp. 641-648). IEEE.
Maylawati, D.S., Darmalaksana, W. and Ramdhani, M.A., 2018, January. Systematic design of
expert system using unified modelling language. In IOP Conference Series: Materials Science
and Engineering (Vol. 288, No. 1, p. 012047). IOP Publishing.