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
Question
Chapter 6, Problem 15RQ
Summary Introduction
To explain: The three ways to use SQL to change data in a database.
Introduction:
Relational database:
It is a collection of multiple data sets constituted by rows, columns, and tables. It aids in developing a well-established relationship between different database tables. Information is shared between these tables for efficient use.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Could you explain what are the Biblical principles researchers that can follow to mitigate researcher bias?
How to use of Biblical ethics to synthesize the literature to avoid misrepresentation of the literature?
How researchers can demonstrate Biblical ethics when collecting and analyzing data?
The manager of company A is thinking about adding an air conditioner to the
office. The AC will cost $1630 to buy and install. The manager plans to use
the AC for 5 years and each year's depreciation rate is 18% of the purchase
price. The manager expects to sell the AC in 5 years for $880.The tax rate is
15% and the company's WACC is 15%. If the manager considers this
purchase of AC as an investment, what is the NPV (keep two decimal places
and assume that the AC will not affect the operations of the company)?
Problem 5-5 Calculating IRR
A firm has a project with the following cash flows:
Year
Cash Flow
0
-$27,700
1
23
11,700
14,700
10,700
The appropriate discount rate is 18 percent. What is the IRR for this project? (Do not
round intermediate calculations and enter your answer as a percent rounded to 2
decimal places, e.g., 32.16.)
IRR
%
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
- Could you help to explain: How researchers can demonstrate Biblical ethics when conducting a literature review? How researchers can demonstrate Biblical ethics when communicating with a research team or university committee? How researchers can demonstrate Biblical ethics when recruiting participants. Provide Biblical and/or scholarly support for all assertions?arrow_forwardCould you please help explain what is the Biblical ethics in research? How do they establish a firm ethical foundation based on Biblical principles? What should they do to reduce the researcher bias as well as misrepresenting the literature and study findings? How Christians would like to ensure of being obedient to God in the research and study conduct?arrow_forwardI need answer typing clear urjent no chatgpt used pls i will give 5 Upvotes.arrow_forward
- < When you purchased your car, you took out a 5-year annual-payment loan with an interest rate of 5% per year. The annual payment on the car is $5,200. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for 1 year (so there are 4 years left on the loan)? b. You have owned the car for 4 years (so there is 1 year left on the loan)? a. You have owned the car for 1 year (so there are 4 years left on the loan)? The payoff if there are 4 years left on the loan is $ (Round to the nearest cent.) b. You have owned the car for 4 years (so there is 1 year left on the loan)? The payoff if there is 1 year left on the loan is $ (Round to the nearest cent.)arrow_forwardVictoria Exports (Canada). A Canadian exporter, Victoria Exports, will be receiving six payments of €13,800, ranging from now to 12 months in the future. Since the company keeps cash balances in both Canadian dollars and U.S. dollars, it can choose which currency to exchange the euros for at the end of the various periods. Which currency appears to offer the better rates in the forward market? (Click on the icon to import the table into a spreadsheet.) Period Days Forward spot 1 month C$/euro 1.3347 1.3370 US$/euro 1.3219 1.3224 m 2 months 3 months 1.3392 30 60 1.3229 90 1.3235 180 1.3438 12 months 360 1.3464 1.3239 1.3269 6 months 1.3416 Calculate the forward premium, the Canadian dollar proceeds, and the difference from the spot rate proceeds in the C$/Euro forward market below: (Round the forward premium to three decimal places and the Canadian dollar amounts to the nearest cent.) Days Forward Premium C$ Proceeds of Difference Period Forward C$/euro on the C$/euro €13,800 Over Spot…arrow_forwardidentify the primary sources of financing, both traditional and alternative, accessible to companies seeking sources of funding. To do so, you should: Collect and curate data and documentary resources from various sources (magazine articles, newspapers, online content, working papers from various institutions, activity reports, performance reports, legal regulations, speeches, appearances, press conferences, etc.). Analyze the documentary content you have previously curated and collected. During your analysis, consider the context, location, timing, and target audience of the texts. Reference Article: One Park Financial. (2022). Best alternative business loans and financing for entrepreneurs. https://www.oneparkfinancial.com/blog/alternative-business-funding Questions: Identify and summarize the traditional financial avenues available to businesses. What are the most innovative financing options they could find? Open-ended question: if you were in the opposite position, as an…arrow_forward
- XYZ stock price and dividend history are as follows: Beginning-of- $ 130 Dividend Paid at Year Year Price Year-End 2021 $ 2 2022 2023 153 2 2024 128 133 2 2 An investor buys five shares of XYZ at the beginning of 2021, buys another two shares at the beginning of 2022, sells one share at the beginning of 2023, and sells all six remaining shares at the beginning of 2024. Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Arithmetic time-weighted average returns Geometric time-weighted average returns % % b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2021, to January 1, 2024. Note: Negative amounts should be indicated by a minus sign. Date 01/01/2021 01/01/2022 Cash Flow 01/01/2023 01/01/2024 b-2. What is the dollar-weighted rate of return? (Hint. If your calculator cannot calculate…arrow_forwardConsider the following two banks: Bank 1 has assets composed solely of a 10-year, 11.50 percent coupon, $1.5 million loan with a 11.50 percent yield to maturity. It is financed with a 10-year, 10 percent coupon, $1.5 million CD with a 10 percent yield to maturity. Bank 2 has assets composed solely of a 7-year, 11.50 percent, zero-coupon bond with a current value of $1,108,283.85 and a maturity value of $2,374,515.87. It is financed with a 10-year, 5.75 percent coupon, $1,500,000 face value CD with a yield to maturity of 10 percent. All securities except the zero-coupon bond pay interest annually. a. If interest rates rise by 1 percent (100 basis points), what is the difference in the value of the assets and liabilities of each bank? Note: Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter the answers in dollars, not millions of dollars. Round your answers to 2 decimal places. (e.g., 32.16) Before Interest Asset Value After Interest…arrow_forwardTIME TO REACH A FINANCIAL GOAL You have $42,180.53 in a brokerage account, and you plan to deposit an additional $5,000 at the end of every future year until your account totals $250,000. You expect to earn 12% annually on the account. How many years will it take to reach your goal? Round UP to the nearest year. (Example 5.01 years = 6 years) Your answer should include numerical value only.arrow_forward
- You plan to retire in 30 years. • In 50 years, you want to give your daughter a $500,000 gift. • You will receive an inheritance of $200,000 in 25 years. • You think you will want $50,000 per year when you retire for 30 years (the first withdrawal will come one year after retirement). • You will begin saving an amount to meet your retirement goals one year from today. Required: • If you think you can make 9% on your investments, how much will you need to save each year for the next 30 years to meet your retirement goals?arrow_forwardAn initial $3300 investment was worth $3820 after two years and six months. What quarterly compounded nominal rate of return did the investment earn? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Nominal rate of return % compounded quarterly.arrow_forwardSuppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 9 percent, and that the maximum allowable payback and discounted payback statistics for the project are 2.0 and 3.0 years, respectively.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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