AFM241 Chapter Notes - Chapter 5: Data Integrity, Database, Data Redundancy

35 views4 pages

lemonbeetle804

23 Aug 2018

School

University of Waterloo

Department

Accounting & Financial Management

Course

AFM241

Professor

all

For unlimited access to Textbook Notes, a Class+ subscription is required.

Document Summary

Library: a collection and organization of sources of knowledge. Database: a collection and organization of sources of information. Data: facts about people, places, things, or events. Information: what you get when you process the data into something useful (summary tables, bar graphs, etc). The processed data are in fact the basis for idea formation. Production database: a production database is used mainly to track data about frequent and complex transactions. Transaction: involves one or multiple actions related to reading from or writing to a database. Decision support system database (dss): a dss database focuses on information requirement s instead of the transaction requirement characteristics of product databases. It offers extensive information generation and processing, as well as management capabilities. Datawarehouses: storage facilities dedicated to processing existing data taken from production databases into useful information. Metadata: data about the data stored in a database, stored i n a data dictionary.

Related Questions

Danielle Wongus processes hundreds of sales orders monthly forcontractor tools for Cambridge Wholesale Industries. The companysells the tools to retail stores in the Mountain stores. Some areshipped from inventory, but others are shipped directly to theretail stores form vendors. Direct shipment results in significantfreight savings. In most cases, Danielle receives the sales orderrequest from the salespeople, but in other cases the orders comedirectly to Danielle by phone from customers who want directshipments or who are used to buying directly from the company.Danielle processes the order through the Sales Orders task icon andsends the sales order to shipping, which results in the shipmentsbeing sent. When sales orders are initiated by the shippingdepartment after the goods are shipped, they are sent back toDanielle for billing. She processes them using the Sales Invoicestask icon and sends the sales invoice tot eh customers.

Several years ago, Danielleâs brother-in-law formed a smallbusiness, Idaho Valley Hardware that sells certain contractortools. Idaho Valley Hardware orders some of their tools fromCambridge Wholesale Industries. When the order comes in, Danielleprocesses the order like any other sales order to initiate theshipment. The shipping department ships the goods and initials thesales order, indicating shipment has occurred. If the amountshipped differs from the amount on the sales order, shippingchanges the shipping order. When the initialed sales order isreturned to Danielle, she sometimes destroys the sales order anddoes not prepare a sales invoice. Other times she records a lowerprice for the sales than the normal amount or bills for less goodsthan were shipped.

Later, Danielle does one of three things. In some cases sheprepares a credit memo for an allowance for defective merchandiseor a pricing error. Other times, she deletes the transactionentirely to eliminate the account receivable from the records.Another method that Danielle uses to conceal the fraud is to give alarger early payment discount than the normal 2% allowed by companypolicy when processing cash receipts.

Required:

Suggest improvements in the system including both Sage 50Accounting control and other system improvements to minimize thelikelihood of this fraud. Danielle must process sales invoices. Itis impractical, given the size of the business, to restrictDanielle to only one of the Sales Orders, Sales invoices, Creditsand Returns, and Receive Money task icons

indigolocust903

Multiple Choice:

21. All the following are true regarding Quotesexcept:

a. Quotes post entries to general ledger accounts

b. Quotes can be transferred to create an invoice

c. Quotes can be linked to customer jobs

d. Quotes can be linked to items

22. If a customer was overcharged for theservices, the customer's invoice can be reduced by posting a:

a. Sales invoice

b. Customer receipt

c. Debit memo

d. Credit memo

23. On the statement of cash flows, the cashflows from operating activities section would include:

a. Receipts from the issuance of capital stock

b. Receipts from the sale of investments

c. Payments for the acquisition of investments

d. Net income

24.The Income Statement will include thefollowing accounts:

a. Revenues less Expenses (ordered largest to smallest amount)with Other Expenses listed last
b. Revenues less Expenses (ordered smallest to largest amounts.With Miscellaneous Expenses listed last

c. Revenues less Expenses (ordered in alphabetical order) withOther Expenses listed last

d. Revenues less Expenses (order is not important)

25. The Statement of Cash Flows answers all ofthe following except:

a. Where the receipts come from

b. Where the cash payments were used for

c. What the overall change in cash was

d. If there will be enough cash to pay the currentliabilities

26. On the Navigation Bar, make the followingselections to enter a sales invoice:

a. Customers & Sales Navigation Center, click on theCustomers icon and select View and Edit Customers

b. Customers & Sales Navigation Center, click on the SalesInvoices icon and select Set up Invoice Defaults

c. Tasks; Purchases/Receive Inventory

d. Customers & Sales Navigation Center, click on the SalesInvoices icon and select New Sales Invoice

27. The following would be included in theheading of an income statement:

a. Title of the statement

b. Name of the business

c. Period of time covered by the statement

d. All of the above

. 28. A departmentalized accounting systemprovides information that can be used to:

a. Custom design departmental statements

b. Evaluate profitability and cost effectiveness

c. Evaluate current assets

d. Modify PCA's standard forms

29. In Peachtree, information about a sale isrecorded in the:

a. Purchase window

b. Inventory window

c. Purchases/Receive Inventory window

d. Sales/Invoicing window

30. The sample company, Bellwether GardenSupply, uses which method of posting?

a. Batch posting

b. Real-time posting

c. Cash basis posting

d. Accrual basis posting

jadekoala82

Question 1

Identify the item below that is not one of the four different types of data processing activities.

		deleting
		reading
		creating
		using

Question 2

All of the following are advantages of an ERP system except

		ERPs permit manufacturing plants to receive new orders in real time.
		in an ERP, data input is captured or keyed once.
		it takes considerable experience and training to use an ERP system effectively.
		ERPs permit management to gain greater visibility into every area of the enterprise.

Question 3

Sam Jones has been the controller of Downtown Tires for 25 years. Ownership of the firm recently changed hands and the new owners are conducting an audit of the financial records. The audit has been unable to reproduce financial reports that were prepared by Sam. While there is no evidence of wrongdoing, the auditors are concerned that the discrepancies might contribute to poor decisions. Which of the following characteristics of useful information is absent in the situation described above?

		relevant
		reliable
		complete
		timely
		understandable
		verifiable
		accessible

Question 4

An ERP system might facilitate the purchase of direct materials by all of the following except

		preparing a purchase order when inventory falls to reorder point.
		routing a purchase order to a purchasing agent for approval.
		communicating a purchase order to a supplier.
		selecting the best supplier by comparing bids.

Question 5

Antia Carmie is the largest collector and retailer of Japanese fans in the St. Louis area. Antia uses computer technology to provide superior customer service. The store's database system was designed to make detailed information about each Japanese fan easily accessible to her customers. Accordingly, the fan price and condition are provided for each fan, along with many pictures of each fan. In Antia's database, the price of the Japanese fans is a(n)

		entity.
		attribute.
		field.
		record.

Question 6

Which of the following is not considered a source document?

		A copy of the company's shipping document.
		A copy of the company's ledger.
		A copy of the company's sales journal.
		A copy of the company's financial statements.

Question 7

In an ERP system, the module used to record data about transactions in the disbursement cycle is called

		financial.
		order to cash.
		customer relationship management.
		purchase to pay.

Question 8

Baggins Incorporated identifies new product development and product improvement as the top corporate goals. An employee developed an innovation that will correct a shortcoming in one of the company's products. Although Baggins current Return on Investment (ROI) is 12%, the product innovation is expected to generate ROI of only 10%. As a result, awarding bonuses to employees based on ROI resulted in

		goal conflict.
		information overload.
		decreased value of information.
		goal congruence.

Question 9

________ are examples of activities that constitute inbound logistics.

		Activities that transform inputs into final products or services
		Activities that provide post-sale support to customers
		Activities that consist of receiving, storing, and distributing the materials used as inputs by the organization to create goods and/or services it sells
		Activities that help customers to buy the organization's products or services

Question 10

In which transaction cycle would information for inventory purchases be most likely to pass between internal and external accounting information systems?

		the revenue cycle
		the expenditure cycle
		the human resources / payroll cycle
		the financing cycle

Question 11

The collection of customer payment is part of which transaction cycle?

		the human resources cycle
		the production cycle
		the revenue cycle
		the expenditure cycle

Question 12

Which of the following is an example of source data automation?

		POS (point-of-sale) scanners in retail stores
		a bill of lading
		a subsidiary ledger
		a utility bill

Question 13

All of the following are guidelines for developing a good coding system except

		be as sophisticated as possible to promote usage.
		be consistent with its intended use.
		be flexible to allow for growth.
		be consistent with the company's organization structure.

Question 14

What is a key decision that needs to be made with regards to borrowing money from lenders?

		the location
		pro forma income statement
		how much capital to acquire
		job descriptions

Question 15

Identify the false statement below.

		A service company does not have an inventory system.
		Retail stores do not have a production cycle.
		Financial institutions have installment-loan cycles.
		Every organization should implement every transaction cycle module.

Question 16

The chart of accounts of a fast-food restaurant would probably include

		a list of customers.
		a list of financial statement accounts.
		a list of vendors.
		a list of employees.

Question 17

Which statement below regarding the AIS is false?

		Traditionally, most AIS have been designed so that both financial and operational data are stored in a manner that facilitates their integration in reports.
		The AIS must be able to provide managers with detailed and operational information about the organization's performance.
		Both traditional financial measures and operational data are required for proper and complete evaluation of performance.
		The AIS was often just one of the information systems used by an organization to collect and process financial and nonfinancial data.

Question 18

In Petaluma, California, electric power is provided to consumers by Pacific Power. Each month Pacific Power mails bills to 186,000 households and then processes payments as they are received. What is the best way for this business to ensure that payment data entry is efficient and accurate?

		well-designed paper forms
		turnaround documents
		source data automation
		sequentially numbered bills

Question 19

Data must be converted into information to be considered useful and meaningful for decision making. There are seven characteristics that make information both useful and meaningful. If the same information can be reproduced by two independent and knowledgeable people, it is representative of the characteristic of

		verifiability.
		truthful.
		relevance.
		reliability.

Question 20

		entity.
		attribute.
		field.
		record.

lilaccod491

AFM241 Chapter Notes - Chapter 5: Data Integrity, Database, Data Redundancy

Document Summary

Get access

Related Documents

AFM241 Chapter Notes - Chapter 5: Relational Database Management System, Database Theory, Unique Key

AFM241 Study Guide - Final Guide: Accounts Receivable, Profit Margin, Database

AFM241 Chapter Notes - Chapter 5: Database, Database Theory, Data Warehouse

Related Questions