New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
accounting information systems
Accounting Information Systems 2nd Edition Vernon Richardson, Chengyee Chang, Rod Smith - Solutions
Draw UML class diagrams for fast-food and traditional restaurants. Discuss similarities and differences. How would you add taking reservations to the second model?
Using Amazon.com as an example, prepare a collaboration sales activity model. What is the difference between an online process and a traditional brick-and-mortar store process?
Move to a new worksheet. Be sure that you have activated the Power Pivot add-in. Select POWER PIVOT > Manage to open the Power Pivot screen. Move to the Power Pivot for Excel screen. Select HOME > Get External Data > From Database and then select the option to connect to an Access
From your experience, think about the sales process for an online or brick-and-mortar store. Describe some business rules that help provide internal controls over that process?
What classes and associations would be included in a model that describes the information needed for a query that calculates the accounts receivable balance for each customer? Describe differences in the information for the open-invoice method, where customers pay according to specific invoices,
a. Draw a UML class diagram that describes the Beach Dude’s sales and collection process.b. Using Microsoft Access, implement a relational database from your UML class diagram. Identify at least three fields per table.c. Describe how you would create queries in the relational database to
a. Draw a BPMN activity diagram that describes the Bob White Karate Studio's sales and collection process.b. Prepare a UML class diagram with classes, associations, and multiplicities.c. Using the preceding information and the following attributes list, prepare a listing of the relational tables
a. Prepare a UML class diagram with classes, associations, and multiplicities.b. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support this sales and collection process. List the tables in the following order: resources,
1. Which of the following is not an activity in the purchases and payments process?a. Request pricesb. Receive itemsc. Pay for itemsd. Bill customerse. All of the above are activities in the purchases and payments process.2. Which activity results in an increase to accounts payable?a. Request
Business rules implement internal controls. Review Table 6.1 and describe which business rules implement segregation of duties. Classify each of those business rules as obligatory, prohibited, or allowed as described in Chapter 3.TABLE 6.1Using Business Rules to Implement Internal Controls Partner
Walmart uses a vendor-managed inventory system, where the inventory is owned and managed by the vendor until it is delivered from Walmart’s distribution center to the stores. What implications does this system have for Walmart’s purchases and payments process?
Draw an activity model using BPMN for the process that you followed when you purchased your textbooks for the current semester?
Refer to Figure 6.5. Describe the types of businesses that would employ a similar diagram for their purchases and payments processes. What other alternative approaches are there? Describe some businesses that would use these alternatives for the purchases and payments process structure.FIGURE 6.5
Recall that type images apply guidelines, constraints, and descriptive information, as well as categorizing the economic resources, events, and agents for a business process. Figure 6.6 shows two examples of type images for Sunset Graphics. Are there other possible type images that could be added
Some larger companies and government entities issue contracts for major purchases and then issue specific purchase orders to their contractors according to the terms of the contract.The contract can specify prices and payment terms as well as other administrative procedures. How would the use of
Sunset Graphics often buys inventory after receiving a sales order from the customer. Suppose you are asked to prepare one UML class diagram that combines both the sales and collection process and the purchases and payments process. What would be shared among those processes? What would be unique
Open a blank Excel workbook and bring in the FactSales data from the ContosoSales Access database as follows. Select DATA > Get External Data > From Access. Browse to the ContosoSales Access database. When the Select Table box appears, select the FactSales table and click OK. When the Import
What classes and associations would be included in a model that describes the information needed for a query that calculates the accounts payable balance for each supplier? Describe the logic of that query. (In other words, what steps would you follow to compute that balance?)
Explain the penalties accruing to companies that are not in compliance with the Data Accountability and Trust Act of 2009 (DATA), including (a) Failure to comply with security program requirements and (b) Failure to follow the breach notification rules. Assume a company had a data breach involving
a. Prepare an integrated UML class diagram with classes, associations, and multiplicities.b. Using the preceding information and the following attributes list, prepare a listing of the relational tables necessary to support BRMC's processes. List the tables in the following order: resources,
a. Draw a UML class diagram that describes the Tablet Store's purchases and payments process.b. Using Microsoft Access, implement a relational database from your UML class diagram.Identify at least three fields per table.c. Describe how you would use the relational database to determine the Tablet
1. Which of the following is an activity in the conversion process?a. Authorize productionb. Issue raw materialc. Perform workd. Transfer completed work to finished goodse. All of the above are activities in the conversion process.2. Which of the following activities results in work-in-process
Think about the roles of accountants presented in Table 2.1 from Chapter 2. Why should accountants be involved in developing and reviewing the bills of materials?TABLE 2.1: Roles of the Accounting/Finance Function in Business Stewardship and Reporting Business Management Support Accounting/Finance
Describe some businesses that use conversion processes. Do they all use the same sequence of activities? Do they all share the same information structure? Discuss some of the differences in those conversion processes.
Think about the UML class diagrams for the sales and collection process described in Chapter 5 and the purchases and payments process described in Chapter 6. If you were asked to prepare an integrated model that shows those two processes as well as the conversion process, where would the models
Match these terms with their respective definitions: audit data standards, Big Data, breach of security, DATA (2009), data analytics, ETL, and personally identifying information.a. A standard format for data files and fields typically needed to support an external audit.b. Datasets that are too
In Figure 7.6, the Labor Operations event tracks direct labor incurred in the conversion process. What event tracks indirect labor?FIGURE 7.6: Revised UML Class Diagram for Sunset€™s Conversion Process 0..* Material Materials 0.* 1.* Issue 1.1 0.* 1. 1.1 1.1 0. Bill of Material
Describe how you would change Figure 7.6 to implement an activity-based costing system with three different cost drivers.FIGURE 7.6: Revised UML Class Diagram for Sunset€™s Conversion Process 0..* Material Materials 0.* 1.* Issue 1.1 0.* 1. 1.1 1.1 0. Bill of Material Production
Match these definitions with either of the three V’s (volume, velocity, and variety) to describe Big Data.a. Unstructured and unprocessed data, such as comments in social media, e-mails, global positioning system measurements, etc.b. The massive amount of data involved.c. Data coming in at fast
Put Figure 7.6 in the context of the overall supply chain that starts with the purchases and payments process (Chapter 6) and ends with the sales and cash receipts process (Chapter 5). How would you expand Figure 7.6 to describe Sunset€™s entire supply chain?FIGURE 7.6: Revised UML
Business rules implement internal controls. Review Table 7.1 and classify each of those business rules listed as access controls as obligatory, prohibited, or allowed, as described in Chapter 2. Select two of those business rules and rephrase them, so an obligatory rule is now a prohibited rule, a
Compare the generic UML class diagram for the conversion process shown in Figure 7.5 with a generic sales and collection diagram, similar to Figure 5.9. Identify the similarities and differences and then explain why they exist?FIGURE 7.5: Generic UML Class Diagram for the Conversion
a. Prepare a UML class diagram that captures Rubber Duck's brewing process.b. Using the preceding information and the following attributes list, prepare a listing of the relational tables, indicating the primary key (PK) and foreign keys (FK) for each table.The Rubber Duck Brewing Company is a new
a. Draw a BPMN activity diagram that describes Penny's baking process.b. Prepare a UML class diagram with classes, associations, and multiplicities.c. Using the preceding case information and the following attributes list, prepare a listing of the relational tables necessary to support this
1. Big Data is often described by the three V’s, or:a. Volume, velocity, and variability.b. Volume, veracity, and variety.c. Volume, volatility, and variability.d. Volume, velocity, and variety.2. According to estimates considered in the chapter, up to what percentage of a data analyst’s time
How does data analytics relate to Big Data? Why should accountants incorporate data analytics into their work?
What is an example of the way data analytics might be used in an airline setting to maximize revenue of selling to business and casual travelers?
Why is it important to have software vendors (such as SAP, Oracle, etc.) use the audit data standards?
How could audit data standards make external auditors’ work more efficient?
In field 17 of Figure 9.1, ADS include a record of who approved the journal entry. Why do you think the external auditor might be interested in this field? Why do you think the auditor might also be interested in who modified a journal entry (field 19 of Figure 9.1) and on what date (field 20 of
Why should companies have strong policies in place to protect personally identifying information?
Identify which of the following, on their own, are personally identifying information (PII) and which are not personally identifying information (non-PII).a. Date of birthb. Place of birthc. Credit card numberd. Religione. Retina scansf. E-mail address (personal)g. Race
Identify which of the following, on their own, are personally identifying information (PII) and which are not personally identifying information (non-PII).a. Financial informationb. Address of employmentc. Personal telephone numberd. Fingerprintse. Social Security numberf. Geographic indicatorsg.
Data analytics can be disaggregated into two parts: ETL (extract, transform, and load) or analysis. Classify each of the following processes as either ETL or analysis.a. Removal of extraneous data and noise.b. Looking for trends in the data that might predict new sales opportunities.c. Finding the
Ellen asks you to give her a list of the books that each author wrote. Write a complete SQL statement to provide the information to Ellen, including author names, book titles, publishers, and the years of publication?Use the following information:Ellen Novotny started an online bookstore in 2017.
Match the value chain activity in the left column with the scenario in the right column:1. Service activities .................................. A. Surveys for prospective customers2. Inbound logistics ................................................................... B. Warranty work3. Marketing
1. Accounting information systems:a. Are always computerized.b. Report only financial information.c. Are an information system that records, processes, and reports on transactions to provide financial and non financial information for decision making and control.d. Require a CITP designation to
Match the value chain activity in the left column with the scenario in the right column.1. Customer call center ..................................................... A. Operations2. Supply schedules ................................................. B. Inbound logistics3. Order taking
Information systems have impact on financial results. Using Figure 1-8 as a guide, which system is most likely to impact the following line items on an income statement. The systems to consider are enterprise systems, supply chain systems, and customer relationship management systems.FIGURE 1.8:
Accountants have four potential roles in accounting information systems: user, manager, designer, and evaluator. Match the specific accounting role to the activity performed.1. Controller meeting with the systems analyst to ensure accounting information system is able to accurately capture
1. Given these predictions, which jobs are most likely to be replaced by computerization? Those that primarily have tasks that automate, informate, or transform?2. Noticing the high probability of predicted job loss in the accounting and auditing area, are those job losses expected to be due to
1. Which of the following is not a role of the accounting function in business?a. Financial closeb. Regulatory compliancec. Project managementd. Using IT to make finance and accounting processes more efficiente. All of the above are roles of the accounting function.2. Which of the following is not
Do you think that your accounting education has prepared you for all roles of an accountant in business (see Table 2.1)? Which roles do you feel best prepared for? Which roles do you feel least prepared for? Why?
Choose one of the Accounting/Finance Operations roles in Table 2.1. How could a BPMN activity model help an accountant better understand that role?TABLE 2.1 Roles of the Accounting/Finance Function in Business Business Management Support Stewardship and Reporting Accounting/Finance Operations
Compare BPMN activity diagrams with flowcharts and DFDs. What is different? What is the same? When would one notation be better or worse than another?
Consider the Stewardship and Reporting role of accountants shown in Table 2.1. What information would you need to collect and use to manage the regulatory compliance function?
Describe some situations that might lead you to conclude that a BPMN diagram is not complete?
Assume that your company has BPMN diagrams of all their main processes. How could they use this information?
Each activity/task can only be assigned to one pool or lane. Why is that an important rule?
Describe situations where you would use exclusive, inclusive, and parallel gateways?
Your process waits until you receive a response from your customer. What kind of flow object would you use to show this?
Give some examples of processes that would start with a timer event based on your experience?
Consider the following narrative describing the process of filling a customer’s order at a Starbucks branch:A Starbucks customer entered the drive-through lane and stopped to review the menu. He then ordered a Venti coffee of the day and a blueberry muffin from the barista. The barista recorded
Consider the following narrative describing the process of going to class:Larry awoke to his alarm clock buzz. He got up and dressed for the day. Then, he ate a hearty breakfast of oatmeal, toast, orange juice, and coffee. He grabbed his books and prepared to leave for school. Before he left home,
Consider the following narrative describing the process of planning a vacation:Yannis is planning a trip to Hawaii with a friend. They first decide when they want to go and how much they can afford to spend. Then, they make their flight and hotel reservations. They wait until the scheduled
Consider the following narrative describing the process of preparing an income tax return:Each year before April 15, you file your income taxes. You collect multiple W-2 and 1099 documents. You prepare your tax return and double-check it for accuracy. You file your forms.Use BPMN to model the
Consider the following narrative describing the process of registering a car with the DMV:Heide lives in California and it is time to renew her automobile registration. The California DMV sends her a renewal form and indicates that she needs a smog check for her automobile. She takes her car to the
1. Which of the following is not an objective of a structure model?a. Designate things of interest in the business domain.b. Describe characteristics of things of interest in the business domain.c. Support relational database design.d. Describe the sequence of activities.e. All of the above are
Consider the following one-to-one association between classes. You are mapping the diagram to a set of relational tables. Where would you post the foreign key? Why would you post it there?
Consider the sale and cash receipt classes shown in Discussion Question 1. What kind of business is this (in terms of its payment requirements from customers)? How would the multiplicities change if the business (e.g., a used car dealer) accepted multiple payments over time?
Consider the following model and corresponding relational tables. Describe the meaning of the diagram in words. Assume that Students are identified by Student ID Number and Courses are identified by Course Number. List the relational tables that would implement the diagram (you may make assumptions
How would the following model look if you used a composition relationship? Which is more descriptive? 1.1 1.* Chapters Book
Consider the diagram in Discussion Question 4. Identify some examples of classes that would be modeled with a compostion model. Identify some examples of classes that would be modeled with an aggregation relationship model?In Question 4, 1.1 1.* Chapters Book
Think about the last time that you purchased something over the Internet. What did the checkout page look like? What categories of operational decisions do you think were made by the website operator. What business rules applied?
Think about the process you went through to enroll in this class. What business rules do you think applied to the enrollment process? Are all of these rules written? Why or why not?
Compare the UML class diagram shown in Figure 3.3 with the entity-relationship diagram shown in Figure 3.A2. Describe the differences and the similarities. FIGURE 3.3 Multiplicities Each Person owns a minimum of 0 and a maximum of many Autos. Each Auto is owned by a minimum of 1 and a maximum of 1
In your college career, you may have attended several universities. Draw a simple UML class diagram or an entity-relationship diagram showing your relationship with those universities. Now add the multiplicities or cardinalities. Would the multiplicities/cardinalities be different if the diagram
Describe some real-world examples of(a) One-to-one relationships,(b) One-to-many relationships, and(c) Many-to-many relationships. Which do you think is most common? Which does a relational database handle most easily?
Identify the classes and associations in the following narrative, and draw a class diagram with multiplicities:Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their
Identify the classes and associations in the following narrative, and draw a class diagram with multiplicities:Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones
Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 1. Identify primary and foreign keys.In Problem 1,Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may
Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 2. Identify primary and foreign keys.In Problem 2,Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several
Develop a UML class diagram with classes, associations, and multiplicities based on the following narrative:The Multnomah County Library provides a variety of services to citizens of the county. First, the library offers a number of traditional books and movies that may be checked out by patrons.
This problem continues Problem 8. Use the Access_Practice.accdb database that you have been working on to complete the following tasks.a. Go to the Relationships screen and connect the five tables, enforcing referential integrity.b. Calculate the total sales for each customer. Include CustomerID
Use the Access_Practice.accdb database to complete the following tasks in Access.a. The database contains three tables containing information about this company’s sales process: Inventory, Sales, and SalesItems. Use the Relationships window to link the tables together.b. The SalesItems table
Cloud computing has plenty of appeal for many firms, especially those that have immense computing needs. Why do you think some might be reluctant to have their data and computing power originating from the cloud?
Consider the UML diagram used to model Steve’s Stylin’ Sunglasses’ (SSS) sales data. Draw a new UML diagram assuming that SSS sells mass-produced brand-name sunglasses instead of custom sunglasses?
Think about data collected and used by Netflix.a. Identify three tables that would contain customer or subscription data.b. For each table identified in a, list five attributes (you may include primary and foreign keys as well as non-key attributes).c. Describe each attribute using elements from a
Use the Cash table above to write a SQL query to show the total of all of the balances.Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft 950 BA-9 Checking Boston5
Use the Cash table above to write a SQL query to show a list of checking accounts?Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft 950 BA-9 Checking Boston5
Use the Cash table above to show the output for the following SQL query:SELECT Account#, BalanceFROM CashWHERE Bank = ‘Boston5’ORDER BY Amount DESC;Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft 950 BA-9 Checking Boston5
Use the Cash table above to show the output for the following SQL query:SELECT Account#, BalanceFROM CashWHERE Balance < 50000;Cash Account# Type Bank Balance Checking Boston5 BA-6 253 BA-7 Checking Shawmut 48,000 Shawmut 75,000 BA-8 Draft 950 BA-9 Checking Boston5
1. In the hierarchical data model, the mapping from parent to child is:a. 1:1 (one-to-one).b. 1:N (one-to-many).c. N:N (many-to-many).d. N:1 (many-to-one).2. Advantages of relational data models generally include:a. Reduced information redundancy.b. Low cost.c. Ease of implementation.d.
Use the UML class diagram you created for Problem 5 to create an Access database for the library. Make up at least three fields for each table, including one field that will be the primary key?
Showing 5200 - 5300
of 5294
First
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Step by Step Answers
Get 50% OFF
Claim Now
