Accounting Information Systems
11th Edition
ISBN: 9781337552127
Author: Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 6, Problem 1P
What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE table represented in Figure 6.13 (pg. 213)? Name this new attribute Employment_Date. Assume that the employees were hired on the following dates, using a year-month-day format as YYYYMMDD:
- Carl Elks 20000522
- Janet Robins 20010103
- Greg Kinman 19970825
- Christy Bazie 20040801
- Elaine Kopp 20060912
- John Mast 19950709
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
how can you enter data from client documents without printing the documents
which client had a job change in 2021
In a computer system, how are accounting records posted?a. master file is updated to a transaction fileb. master file is updated to an index filec. transaction file is updated to a master filed. master file is updated to a year-to-date filee. current balance file is updated to an index file
Which of the following is least likely to be an attribute of an employee table in a normalized database?a. employee nameb. employee addressc. employee numberd. employee supervisor’s namee. all of these would be attributes of the employee table in a normalized database.
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- A table of data for a library is shown in the table. Normalize these data into the third normal form, preparing it for use in a relational database environment. The library’s computer is programmed to compute the due date to be 14 days after the checkout date. Document the steps necessary to normalize the data similar to the procedures found in the chapter. Index any fields necessary and show how the databases are related.arrow_forwardMost computerized accounting systems use electronic forms to record transaction information, such as the invoice form illustrated at the top of Exhibit 7 in this chapter.a. Identify the key input fields (spaces) in an electronic invoice form.b. What accounts are posted from an electronic invoice form?c. Why aren’t special journal totals posted to control accounts at the end of the month in an electronic accounting system?arrow_forwardWhat types of user permissions can you set up when adding a new team member in QuickBooks Online Accountant? -Regular or custom user, Company administrator, Reports only, and Time Tracking only -Basic, Custom, and Full access -Regular or custom user, Company administrator, and Reports only -Regular or custom user and Company administratorarrow_forward
- Assume you are a senior accountant and have been assigned the responsibility for making the entries to close the books for the year. You have prepared the following four entries and presented them to your boss, the chief financial officer of the company, along with the company CEO, in the weekly staff meeting: As the CEO was reviewing your work, he asked the question, What do these entries mean? Can we learn anything about the company from reviewing them? Provide an explanation to give to the CEO about what the entries reveal about the companys operations this year.arrow_forwardAssume you are a newly-hired accountant for a local manufacturing firm. You have enjoyed working for the company and are looking forward to your first experience participating in the preparation of the companys financial statements for the year-ending December 31, the end of the companys fiscal year. As you are preparing your assigned journal entries, your supervisor approaches you and asks to speak with you. Your supervisor is concerned because, based on her preliminary estimates, the company will fall just shy of its financial targets for the year. If the estimates are true, this means that all 176 employees of the company will not receive year-end bonuses, which represent a significant portion of their pay. One of the entries that you will prepare involves the upcoming bond interest payment that will be paid on January 15 of the next year. Your supervisor has calculated that, if the journal entry is dated on January 1 of the following year rather than on December 31 of the current year, the company will likely meet its financial goals thereby allowing all employees to receive year-end bonuses. Your supervisor asks you if you will consider dating the journal entry on January 1 instead of December 31 of the current year. Assess the implications of the various stake holders and explain what your answer will be.arrow_forwardNext, open worksheet JOB2 again. Enter the data for Job 8962, save the results as JOB8962, and print the worksheet. Repeat these steps for Jobs 8963 and 8964.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_forwardSelect the letter of the item below that best matches the definitions that follow. a. Data Files CD ________ b. Lists ________ c. Forms ________ d. Registers ________ e. Reports and graphs ________ f. Restoring a backup ________ g. Icon bar ________ h. Home page ________ i. Backing up a file ________ 1. One click access to QuickBooks Accountant Centers and Home page. 2. The process of rebuilding a backup file to a full QuickBooks Accountant file ready for additional input. 3. Electronic representations of paper documents used to record business activities such as customer invoices, vendor bills, and checks. 4. A big-picture approach of how your essential business tasks fit together organized by logical groups such as customers, vendors, and employees. 5. Groups of names such as customers, vendors, employees, items, and accounts. 6. Contains backups of all the practice files needed for chapter work and completion of assignments. 7. The process of creating a copy of a…arrow_forwardKA. Using the public company, you chose for the Topic 4 assignment (The Home Depot, INC) determine the filing requirements and deadlines based on its fiscal year-end. Specifically, what type of filer is the company? What types of filings are required? What are the company's deadlines for filing its 10-K, 10-Q, and 8-K? Why does the company need to file based on these specifications?arrow_forward
- Of all the events that occur each day, how would you describe those that are recorded in a firms accounting records?arrow_forwardWrite a SQL query to calculate the total purchase amount of customer_id 3005arrow_forwardQuestion: Which one of the following devices is not used to record the hours worked by an employee? a) time sheet b) Automated device c) time book d) security camera required: please answer this question by choosing the right option.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
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License