Orders Department Accounting Department Payroll Department Program Program Program Program Program в Program Program Order Filling System Invoicing System Payroll System Customer Inventory Master File Back Order Inventory Pricing File Customer Master File Employee Master File Master File File

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

Review:

PVF manufactures high-quality wood furniture and distributes it to retail stores throughout the United States. Its product lines include dinette sets, stereo cabinets, wall units, living room furniture, and bedroom furniture. In the early 1990s, PVF’s founder, Alex Schuster, started to make and sell custom furniture in his garage. Alex managed invoices and kept track of customers by using file folders and a filing cabinet. By 1994, business expanded and Alex had to rent a warehouse and hire a part-time bookkeeper. PVF’s product line had multiplied, sales volume had doubled, and staff had increased to 50 employees. By 2000, PVF moved into its third and present location. Due to the added complexity of the company’s operations, Alex reorganized the company into the following functional areas:

  • Manufacturing, which was further subdivided into three separate functions—Fabrication, Assembling, and Finishing

  • Sales

  • Orders

  • Accounting

  • Purchasing

 PINE VALLEY FURNITURE

Alex and the heads of the functional areas established manual information systems, such as accounting ledgers and file folders, which worked well for a time. Eventually, however, PVF selected and installed a network server to automate invoicing, accounts receivable, and inventory control applications.

When the applications were first computerized, each separate application had its own individual data files tailored to the needs of each functional area. As is typical in such situations, the applications closely resembled the manual systems on which they were based. Three computer applications at PVF are depicted in Figure 3-1: order filling, invoicing, and payroll. In the late 2000s, PVF formed a task force to study the possibility of moving to a database approach. After a preliminary study, management decided to convert its information systems to such an approach. The company upgraded its network server and implemented a centralized database management system. Today, PVF has successfully deployed an integrated, company-wide database and has converted its applications to work with the database. However, PVF is continuing to grow at a rapid rate, putting pressure on its current application systems.

Three computer applications at PVF: order filling, invoicing, and payroll

Figure 3-1 

The computer-based applications at PVF support its business processes. When customers order furniture, their orders must be processed appropriately: Furniture must be built and shipped to the right customer and the right invoice mailed to the right address. Employees have to be paid for their work. Given these tasks, most of PVF’s computer-based applications are located in the accounting and financial areas. The applications include order filling, invoicing, accounts receivable, inventory control, accounts payable, payroll, and general ledger. At one time, each application had its own data files. For example, there was a customer master file, an inventory master file, a back-order file, an inventory pricing file, and an employee master file. The order filling system used data from three files: customer master, inventory master, and back order. Today, however, all systems are designed and integrated through a company-wide database in which data are organized around entities, or subjects, such as customers, invoices, and orders.

PVF, like many firms, decided to develop its application software in-house; that is, it hired staff and bought the computer hardware and software necessary to build application software suited to its own needs. (Other methods used to obtain application software were discussed in Chapter 2.) Although PVF continues to grow at a rapid rate, market conditions are becoming extremely competitive, especially with the advent of the Internet and the Web. Let’s see how a project manager plays a key role in developing a new information system for PVF.

 

Imagine you work for Pine Valley Furniture. The board is considering starting a webstore and does not know what is involved in developing a new system. You have been asked to present to the board of directors to help them know what to expect.

Explain why it is important to use systems analysis and design methodologies when building a system. Justify why not to “just build the system” in whatever way appears to be “quick and easy.”

Review the criteria for selecting off-the-shelf software presented in Ch. 2. Identify additional criteria that are, or might be, used to select off-the-shelf software.

Consider if the choice was between alternative custom software developers rather than prewritten packages. Identify the criteria that would be appropriate to select and compare among competing bidders for custom development of an application. Be sure to briefly define each of these criteria.

Briefly summarize the project management process. Explain which of the four phases of the project management process you think is most challenging and how you can mitigate the risks for that stage.

Cite any references according to APA guidelines.

Orders Department
Accounting Department
Payroll Department
Program
Program
Program
Program
Program
в
Program
Program
Order Filling
System
Invoicing
System
Payroll
System
Customer
Inventory
Master
File
Back
Order
Inventory
Pricing
File
Customer
Master
File
Employee
Master
File
Master
File
File
Transcribed Image Text:Orders Department Accounting Department Payroll Department Program Program Program Program Program в Program Program Order Filling System Invoicing System Payroll System Customer Inventory Master File Back Order Inventory Pricing File Customer Master File Employee Master File Master File File
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Networking
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
  • SEE MORE QUESTIONS
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