Select the records in the TaskMasterList table with a CategoryID field value of Database and then create
Question:
Select the records in the TaskMasterList table with a CategoryID field value of Database and then create an update query to update their Estimate field values by 10 percent. How many records are updated and what is the highest updated Estimate field value?
a. 5 and $1,100
b. 5 and $1,000
c. 40 and $1,100
d. 40 and $1,000
Transcribed Image Text:
TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on Rails CODE04 Code SQL CODE05 Code HTML CODE06 Code CSS CODE07 Code JavaScript CODE08 Perform analytics CODE09 Select technology stack CODE 10 Apply SEO CODE12 Create prototype CODE13 Code WordPress CODE14 Code Python CODE15 Create shopping cart CODE16 Code Other DB01 DB02 DB03 DB04 DB05 MEETOO Design relational database Convert data Install MySQL database Install SQL Server database Install Access Database Initial customer meeting CategoryID Per Coding Hour Coding Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Hour Project Hour Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Coding Database Database Database Project Database Project Database Project Meeting Project Estimate $150.00 $150.00 $150.00 $150.00 $100.00 $100.00 $125.00 $100.00 $200.00 $125.00 $150.00 $100.00 $150.00 $125.00 $150.00 $1,000.00 $125.00 $500.00 $500.00 $400.00 $0.00
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (1 review)
Answered By
Aun Ali
I am an Associate Member of Cost and Management Accountants of Pakistan with vast experience in the field of accounting and finance, including more than 17 years of teaching experience at university level. I have been teaching at both undergraduate and post graduate levels. My area of specialization is cost and management accounting but I have taught various subjects related to accounting and finance.
5.00+
13+ Reviews
32+ Question Solved
Related Book For
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Question Posted:
Students also viewed these Computer science questions
-
In the last chapter you modified some tables for the Snick's Board Shop. Now Caitlin would like you to help her create some queries to extract information from the database. Make the following...
-
The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...
-
In the last chapter you modified some tables for the Wine Depot. Now Barbara would like you to help her create some queries to extract some information from the database. Make the following changes...
-
Describe how price variances create incentives to build inventories.
-
Pendel Company produces a variety of garden tools. The production budget for rakes is shown for the following months: Units March ....50,000 April ......60,000 May ....30,000 June ....28,000 Each...
-
(Multiple Choice) 1. The most common way to overstate revenues is to: a. Record revenues prematurely. b. Abuse the cutoff line for recording revenues. c. Create fictitious revenues. d. None of the...
-
What would happen to the SML graph in Figure 8.8 if expected inflation increased or decreased? Figure 8.8 268 269 270 271 272 273 274 275 A Required Rate of Return TH-13.0% SML: r, RF+RPM * b D E F H...
-
PAR AND NO-PAR, COMMON AND PREFERRED STOCK Hernandez Company had the following stock transactions during the year: (a) Issued 25,000 shares of $1 par common stock for $25,000 cash. (b) Issued 20,000...
-
Calculate the total billing amount for Jonas and his associate for their ( 1 ) first client assessment session and ( 2 ) second client assessment session. State whether they are the same or different...
-
Make a table with the ClientName, ProjectID, ProjectStartDate, and TaskID fields for all projects with a TaskID field value of MEET00. Sort the records in ascending order by the ProjectStartDate...
-
Find the total, average, and count of the Salary field for all employees grouped by title. Sort the records in ascending order by title. What is the average of the salaries for the first title in the...
-
Synchronized clocks A and B are at rest in our frame of reference, a distance five light-minutes apart. Clock \(\mathrm{C}\) passes \(\mathrm{A}\) at speed (12/13) \(c\) bound for \(\mathrm{B}\),...
-
4) Given a condition variable x, Consider the following implementation of x.signal() using semaphores. Please explain whether this a Hoare monitor or Mesa monitor, and why? (5 points) + if ( count >...
-
As Assistant Grant Officer for The Ministry of Silly Walks, it is your job to make sure all required paperwork is in order for all grant recipients. The most important piece of paperwork is the...
-
Tamara and Tony Mapp, a married couple, report the following items for the year: Taxable income AMT adjustments Tax preferences Regular tax liability $136560 35160 38400 14794 What is their...
-
Who owns the company? revenue asset equity a. Assets c. Revenue e. Liabilities b. Equity d. Expense ________ Who owns the company? ________ What the company earns. ________ What cost the company...
-
A 52.0-g metal weight, heated to 86.00C, is placed into 159 g of water at 21.80C contained in a perfectly insulating thermos flask. After some time, the temperature inside the thermos flask...
-
Since opening day, the Arnold Palmer Hospital has experienced an explosive growth in demand for its services. One of only six hospitals in the U.S. to specialize in health care for women and...
-
Write each fraction as a percent. 7 50
-
IEEE 754-2008 contains a half precision that is only 16 bits wide. The left most bit is still the sign bit, the exponent is 5 bits wide and has a bias of 15, and the mantissa is 10 bits long. A...
-
The Hewlett-Packard 2114, 2115, and 2116 used a format with the left most 16 bits being the fraction stored in twos complement format, followed by another 16-bit fi eld which had the left most 8 bits...
-
Calculate the sum of 2.6125 10 1 and 4.150390625 10 -1 by hand, assuming A and B are stored in the 16-bit half precision described in Exercise 3.27. Assume 1 guard, 1 round bit, and 1 sticky bit,...
-
In "Taking Sides: Clashing Views in Science, Technology and Society," edited by Thomas A. Easton, these two articles (Population Articles #1 and #2, above) were paired around the question, "Do...
-
#8 I just purchased a 30 year, 6% mortgage on my new home for $250,000. It was nice to be able to put 20% down to avoid home mortgage insurance. I plan to increase my payment to $2,000 per month....
-
Critical analysis, discussion, and referencing are very important to the quality of the assignments. Organisation of the structure with coherence, content and clarity will be underlined. The marking...
Study smarter with the SolutionInn App