Question

PHP PROGRAMMING

1. Your supervisor has requested that you design a secure application that will keep track of inventory in the warehouse of the ABC Computer Parts Corporation. This application will be accessible both within the warehouse itself, and outside (via the Internet and/or smart phones). What data fields are necessary to keep track of this information? What size and data types (string, Integer, Floating Point) should define these fields? What other restrictions on input (no negative values for item number) should be defined for these fields?

For example if Social Security was a required field:

SSN: SIZE: Min: 9 Characters (string) Max: 9 Characters (string) Restrictions: Valid SSN Format

Notice that it is characters, not Integer because no calculations will be done on as SSN number.

2. Using the information you have determined from the number 1 assignment, and the design techniques shown in this chapter, develop a logical design of the ABC Computer Parts Inventory application. This design should include all possible programs, interfaces, and data storage. The application design must be three tier (Interface, Business Rules, and Data).

Answer 1

The required data fields are as follows

• Warehouse_name
• Product_name
• Product_id(primary key)​​​​
• Product_stock
• Ordered_product
• Order_id
• Delivery_status(Delivered or not)