gains Galore Limited. sells a range of products through its Web site, Bargains Galore.com. Bargains Galore Limited has an IT infrastructure that comprises a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process is initiated when a customer logs on Bargains Galore Website. The customer requests the company catalogue and the Web server obtains the current Bargains Galore online catalogue from the ERP system, which sends the catalogue to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or she wants to purchase; the Web server edits the customer input for accuracy (e.g., ensures that all required fields have been selected or filled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web server displays this information on the customer’s screen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g., ensures that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer’s screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the war

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 9HOA

See similar textbooks

Related questions

Question

Bargains Galore Limited. sells a range of products through its Web site, Bargains Galore.com. Bargains Galore Limited has an IT infrastructure that comprises a front-end Web server that interacts with customers and a back-end ERP system that manages the inventory and performs other typical ERP functions. The sales order process is initiated when a customer logs on Bargains Galore Website. The customer requests the company catalogue and the Web server obtains the current Bargains Galore online catalogue from the ERP system, which sends the catalogue to the Web server, and the server displays it to the customer. The customer selects the items and quantities that he or she wants to purchase; the Web server edits the customer input for accuracy (e.g., ensures that all required fields have been selected or filled in) and sends this list on to the ERP system, where the requested quantities of inventory are allocated for the sale. The ERP sends back to the Web server the quantities that have been allocated, and the Web server displays this information on the customer’s screen. The customer verifies that the order is correct and completes the sale by entering his or her shipping and credit card information. The Web server edits this data for accuracy (e.g., ensures that all required fields have been selected or filled in and that the length of the entered credit card number is correct) and sends the credit card information and amount of the sale on to the credit card company. The credit card company sends back a verification number, and the Web server notifies the customer that the sale has been completed by displaying a confirmation number on the customer’s screen. The Web server also notifies the ERP system that the sale has been completed, and the ERP system changes the status of the inventory from allocated to sold, prints a picking ticket or packing slip in the warehouse, and records (on the enterprise database) a sale and an account receivable from the credit card company.

Prepare a system flow chart for Bargains galore Limited

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.