Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sue's Flowers Expenditure Cycle (ERD Project to be completed and submitted by students) Now that you have helped Sue develop the ERD for the Revenue

Sue's Flowers Expenditure Cycle

(ERD Project to be completed and submitted by students)

Now that you have helped Sue develop the ERD for the Revenue Cycle, Sue has decided to

develop a database system to track her purchases, floral inventory, accounts payable and cash

payments. However, she does not have time to do the development herself. Therefore, she has

hired you to design and implement the system for her. She describes the requirements of her

expenditure system as follows:

Whenever flowers are needed, a purchasing agent enters a purchase order for the items directly

into the computer system. To accommodate all of her floral needs, the purchasing agent may

need to prepare several orders, as Sue orders flowers from many different vendors. Vendors are

selected based on information maintained about their delivery performance and prices for floral

items they are approved to sell. This information is maintained by a special purchasing clerk who

gets catalogs and other materials from vendors and enters the data into the system using a special

screen. The purchasing agent views this information using a special inquiry screen within the

computer system. The purchasing agent may order several types of flowers from a single

vendor on one order. Sue approves and prints these purchase orders and sends them to the

vendors.

A floral designer records the receipt of flowers from a vendor on a special screen in this

accounting system. At the end of each month, an accounts payable clerk creates checks to pay

for all amounts charged through the end of the month. Once the checks are created, Sue

authorizes the checks, prints them and mails them to vendors. Sue also uses special screens in

the computer system to perform maintenance for inventory items (add, modify and delete items

from the file), and to record disposal of old or damaged flowers.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: C. William Thomas, Wendy M. Tietz, Walter T. Harrison Jr.

12th edition

134725980, 9780134726656 , 978-0134725987

More Books

Students also viewed these Accounting questions

Question

2. To store it and

Answered: 1 week ago