Namshi Online Shopping - Business Rules and New Customer Orders Processing System - Case Study Example

Description of the organization and the decision problem Namshi online shopping is an online shopping business located in the Middle East. The company focuses on providing fashion as well as footwear. The company provides a broad range of local as well as global brands in the region and also in-house brands. Namshi guarantees its clients of contentment as well as soothe while shopping, which is the reasons the company assures its customers of the latest brands as well as superior services standards by way of astonishing customer engagement. Business rules for Namshi Online shopping Delivery method Rush order? Any fragile Item? Any Specialty Item? Category of customer? Destination of order? Picked up b y clients NO NO NO Silver - Shipped by normal services Yes Yes Yes Gold Local Shipped by premium services Yes no Yes Platinum Remote Decision problem The growing traffic jam in the company system leads to long least of pending customer placement order for approval which affect both the company and the customer in ensuring that the best quality if provided on time. Namshi online shopping isn’t is facing customer traffic each day in their website with the need of customers searching for the latest fashion trending as well as placing orders for the existing as well as new fashions and brands to come. In this regards, the customer order processing procedures is slow and takes long time since, a customer need to following a long procedure in placing an order that leads to intricacies since, the process isn’t optimized with the accounting and sales department being authoritative for the endorsement of the customer orders awaiting on the sort of the order placed. Where the accountant allows a customer order, he should inform the senior accounting department by providing a list of reports on approved customer orders will is inclusive of the information relating to endorsed orders. Furthermore, the segments accountants, as well as the sales department, are responsible for providing their quarterly report of the scheduled year to the senior accountant who must uphold the register for the customer order processing register for a unique year. There aren’t any chances to inspect the report as well as find out the range for improving in view of the fact that accounting department isn’t in receipt of any instantaneous report. They are in receipt of the present quarter’s situation in the month and thus the top executives aren’t being in a position to report in a suitable manner and consequently the present customer orders processing system for Namshi online shopping is taking intricate and time-consuming. It commands a more automated as well as much synchronized system that leads the organization to have a more effectual system to put up with the entire customer order placement. The customer order processing system in the company with an acquaintance of the function by the customer for customer order which implies that the system needs to submit to the accounting and sales department at least once a week from the time the order was placed. This department is, therefore, responsible for corroborating the suitability and then confirming and submitting the applications to the senior accountant for approval the obligation of the senior accountant is complex in ensuring that there aren’t any pending customer orders online Proposed new customer orders processing system The new system is explained and also the aim of the new system is established in order to ensure that there is reduced customer order pending list, enhanced data dependability as well as improved automation in the customer order processing system for Namshi online shopping. The customer order processing will commence at the point where the customers enter the details of the product, his personal details and submit it online. The system will then validate the qualification of the customer for the sorts of the orders. Where the customers are a warrant to order, a corroboration message is added to the pending order list.The new system will be a web-based system which will ensure that the customer order placement and tracking are simple for the accountant and the sales department in order to ensure that there is a less pending list of customer’s orders as well as swift transaction online. Furthermore, the anticipated customer order processing system will benefit senior accountant and the sales department priority of the sorts of the orders. Where there are more than one customer orders placed for the same product, the system will use the priority of the pending list. It is the duty of the senior accountant to corroborate the pending list frequently. Furthermore, the anticipated new customer order placement system will benefit the company as well as many resources with immediate reports processing as weak as the accountant will be able to plan well and also the anticipated system will be important in making an informed decision by the manager and the senior accountant of Namshi Online shopping. Types of data needed as input into decision-making model The financial data will be used from the customer placement list since; the information collected here is significant in developing a new system. Adept real time data warehousing, data management aptitude and also sophisticated report conception are the very essentials and of concerns in the new system. The key feature of the new system is detailed at length with prototype-planning stage, test stage, and plan stage. This rule is appropriate to entire customer orders processing rights. Suitable data model to manage the data Data Flow Diagram (DFD) Where the customer places an order in the system, a confirmation from the system will automatically check whether the product existing in the store as well as issues a message to the customer and generates the shipping order to the warehouse. Where the order is shipped to the clients are billed as well as the system prints the reports automatically. The data flow diagram as depicted above creates the form that the order processing procedure is controlled in the system in entirety. Entity Relationship Diagram (ERD) The Entity Relationship Diagram (ERD) for the customer order process for Namshi online stores above. Normalized relations (1FN) In 1NF, now repeating groups are separated into new table. Customer Sales Order No. Date Customer No. Customer Name Customer Address Sales Order Sales Order No. Item No. Description Quantity Unit Price Normalized table of 2NF Customer No. Customer Name Customer Address Sales Order No. Date Customer No. Normalized table of 3NF customer Sales order Sales Detail Item Customer No. Sales order No. Sales order No. Item No. Customer Name Date Item No. Description Customer Address Customer No. Quantity Price How the proposed model assists a decision maker at the strategic, senior accountant or operational level The manager will be in a position to make an informed investment decision where the new system is installed and operational as well as it will make sure that the there is less paperwork and less time in customer order processing by the system which in turn would lead to saving time and cost to the company due to faster and efficient system procedure for both the customers as well as the company. The improved automation of the customer order processing system for Namshi online shopping is important since, the new system will ensure that the business operation is enhanced in terms of less traffic in the system with a less pending list of customer order and consequently leading to improved sales and retained profits to the business as well. The six queries that will be generated by the system are as follows. This would lead to saving of more time and faster customer order placement process and consequently the new system is efficient due to the fact that customer will able to comprehend the state and extend of their pending order list awaiting approval from the Namshi online stores while another customer will just place orders at home, office are their convenient place and they will get the product delivered at their door place or place provided by the customer in the system. SQL Queries Store, Aisle, Products create table store (         sid int primary key not null auto_increment,         s_name text); insert into store (sid, s_name) values         (301,"The Emporium"),         (302,"Cleaning made Easy"); create table aisle (         aid int primary key not null auto_increment,         a_sid int,         a_name text); insert into aisle (aid, a_sid, a_name) values         (201, 301, "African Products"),         (202, 301, "Chinese Products"),         (203, 302, "Products for Bathrooms"),         (204, 302, "Products for Outhouses"); create table product (         pid int primary key not null auto_increment,         p_aid int,         p_name text, How these commands help in the decision SQL are instituted by companies in order to access as well as manipulate information as well as data is stored in the database which is significant in making an informed decision about the existing stocks in stores as well as the magnitude of customers order each. The relevance of this is that it will help the business in having an effective inventory management system. Reference list C.J. Date, “An Introduction to Database System”, Ed. 7th. India: Pearson Education Singapore).Pte. Ltd, 2002. Craig Larman, “Applying UML and Patterns”, Ed. 2nd. India: Pearson Education (Singapore) Pte. Ltd, 2002. Appendices Financial 2015 AIR - SHIPMENT SEA - SHIPMENT LAND - SHIPMENT MISCELLANEOUS IMP EXP IMP EXP IMP EXP 1ST Quarter 1154153.00 1022081.00 910413.00 127670.00 50000.00 50000.00 263388.00 2ND Quarter 2376386.00 2269937.00 436331.00 238928.00 103020.00 6875.00 15220.00 3RD Quarter 1990042.00 1442838.00 790120.00 251887.00 61831.00 10586.00 19321.00 4THQuarter 2378296.00 1175172.00 1617240.00 284652.00 18957.00 43096.00 7536.00 Total QAR 7898877.00 5910028.00 3754104.00 903137.00 233808.00 110557.00 305465.00 Read More