Part 1 Your supervisor has requested that you design a secure application that w
ID: 668476 • Letter: P
Question
Part 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?
Part 2
Using the information you have determined from the Part 1, 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).
Explanation / Answer
Data fields that are necessary to keep track of this information-
Name of Item, Code for Product , Price of product
Size of Data and Types are as follows-
Char, Int , Float
Restrictions on input are as follows-
No negative values of Item Number
No number for Product name
No alphabet for Price of product