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
Give answer within 45 min I will give you upvote...
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
- 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.…arrow_forwardThink 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? Provide a real world example of using the following databases in the workplace: Microsoft Access Structured Query Language (SQL)arrow_forwardCreate a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint namesarrow_forward
- What 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_forwardHow to create a new company in Microsoft office Accoutingarrow_forwardPlease see attached image for instructions. Thank you for your help!arrow_forward
- Next, 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_forward1. When should you select settings and customizations for your company file? A. At the time you create the company file B. As work related to the settings comes up C. Before the end of the business's first fiscal year D. In the second quarter 2. What is the Chart of Accounts? A. The list of accounts for each transaction in the accounting system or general ledger B. The menu of products and services that the company offers its customers C. The full list of account numbers associated with the company's customers and vendors D. The balance of each account as of the start date of the business 3. Which of these would be an appropriate start date for a business? A. December 31 of the current year B. The first day of a period, month, quarter, or year C. The day of your first expense D. The day of your first sale 4. What is an historical transaction? A. A transaction that occurred before the start date of the company B. A transaction that appears in the company file by default in QuickBooks…arrow_forwardWhich 2 statements about creating a client request in QuickBooks Online Accountant are true? A document request notification can be sent via email by selecting Notify client A document request can be sent to a non-QuickBooks Online client A document request appears in the client's QuickBooks Online company in the Accounting menu The status of a document request cannot be updatedarrow_forward
- This is for accounting information system class please help me figure how to do this step in excel.add the 2021 data to the Dashboard Open the file Support_EX19_EOM5-1_2021.xlsx. Copy the values in the range C6:C19. In cell C6 of the Dashboard worksheet in the original workbook, use the Paste Link command to create external references to the values in the Support_EX19_EOM5-1_2021.xlsx workbook. Delete the unnecessary values in cells C8, C12, and C16, and close the Support_EX19_EOM5-1_2021.xlsx workbookarrow_forwardOne day, the company chooses to buy their new accounting information system (AIS), and decide which activities in the systems development life cycle (SDLC) can be skipped? Justify your choice and explanation.arrow_forwardas an employee, how do i caculate my imcome system?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License