reate View 1 as follows: This view is the “Receiving Stocks” view. It must show a list of Product Names, a field for entering the quantity received, and a button, “Update Stocks”. The Purchase Manager will select the relevant Product Name, enter an integer, and click on the button. The button should add the quantity entered above to the StockOnHand field for the specified Product Name, as well as, subtract the quantity entered from the StockInTransit field. The “Output View” must then be updated. See below. Create View 2 as follows: This view is the “Ordering Stocks” view. It shows a list of Product Names and the values contained in following Columns from database: StockOnHand, StockInTransit, ReorderQuantity, ReorderAmount. This information supports the Purchase Manager in making a decision on whether an order is necessary. This view also contains a field for entering a quantity and a button, “Make Order”, for use in making an order. The button should add the quantity entered above to the StockInTransit field for the specified Product Name. The “Output View” must then be updated. See below. Create a Nested View as follows: This view is the “Output View”, which shows the list of Product Names, and all information from the Product table. (_id and price are not necessary) This view must also show two calculated fields for each Product Name: “Valuation” – this is Price * StockOnHand “In-Transit Valuation” – this is Price * StockInTransit This “Output View” must be nested in Views 1 and 2 above. Therefore, if the Purchase Manager is receiving stocks, he/she can also see the updates made in the output view. Similarly, if the Purchase Manager is ordering stocks, he/she can also see the updates made in the output view.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter5: The Repetition Structure
Section: Chapter Questions
Problem 9E
icon
Related questions
Question

You are required to write a Product Management Android application for a small business as described below.

 

The user of the application is the Purchase Manager.

The Purchase Manager requires functionality for decision support on making purchases and updating stock quantities when stocks are received. Viewing of updated stock quantities and stock prices is required.

Using Andriod programming

  • Create View 1 as follows:
    • This view is the “Receiving Stocks” view. It must show a list of Product Names, a field for entering the quantity received, and a button, “Update Stocks”. The Purchase Manager will select the relevant Product Name, enter an integer, and click on the button.
    • The button should add the quantity entered above to the StockOnHand field for the specified Product Name, as well as, subtract the quantity entered from the StockInTransit field.
    • The “Output View” must then be updated. See below.
  • Create View 2 as follows:
    • This view is the “Ordering Stocks” view. It shows a list of Product Names and the values contained in following Columns from database: StockOnHand, StockInTransit, ReorderQuantity, ReorderAmount. This information supports the Purchase Manager in making a decision on whether an order is necessary.
    • This view also contains a field for entering a quantity and a button, “Make Order”, for use in making an order.
    • The button should add the quantity entered above to the StockInTransit field for the specified Product Name.
    • The “Output View” must then be updated. See below.
  • Create a Nested View as follows:
    • This view is the “Output View”, which shows the list of Product Names, and all information from the Product table. (_id and price are not necessary)
    • This view must also show two calculated fields for each Product Name:
      • “Valuation” – this is Price * StockOnHand
      • “In-Transit Valuation” – this is Price * StockInTransit
    • This “Output View” must be nested in Views 1 and 2 above. Therefore, if the Purchase Manager is receiving stocks, he/she can also see the updates made in the output view. Similarly, if the Purchase Manager is ordering stocks, he/she can also see the updates made in the output view.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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.
Similar questions
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT