Evergreen Nurseries Evergreen Nurseries offers a wide range of lawn and garden products to its customers. Evergreen Nurseries conducts both wholesale and retail operations. Although the company serves as a wholesaler to nurseries all over the United States, the company’s founder and president has restricted its retail operations to California, the company’s home state. The company is situated on 150 acres and wholesales its bulbs, perennials, roses, trees, shrubs, and Evergreen Accessory products. Evergreen Accessory products include a variety of fertilizers, plant foods, pesticides, and gardening supplies. In the past five years, the company has seen a phenomenal sales growth. Unfortunately, its information systems have been left behind. Although many of Evergreen Nurseries’s processing activities are computerized, these activities require reengineering. You are part of the project team hired by Seymour Davis, the company’s president, to renovate its wholesale division. Your project team was hired to renovate the billing, order taking, and inventory control systems. From requirements determination, you discovered the following. An Evergreen Nurseries customer places a call to the nursery. A sales representative takes the order, verifies the customer’s credit standing, determines whether the items are in stock, notifies the customer of the product’s status, informs the customer if any special discounts are in effect, and communicates the total payment due. Once an order is entered into the system, the customer’s account is updated, product inventory is adjusted, and ordered items are pulled from stock. Ordered items are then packed and shipped to the customer. Once each month, a billing statement is generated and sent to the customer. The customer has thirty days to remit payment in full; otherwise, a 15 percent penalty is applied to the customer’s account. a. Construct a context data-flow diagram, illustrating Evergreen Nurseries’s wholesale system. b. Construct a level-0 diagram for Evergreen Nurseries’s wholesale system. c. Using the level-0 diagram that you constructed in part b, select one of the level-0 processes and prepare a level-1 diagram. d. Exchange your diagrams with those of another class member. Ask your classmate to review your diagrams for completeness and consistency. What errors did he or she find? Correct these errors

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

Evergreen Nurseries
Evergreen Nurseries offers a wide range of
lawn and garden products to its customers.
Evergreen Nurseries conducts both wholesale and retail operations. Although the
company serves as a wholesaler to nurseries all over the United States, the company’s
founder and president has restricted its retail
operations to California, the company’s home
state. The company is situated on 150 acres
and wholesales its bulbs, perennials, roses,
trees, shrubs, and Evergreen Accessory products. Evergreen Accessory products include
a variety of fertilizers, plant foods, pesticides,
and gardening supplies.
In the past five years, the company has
seen a phenomenal sales growth. Unfortunately, its information systems have been left
behind. Although many of Evergreen Nurseries’s processing activities are computerized,
these activities require reengineering. You
are part of the project team hired by Seymour
Davis, the company’s president, to renovate
its wholesale division. Your project team was
hired to renovate the billing, order taking,
and inventory control systems.
From requirements determination, you discovered the following. An Evergreen Nurseries customer places a call to the nursery.
A sales representative takes the order, verifies the customer’s credit standing, determines whether the items are in stock, notifies
the customer of the product’s status, informs
the customer if any special discounts are in
effect, and communicates the total payment
due. Once an order is entered into the system, the customer’s account is updated, product inventory is adjusted, and ordered items are pulled from stock. Ordered items are then
packed and shipped to the customer. Once
each month, a billing statement is generated
and sent to the customer. The customer has
thirty days to remit payment in full; otherwise, a 15 percent penalty is applied to the
customer’s account.
a. Construct a context data-flow diagram,
illustrating Evergreen Nurseries’s wholesale system.
b. Construct a level-0 diagram for Evergreen
Nurseries’s wholesale system.
c. Using the level-0 diagram that you constructed in part b, select one of the level-0
processes and prepare a level-1 diagram.
d. Exchange your diagrams with those of another class member. Ask your classmate
to review your diagrams for completeness and consistency. What errors did he
or she find? Correct these errors

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Fundamentals of Managing data
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