Write a CREATE VIEW statement that defines a view named InvoiceBasic that returns three columns: VendorName, InvoiceNumber, and InvoiceTotal. Then, write a SELECT statement that returns all of the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.

2.Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName, LastInvoice (the most recent invoice date), and SumOfInvoices (the sum of the InvoiceTotal column). Return only the 10 vendors with the largest SumOfInvoices and include only paid invoices.

3.Create an updatable view named VendorAddress that returns the VendorID, both address columns, and the city, state, and zip code columns for each vendor. Then, write a SELECT query to examine the result set where VendorID=4. Next, write an UPDATE statement that changes the address so that the suite number (Ste 260) is stored in VendorAddress2 rather than in VendorAddress1.(Make sure to rerun your SELECT query in order to verify the change)

4.Create a view named AccountByVendor that returns the sum of InvoiceLineItemAmounts in the InvoiceLineItems table, grouped by VendorName and AccountDescription.

5.Modify the InvoiceBasic view created in exercise 1 to sort the result set by VendorName.

Match the various steps in the creative process undertaken by the ad agency for developing the campaign for wpu, to the steps in young's model of the creative process.creative process in developing wpu's campaignyoung's modelafter intensive analysis of the data and several rounds of brainstorming, the agency executives decided to take a break from this project (the wpu campaign), and instead work on a different client's project before tackling the wpu project again.using a combination of animatics and storyboards, the ad agency conducted research with a representative sample of sixty target consumers to pretest the campaign theme and the creative execution.during a brainstorming session in the creative department, a copywriter's suggestion for a slogan for wpu was recognized as an excellent central idea that could drive the campaign for wpu.the account planning, account management and creative departments at the ad agency had a series of meetings and brainstorming sessions to discuss the creative brief and the results of all the primary and secondary research done with the target consumers.the account planning and the account management groups at the ad agency conducted primary research with a representative sample of the target segment and also studied secondary research data to gain insights required for the campaign development process.

Dahlia enterprises needs someone to supply it with 127,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. it will cost you $940,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. you estimate that in five years, this equipment can be salvaged for $77,000. your fixed production costs will be $332,000 per year, and your variable production costs should be $11.00 per carton. you also need an initial investment in net working capital of $82,000. if your tax rate is 30 percent and your required return is 11 percent on your investment, what bid price should you submit? (do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))

The production manager of rordan corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st quarter 2nd quarter 3rd quarter 4th quarter units to be produced 10,800 8,500 7,100 11,200 each unit requires 0.25 direct labor-hours, and direct laborers are paid $20.00 per hour. required: 1. prepare the company’s direct labor budget for the upcoming fiscal year. assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2. prepare the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. instead, assume that the company’s direct labor workforce consists of permanent employees who are guaranteed to be paid for at least 2,500 hours of work each quarter. if the number of required direct labor-hours is less than this number, the workers are paid for 2,500 hours anyway. any hours worked in excess of 2,500 hours in a quarter are paid at the rate of 1.5 times the normal hourly rate for direct labor.