Apply Your Knowledge This section contains four mini-cases. Each case describes a situation, explains your role, and requires you to apply what you learned in the chapter. I Green Design After several years as a successful architectural firm in Southern California, Green Design decided to ex- pand by adding two new business ventures: a civil engineering projects group, and a group for commer- cial building projects. As a senior systems analyst, you have been asked to study the situation and make recommendations. Tasks 1. Should Green Design adopt ERP? Why or why not? Provide specific reasons. 2. Is the experience of other companies relevant? Use the Internet to locate a software platform that may be useful to Green Design. Give a summary of ERP solutions you find for architectural and engineering firms. 3. Should Green Design use separate portals for employees, customers, and suppliers? 4. Before selecting software and hardware for the new system, how should Green Design evaluate ini- tial cost and total cost of ownership? What would be the main components? 2 Passing Lane Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane's information system 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 the server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, Passing lane's president approved your recommendation to create a relational database to handle opera- tions and provide links for the company's shippers and customers. Tasks 1. Review the concept of supply chain management. Although Passing Lane offers services rather than products, could the SCM concept apply to the design of the new system? Why or why not? 2. What would be the advantages of selecting an Web-based architecture for Passing Lane's system? 3. Since the firm is growing rapidly, what design features should be included in the new system to ensure it can grow with the company. 4. Given that Passing Lane currently uses computers for managing their operations, what design considerations should be given to legacy systems? Explain your answer.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Question number 1

Apply Your Knowledge
This section contains four mini-cases. Each case describes a situation, explains your role, and requires you to apply
what you learned in the chapter.
Green Design
After several years as a successful architectural firm in Southern California, Green Design decided to ex-
pand by adding two new business ventures: a civil engineering projects group, and a group for commer-
cial building projects. As a senior systems analyst, you have been asked to study the situation and make
recommendations.
Tasks
1. Should Green Design adopt ERP? Why or why not? Provide specific reasons.
2. Is the experience of other companies relevant? Use the Internet to locate a software platform that
may be useful to Green Design. Give a summary of ERP solutions you find for architectural and
engineering firms.
3. Should Green Design use separate portals for employees, customers, and suppliers?
4. Before selecting software and hardware for the new system, how should Green Design evaluate ini-
tial cost and total cost of ownership? What would be the main components?
2 Passing Lane
Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane's information
system 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 the server and use database
and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday,
Passing lane's president approved your recommendation to create a relational database to handle opera-
tions and provide links for the company's shippers and customers.
Tasks
1. Review the concept of supply chain management. Although Passing Lane offers services rather than
products, could the SCM concept apply to the design of the new system? Why or why not?
2. What would be the advantages of selecting an Web-based architecture for Passing Lane's system?
3. Since the firm is growing rapidly, what design features should be included in the new system to
ensure it can grow with the company.
4. Given that Passing Lane currently uses computers for managing their operations, what design
considerations should be given to legacy systems? Explain your answer.
Transcribed Image Text:Apply Your Knowledge This section contains four mini-cases. Each case describes a situation, explains your role, and requires you to apply what you learned in the chapter. Green Design After several years as a successful architectural firm in Southern California, Green Design decided to ex- pand by adding two new business ventures: a civil engineering projects group, and a group for commer- cial building projects. As a senior systems analyst, you have been asked to study the situation and make recommendations. Tasks 1. Should Green Design adopt ERP? Why or why not? Provide specific reasons. 2. Is the experience of other companies relevant? Use the Internet to locate a software platform that may be useful to Green Design. Give a summary of ERP solutions you find for architectural and engineering firms. 3. Should Green Design use separate portals for employees, customers, and suppliers? 4. Before selecting software and hardware for the new system, how should Green Design evaluate ini- tial cost and total cost of ownership? What would be the main components? 2 Passing Lane Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane's information system 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 the server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, Passing lane's president approved your recommendation to create a relational database to handle opera- tions and provide links for the company's shippers and customers. Tasks 1. Review the concept of supply chain management. Although Passing Lane offers services rather than products, could the SCM concept apply to the design of the new system? Why or why not? 2. What would be the advantages of selecting an Web-based architecture for Passing Lane's system? 3. Since the firm is growing rapidly, what design features should be included in the new system to ensure it can grow with the company. 4. Given that Passing Lane currently uses computers for managing their operations, what design considerations should be given to legacy systems? Explain your answer.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Distributed Database Concepts
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education