(From Accounting Information Systems, 10e, Gelinas, Dull and Wheeler) V. SP 41 S

Question

(From Accounting Information Systems, 10e, Gelinas, Dull and Wheeler)

V. SP 41 SP4- a a Prepare a table of entities and activities for the Cornick, Inc. pro- table of entities and activities for the Cornick, Inc. pro a. cess described below Cornick, Inc Cornick, Ine. sells office products to businesses in the eastern region of the United States. Each month, the IT division at Cornick prints monthly statements and sends them to the accounts receivable (AR) department, where a clerk e-mails them to the customers. Cornick's customers mail their payments back to Cornick, where a clerk in AlR batches the checks and sends them o the cashier. The AR clerk then uses the payment stub to enter the payments into the computer, where the AR master data are updated to record the payment. b. Using Microsoft Visio or other diagraming software, construct a context diagram based on the table you prepared in part (a). SP 4-2 SP 4-3 Prepare a physical DFD based on the output from Short Problem 4-1 Using Microsoft Visio or other diagraming software // a. Prepare an annotated table of entities and activities based on the output from Short Problems 4-1 and 4-2. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in prepar ing a level 0 logical DFD. b. Prepare a logical DFD (evel 0 only) based on the table you pre pared part a). Use Microsoft Visio or other diagraming software SP 44 V. Construct a systems flowchart based on the narrative and the output from Short Problems 4-1 through 4-3. Use Microsoft Visio or other diagram ing software

Explanation / Answer

4.1

Tables should be an element that makes up a database management system. A DBMS should be a set of integrated programs designed to simplify the tasks of creating, accessing and managing data.

A contextual diagram should be a top-level, or least detailed data flow diagram of an information system that shows the system and all of its activities as a single bubble and shows the data flow into and Out of the system and into and out of the external entities.

Creating a table of entities and activities requires some pre entry organization. To begin a table it is best to review ant narrative data line by line circling each activity performed. An activity is any activity performed by an internal or external entity. Activities generally include data and operations processes.

For each activity performed there list the entity that performed the entity.

Entities

Para

Activities

IT division

1

1.   Print statements.

1

2.   Send statements to accounts receivable department.

Accounts receivable

1

3.   Mail statements to customers.

Customers

1

4.   Mail payments to Webster.

Accounts receivable

1

5.   Batch checks.

1

6.   Send checks to cashier.

1

7.   Enter payments.

Cashier

1

Computer

(IT division)

1

8.   Update accounts receivable master data.

   b.

Prepare a context diagram on the table prepared for cornick, Inc.     

4.2

A physical data flow diagram is a graphical representation of a system showing the system’s internal and external entities and the flows of data into and out of these entities.     

4.3

a. An annotated table of entities and activities based on indicating groupings, bubble numbers, and bubble titles for use in a level 0 logical DFD based on the output should be prepared.

Create a table of entities and activities that require some pre-entry organization. To create a table it should be best to review and narrative data line by line circling each activity performed. An activity shall be an activity performed by an internal or external entity. Activities generally should include data and operations processes.

Entities

Activities

Process

IT Division (computer)

1

1. Print statements.

Bill customers.

Accounts receivable

1

5. Batch checks.

Record payments.

1

6. Enter payments.

IT Division (computer)

1

8. Update accounts receivable master data.

b. A logical DFD (level 0 only) based on the table which was prepared in part (a) should be prepared.

A logical data flow diagram should be a graphical representation of a system showing the system's processes (as bubbles), data stores, and the flows of data into and out of the processes and data stores.

Entities

Para

Activities

IT division

1

1.   Print statements.

1

2.   Send statements to accounts receivable department.

Accounts receivable

1

3.   Mail statements to customers.

Customers

1

4.   Mail payments to Webster.

Accounts receivable

1

5.   Batch checks.

1

6.   Send checks to cashier.

1

7.   Enter payments.

Cashier

1

Computer

(IT division)

1

8.   Update accounts receivable master data.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.