Implementation of information gathering component

Assignment Help Database Management System
Reference no: EM13331345

Against the Requirement Specification, you have made the following design to guide your implementation of the prototype. In respect wtih the two phases specified by KitchenwareCity, your program also consists of two components; Information Gathering Component and Information Presenting Component.

The first thing in the program will be two arrays, one for the list of products (namely PRODUCT_LIST in this document) and the other for the corresponding prices (namely PRICE_LIST). Thus, a product item and its price will have exactly the same index in the respecting arrays. (Hint: there is no need for an array to store the Product Codes. They can be just the index in PRODUCT_LIST .)

Task 1 - Information Gathering Component (Functional Requirement 2, 3, 4)

You first need to create two arrays; one (namely orderedProductCodeArr) to store the Product Code of ordered items; the other to store the quantity of ordered item (namely quantityArr). Just like PRODUCT_LIST and PRICE_LIST, an ordered item's Product Code and quantity will be stored at exactly the same index in the respecting arrays. A diagram defining the relationships between PRODUCT_LIST, PRICE_LIST, orderedProductCodeArr, and quantityArr has been drawn in Figure 1.

620_table.png



Figure 1: Relationship Diagram for Arrays

Subtask 1.1 - Pseudocode for Information Gathering Component 

Information Gathering Component is very important to a shopping cart system. You really want to develop a good algorithm for it. As a professional practice, you decided to first make a working plan in pseudocode before putting hands on coding implementation for the Information Gathering component. After the consultation with an experienced software engineer, you have obtained an Activity Diagram (Figure 2). Now lets decipher the flowchart and input the pseudocode as multi-line comments into the program to guide implementation.

Figure 2: Activity Diagram for Information Gathering Component

1265_table1.png

Subtask 1.2 - Implementation of Information Gathering Component
Based on the pseudocode developed in Subtask 1.1, you are to implement the Information Gathering Component in this task.

Subtask 1.3 - Duplicate Order Detection [Challenging task for only extensive study, no extra mark gained. You can skip the task if you like]
KitchenwareCity will appreciate it if an extra feature can be delivered to detect duplicate orders. If an ordered item has already been in the cart, the system should detect the case, and then ask for user confirmation for updating the quantity or not. If the user confirms 'Yes', the stored quantity will then be replaced by the newly entered value; otherwise, the program terminates the current product-adding process and loop back to ask user confirmation for adding a new item or not. Note that the user is not allowed to completely remove an ordered item from the shopping cart.

Reference no: EM13331345

Questions Cloud

Finding the most expensive product item in the shopping cart : Your program needs to be able to find the cheapest product item in the shopping cart. For it you may adopt the same strategy described in Subtask 2.2.
Discuss the relationship between inflation and interest rate : Discuss the relationship between inflation and interest rate. Do an international relationship exist, yes no HOW?
Explain what is the minimum uncertainty : If the x-component of the velocity of an electron can be measured only to a precision of , what is the minimum uncertainty of the position of the electron in the x-direction. ( )
Minimize the current years tax liability : Minimize the current years tax liability. That is, they would like to defer income when possible and take the largest deductions possible, a practice they have followed in the past.
Implementation of information gathering component : Based on the pseudocode developed in Subtask 1.1, you are to implement the Information Gathering Component in this task.
At what level of employment would diminishing returns set : At what level of employment would diminishing returns set in for the variable input?
Ecommerce business from any industry or e-business type. : Case study of an eCommerce business in which you identify a gap, and then propose an innovation to potentially improve the eBusiness.This innovation should be simple but able to make an important contribution to the customer andto the business. You c..
Give two examples of policies from recent history that can : Give two examples of policies from recent history that can be considered as keynesian intervention to economy by us government. Briefly explain how the changed role that keynesian theory ascribed to government has affecte the overall performance of t..
Find the refractive power of her glasses : A person whose near-point distance is 52cm wears a pair of glasses that are 2.2cm from her eyes. Find the refractive power of her glasses

Reviews

Write a Review

Database Management System Questions & Answers

  What is the output when the following script is executed

Determine the answer (expected result) based on your reading of from text book: -  Just show the expected output when you run the syntax.

  Create database to produce reports using surrogate keys

Complete following task. In each exercise, represent answer in both DBDL and with diagram. You may use any of styles for diagram. Create database to produce following reports. Do not use any surrogate keys in design.

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Advantages and disadvantages of working with multiple tables

Write down the advantages and disadvantages of working with multiple tables? Write an example of situation where multiple tables would be suitable in the application.

  Suggestions as to how to track down offenders

What are some suggestions as to how to track down offenders of these crimes you've identified - Computer crime has become a serious matter

  Design database for keeping information of actors

Design a database for Ray. For each director, list his or her number and name and the year he or she was born. If the director is deceased, list the year of death.

  Describe basic mechanisms for accessing relational databases

Determine the technical provisions that would be required to ensure data integrity. Evaluate whether the use of a distributed DBMS structure is appropriate.

  Delete an existing product from the database

Utilise an include statement to refer to connection.php instead of the long version of the database connection code so that you can keep the database more secure. See Notes for more details.

  Identification of data requirements from different user

Structured Methodologies, Data Flow Diagrams, Entity Relationship diagrams, Structured English, Decision Tables and Cohesion/coupling.

  Discuss advantages and disadvantages of xml in application

XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss the advantages and disadvantages of XML in this application.

  Define calculations and format the table

internship at Mountain View Realty, a real estate firm that focuses in the North Utah County area. The previous intern developed a spreadsheet listing houses listed and sold during the last several months. She included addresses, location, list pr..

  Write names and e-mail addresses showing foreign key columns

Illustrate all the data in each of four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd