Accounting Information Systems
11th Edition
ISBN: 9780357156032
Author: Ulric J. Gelinas; Richard B. Dull; Patrick Wheeler
Publisher: Cengage Limited
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 2P
Summary Introduction
To determine: The appropriate SQL command to be used for extracting information like work time, vacation time and sick time.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Match the term to its definition by choosing the appropriate number in the answer field. You will not use all of the terms provided.
Question 8 options:
A partial set of all available data items in a database that are used by a specific application, query, or report.
Fields that link tables with other tables.
The ability of employees at higher levels of responsibility and authority to bypass internal controls.
A field which is unique to each record in a database table.
The total number of transactions in a batch, used as a control total.
Procedures that are put in place to remedy errors or irregularities after they have been discovered.
Controls designed to enhance the control environment and strengthen the effectiveness of application controls.
1.
Corrective controls
2.
Preventive controls
3.
General controls
4.
Application controls
5.
Record counts
6.…
FYI: THIS IS AN ACCOUNTING EXCEL PROBLEM - NOT A COMPUTER SCIENCE PROBLEM!
Please read the instructions carefully in the picture that I posted.
For this accounting practice problem, please create an excel worksheet based off of the information in the picture.
Thank you!!!
The BusyB Company wants to store data about its employee skills. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database: date hireddate of birthdate skill acquiredemployee nameemployee numberpay rateskill nameskill numbersupervisor123Required a. Design a set of relational tables to store these data. Name each table and field in accordance with good database design.b. Identify the primary key for each table, and identify any needed foreign keys.
Chapter 6 Solutions
Accounting Information Systems
Ch. 6 - What is business intelligence (BI)?Ch. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - What is a relationship?Ch. 6 - Prob. 6RQCh. 6 - Prob. 7RQCh. 6 - Prob. 8RQCh. 6 - How can an REA model help an organization improve...Ch. 6 - Prob. 10RQ
Ch. 6 - Prob. 11RQCh. 6 - Prob. 12RQCh. 6 - What is a foreign key? How are foreign keys...Ch. 6 - Prob. 14RQCh. 6 - Prob. 15RQCh. 6 - Prob. 1DQCh. 6 - What is a model? How is modeling a database or...Ch. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Although todays enterprise systems incorporate...Ch. 6 - Prob. 8DQCh. 6 - Prob. 1SPCh. 6 - Prob. 2SPCh. 6 - Examine Figure 6.18, which contains the REA model...Ch. 6 - Prob. 6SPCh. 6 - Prob. 7SPCh. 6 - What SQL command(s) would you use to add the date...Ch. 6 - Prob. 2P
Knowledge Booster
Similar questions
- One of the first steps in the creation of a relational database is toa. integrate accounting and nonfinancial data.b. plan for increased secondary storage capacity.c. order data-mining software that will facilitate data retrieval.d. create a data model of the key entities in the system.e. construct the physical user view using SQL.arrow_forwardIf you are an accounting analytics professional, what software would be considered specified and complex? a) Xero b) Fresh Books c) Intuit Quickbooks d) Oracle NetSuitearrow_forwardWhich one of the following is not correct in relation to database?Select one:a. Helps in creating a business power point presentationsb. A database is usually controlled by a database management system (DBMS)c. A structured set of data held in a computer, especially one that is accessible in various ways.d. Most databases use structured query language (SQL) for writing and querying data.arrow_forward
- Answer True or False to each of the following. 1. To add a customer you click on the Task menu. True/False 2. A list of all the accounts used by a company showing the assigned numbers to each account is called Chart of Accounts. True/False 3. Reports can only be generated for final accounts when using an accounting software package. True/False 4. Under the File Menu, more than one company can be viewed at a time. True/False 5. To add a vendor click on Maintain, add vendor. True/False Answer True or False to each of the following. 1. A quote can be converted to a sales invoice 2. Most companies use batch posting instead of real-time posting for transactions 3. The Peachtree system can use both the accrual basis and cash basis to record transactions of accounting 4. To set up a new company, you would select the maintain option on the menu bar 5. Accounts descriptions cannot be changed once they have been savedarrow_forwardAfter completing your first degree in accounting you have been employed by XYZ Company as an account officer. The Management of the company has tasked you to implement a computerized accounting system Explain the difference between a stand-alone package and an integrated package? Explain two advantaged and two disadvantages of an integrated package e) Before a new accounting package can be deployed, it needs to be configured. What does it mean to configure an accounting package? Explain the processes involved in the configuration of an accounting package.arrow_forwardA system contains many processes. Three common processes that are “grouped” together are transaction corrections, adjustments, and cancellations. These three elements work to properly serve customers. Imagine a system that allows you to register for a class online. The online system must give you a way to correct any errors you made, such as registering for the wrong class. This would be a transaction correction. The system should also allow you to make adjustments, such as adding or dropping classes. Finally, the system should allow you to make cancellations, such as cancelling the registration process entirely. Notice that all three of these processes, correction, adjustment, and cancellation, work together to provide you with one service, which is registering for classes. What type of requirements are transaction corrections, adjustments, and cancellations? Select one. Question 4 options: A Functional Requirements B Nonfunctional Requirementsarrow_forward
- Following are activities for a provider of online education. Classify each activity as unit level, batch level, service level, or facility level. Activity 1. Scheduling instructors 2. Controlling course data 3. Receiving supply shipments 4. Registering a student 5. Creating a new course 6. Maintaining course websites 7. Providing electricity 8. Delivering an online course Levelarrow_forwardCan you explain some impacts of implementing software-based AIS (Accounting Information System) on the different departments and processes in the picture below.arrow_forwardUnderstanding components of a computerized accounting information system Ned Timmons, engineer, is considering using a computerized accounting system for his professional engineering business. Ned has asked that you help him understand the components of a computerized accounting information system by answering the following questions: Requirements 1. What are the two basic components of a computerized accounting information system? 2. Provide examples of each component. 3. If Ned were interested in an entry-level software system, what software might you recommend?arrow_forward
- Draw Physical Data Flow Diagram (DFD) of AR System In a physical DFD, we focus on how the system operates in terms of the people and technology involved. This diagram reflects who or what is responsible for each action, such as clerks, machines, or software. Components AR Clerk: Receives payments, updates the system, and batches cheques. Cashier: Receives batches of cheques from AR. Mail System: Sends and receives physical documents like statements and cheques. Processes in Physical DFD - 1.0 AR Clerk prints and mails monthly statements. - 2.0 Customers mail payments to AR Clerk. - 3.0 AR Clerk batches cheques and sends to the Cashier. - 4.0 AR Clerk updates AR master data system. Data Stores Customer Records: A file or system holding customer information. AR Master Data: The electronic records updated with payments.arrow_forward( data backups) explain how can they implemented and how they make accountant job more efficient?arrow_forwardBelow are the benefits of computerised accounting syste,.Explain and give example on the below keypoints. • Instant Reporting • Reduction in Paper Work - Now most of the work is done via computerised system. Hence, their is less need of manual work. • Flexible Reporting • Accounting Queries • Online Facility - All the data can be make available online anywhere and anytime to any manager. • Security - All data is stored in computer with strong passwords and usernames.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning