Week 6 Milestone 3 Final(3)

FINAL PROJECT MILESTONE THREE: SYSTEM REUIRMENTS Currently Jingle Bell Building Supply & Lumber Yard, LLC has seen a substantial increase in building material sales and custom cabinet sales. Jingle Bell, LLC is one of the largest building supply companies in the area, as well as the only custom cabinet maker in the area. The Company wants to migrate from their current method of inventory tracking to an inventory control database. Mr. Claus, the owner, would also like to improve the company’s online presence to give a more modern look and feel to the company’s online presence, which will help potential employees easily apply for available jobs and help potential customers get a feel for what the company offers in custom cabinets and building supplies. The development of the inventory control database needs a system requirement models which includes a requirement model, a database process model, a data flow diagram, a data dictionary, an object model, and a case use diagram. Requirements Model Information is collected by using various fact-finding techniques, such as surveys, feedback from end users (stakeholders), analyst of the existing system, interviews, etc. to create a system requirement checklist. Outputs The inventory control database (ICD) will be incorporated into the current system & will improve on the current system. The (ICD) must be able to show the flow of inventory & when quantities are low. The (ICD) must be able to Create New Pick Orders for custom cabinets that tell your staff to get the order ready and what inventory to include. The (ICD) must be compatible with the existing platform. The system must alert the accounting/procurement department when inventory is low Payment confirmation. Inputs Employee input must include item purchased, item quantity, new pick order input.

New Pick Order input must include customer name, customer address, contact number, email address, payment information Process Process The system must record the information in the inventory control database. The system must provide the information or status of the inventory in an accurate manner. The system must update the employee(s) of any changes in the status of the inventory. The system must update the customer of any changes in the status of the custom cabinet order. Performance The system must support at least 8 employees simultaneously. Response time must not exceed 5 seconds. The system must be functional/operational 24x7, 365 days a year. Controls The system must provide access to all the services of the application to the employees after the information has been entered into the inventory control database. The customers’ information must be secured properly. The status of the custom cabinet order can only be provided by the Custom Cabinet Team.

FINAL PROJECT MILESTONE 3: SYSTEM REQUIREMENTS Sales Team End User Payment FIBER INTERNET SERVICE Jingle Bell Inventory Management System Jingle Bell Lumber Yard & Building Supplies Custom Cabinet Team Receives Customer Details ACCOUNTING & PROCUREMENT R e c e i v e s P a y m e n t I n v o i v e s e n t Data Flow Chart Send Deposit Customer Milestone 3: System Requirments Figure 2: Context Diagram DFD for Inventory Management BANK Lumber Request Lumber Sold or Cabinet Order Placed Fills Lumber or Building Supply Order Potential Employee Custom Cabinet Order L u m b e r o r B u i l d i n g S u p p l y P u r c h a s e Order Placed Ship Custom Cabinet Notifiys Iventory Low Inventory Low Notification Places Inventory Order Submits Application Application Submitted S h i p s I n v e n t o r y INVENTORY EMPLOYEE CUSTOMER INVENTORY

ENTITY CONTROL DATABASE INVENTORY PURCHASED SALE IN PROGRESS Inventory control database Employee, Bookkeeping COMPLETED STATUS PURCHASE DELVERY TO CUSTOMER Inventory control database Employee, customer NEW PICK ORDER CABINET ORDER COMPLETED Inventory control database Employee, customer Bookkeeping Process payment Receives payment Sends payment to bank Banking Processing Bank processing for payment Banking entity Inventory Control Database PROCESS PROCEESS NAME DESCRIPTION PROCESS NUMBER PROCESS DESCRIPTION Inventory Control Database A process to manage supply inventory & custom cabinet orders. 0 Input data flow: item purchased, item quantity, new pick order input. Output data flow: Pending Status, low inventory, cabinet order status, payment ENTITIES

CUSTOMER Attributes  Name  Address  Contact Number  Email Address  Payment Information Methods Building Suppy, Lumber Purchase Custom Cabinet order EMPLOYEES Attributes  Name  Age (DOB)  Sex  Address  Contact Number  Social Security Number  Hire date.  Title  Hire rate.  Email Address Methods Get hired. Customer Service Sales BUIDING SUPPLIES CUSTOM CABINETS Attributes  Quantity  Name  Style  Length Methods Get Assembled Get Delivered get purchased OBJECT MODELING Figure 3: Diagrams showing three objects, CUSTOMER, CASE MANAGER, and VEHICLE with their attributes and methods for the mobile application of the claim management system

FINAL PROJECT MILESTONE 3: SYSTEM REQUIREMENTS FIGURE 4: Use case diagram showing inventory control database for Jingle Bell, LLC