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
- In the New Company File Assistant, before pressing the Next button in the 'Create your company file' window, Isabella wants to confirm some of the company settings you selected when creating the company file in MYOB. Isabella asks you to select the correct options that appear throughout the New Company File Assistant that correspond to the company settings required for Hi-Fi Way in MYOB: 12 accounting periods and 'Other' as the industry classification of the business June as the conversion month and a financial year starting in January 12 accounting periods and 'Retail Business, Other' as the industry classification of the business January as the conversion month and a financial year ending in Julyarrow_forwardAnswer 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_forwardMatch 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_forward
- Create 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_forwardQuestion 1 For each of the following records, indicate the appropriate related file structure: master file, transaction file, reference file, or archive file customer ledgers sales orders vendor ledgers hours each employee has worked during the current pay period. Tax tables.arrow_forwardWrite a SQL query to calculate the total purchase amount of customer_id 3005arrow_forward
- Custom fields can be created ____________________.Select all that apply. Select one or more: A. on the Advanced tab of Account and Settings B. on the Expenses tab of Account and Settings C. on the Sales tab of Account and Settings D. on the Company tab of Account and Settingsarrow_forwardClient portals will allow a client to see basically all of the information regarding his/her account as of the day before. True Falsearrow_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
- 1. 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_forwardWeatarrow_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 Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher: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 Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Accounts Receivable and Accounts Payable; Author: The Finance Storyteller;https://www.youtube.com/watch?v=x_aUWbQa878;License: Standard Youtube License