1:20HillLTE
s3.us-east-1.amazonaws.com
Project Stage 2
The second stage of the project requires students to perform
the three steps to convert REA diagram to tables in the
event-oriented modeling (See the slides to Chapter 9).
1. Examine the attached solution for Kim Flowers Stage
1.
2. Convert your EER diagram into tables. Make sure that
you follow the procedure described in class and the
slides to Chapter 9
3. The submission must be typed in Win Word. You will
turn in the project via your Morgan email account,
using subject the convention specified in our syllabus.
Kim’s Flowers Revenue Cycle Assignment solution
Kim Burke is the owner and operator of a small flower
shop, Kim’s Flowers. She has decided to develop a database
system to track her sales, inventory, accounts receivable
and cash receipts. This system is used for large orders that
are arranged in advance. 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 system as follows:
Whenever a customer (A)comes in to place an order (E),
sales clerk (A) enters a Sales Order directly into the
computer system. The sales order lists all of the floral
inventory items (R) the customer wishes to purchase. The
clerk then the sales order and gives a copy to the
customer. If this is an
new customer, before entering the
sales document, the clerk must enter the customer’s basic
information such as
as name, address, etc. Additionally, credit
for new customers must be approved by Kim.
prints
When Kim (A )completes delivery (E) of the sales order,
an accounts receivable clerk (A) records the delivery on a
special screen. When delivery entry is completed, Kim
prints the invoices and sends them to customers. When
customers send in their payments, a sales clerk records the
cash receipts (E )on a special input screen. Kim takes the
all of the cash (R) receipts for a day and prepares a single
deposit slip form and makes the deposit (E). Kim later
enters the deposit information from the paper form into the
computer.
6:23
LTE
s3.us-east-1.amazonaws.com
Kim’s Flowers Revenue Cycle Recording DFD
Floral Inventory
Sales Clerk
Sale Info
Sales Clerk
Customer
Record
Sales Order
items
crequested
Customer
AR Clerk
delivery info
Sales Orders
Record
Delivery
Customer
Kim
Delivery
Floral Inventory
Sales Clerk
Shipping
Clerks
Case Recd
Customer
Record Cash acct
Receipt
Into
kim
Am.Date
of deposit
Record
Deposit
Sales Clerks
Cash Receipts
Cash
Desposits
kom
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
