R/Way Trucking Situation: As you learned in the reading, R/Way is a small but rapidly growing trucking company headquartered in Cleveland, Ohio. R/Way’s information system currently consists of a file server and three workstations where freight clerks enter data, track shipments, and prepare freight bills. To perform their work, the clerks obtain data from a file server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, R/Way’s president approved your recommendation to create a relational database to handle R/Way operations and provide links for R/Way shippers and customers.
a. Review the concept of supply chain management. Although R/Way offers services rather than products, could that concept apply to the design of R/Way’s new system? If so, how?
b. What would be the advantages of selecting an internet-based architecture for R/Way’s system?
c. Should R/Way’s new system be based on file-server or client/server architecture? Why?
d. What would be the pros and cons of selecting in-house development versus a packaged solution for the R/Way system?