Activity 1 I. Data and Process Modeling A. Business Activities/Current Operations
Supply Checking The business process also have its supply checking where they check the status of their supply checking where they check the status of their supply. If the supply is still enough for future use, they’ll just continue other business processes and if the supply will not be available, they need to call their supplier for the needed supply.

Reservation Process

The business also have an on-call reservations, where they get order from calls for a certain date. If the stocks is available on the date it will be needed, the reservation will be accepted right away but, if the stocks will not be enough, they’ll need to perform plans for their supplies first, to ensure that they’ll be able to give what the customer needs. But, if the time is not manageable, they’ll need to decline the order. This is for the customer to not get half-worked products.

Order Process

The current operation manages the orders occurred in everyday business transactions. They get the order of the customer and check if the order is available on the products. If it is available they give the order and get the payment. If not then, they still have time to prepare the product for the order. B. Context Diagram

Entity Relationship Diagram

C. Diagram 0 – DFD (Data Flow Diagram)

Activity 2

System Requirements Checklist
Input
* Supplies must be entered manually in the system by the authorized personnel of the Virginia’s Bake Shop. * The authorized personnel must input the personnel information such as name, username privilege.

Process * The system shall record the everyday sales and transactions. * The system manages the orders for reservation. * The system calculate the daily, weekly, monthly, annual transactions and sales. * The system manages the status of stocks.

Output * The system managed the reservation receipt. * The system shows the order list for reservation. * The system must show or print reports of daily, weekly, monthly, and annual transactions and sales. * The system must be able to print report of current status of supplies.

Controls * The system must provide security measures for the safety and confidentiality of the information recorded in the database. * The supplies must be added, changed, or deleted only by owner of the Virginia’s Bake Shop * The selling price must be changed and deleted only by the owner of the Virginia’s Bake Shop. * All transactions must have audit. * The system must maintain separate level of security for users and authorized personnel.
Performance
* The system operation is based on the Virginia’s Bake Shop working hours (4am-9:00pm). * Response time must not exceed 5 second. * The system must be operational 7 days a week, 365 days a year. * The inventory system must highlights the low-stock supplies in the time of its predetermined minimum.

Activity 3
Process Description Model

Generate Report

Manage Sales

Manage Product