Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/6512840044e45_1695712256338.jpg)
Transcribed Image Text:
Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to release a "golden oldies" collection of books published in the 1990s. The details of the old books are available in the "Obsolete_titles" table. The information required is a list of books that were released in the 1990s, the exact year they were released, and the age of each book. 2) Management wants to expand Fuller & Ackerman Publishing. They have decided that as part of their planning, they need to determine the amount invested in the titles published in the past and then estimate the investments they need to make for the growth of the company. They have decided to use the sales figures from the year 2013 for this analysis. In order to perform their analysis, management would like you to retrieve the following information: • The titles released in 2013. • A count of the titles released, the total development cost for all books, and the average development cost for a title. • A list of books for which the development cost is not defined. 3) Management has asked you to provide the following: After reviewing the performance of sales representatives, management decided to arrange a weekend trip to recognize their contribution. For booking tickets and fixing accommodations, management has asked you to provide a list of the names of representatives along with their representative IDs. • To show their appreciation for customers and to encourage them to purchase more titles, management decides to send a "thank you" note to the customers along with some gifts. You must prepare a list of customers' names and addresses. Fuller & Ackerman Publishing is celebrating its 25th year in the marketplace. Management has decided to release a "golden oldies" collection of books published in the 1990s. The details of the old books are available in the "Obsolete_titles" table. The information required is a list of books that were released in the 1990s, the exact year they were released, and the age of each book. 2) Management wants to expand Fuller & Ackerman Publishing. They have decided that as part of their planning, they need to determine the amount invested in the titles published in the past and then estimate the investments they need to make for the growth of the company. They have decided to use the sales figures from the year 2013 for this analysis. In order to perform their analysis, management would like you to retrieve the following information: • The titles released in 2013. • A count of the titles released, the total development cost for all books, and the average development cost for a title. • A list of books for which the development cost is not defined. 3) Management has asked you to provide the following: After reviewing the performance of sales representatives, management decided to arrange a weekend trip to recognize their contribution. For booking tickets and fixing accommodations, management has asked you to provide a list of the names of representatives along with their representative IDs. • To show their appreciation for customers and to encourage them to purchase more titles, management decides to send a "thank you" note to the customers along with some gifts. You must prepare a list of customers' names and addresses.
Expert Answer:
Answer rating: 100% (QA)
To retrieve the required information for each of the three tasks you mentioned youll need to use SQL ... View the full answer
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these databases questions
-
Let c, d E TR". Consider the LP. (P) max St. dx = 100 Describe the conditions on c under which (P) would have an optimal solution, and prove your claim-
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
You are the Certified Managerial Accountant (CMA) for Northwood Company. You have worked for the company for several years and your responsibilities include working with managers to analyze business...
-
You are the senior auditor in charge of the December 31, 2018, year-end audit for Cleo Patrick Cosmetics Inc. (CPCI). CPCI is a large, privately held Canadian company that was founded in 1999 by one...
-
Create a relational schema for the Branch view of Dream Home based on the conceptual data model produced in Exercise 15.13 and compare your schema with the relations listed in Figure 16.5. Justify...
-
A 0.5-lbm mass of air is compressed irreversibly from 15 psia and 40 F to 30 psia. During the process, 8.5 Btu of heat is removed from the air and 13 Btu of work is done on the air. Determine the...
-
A company producing product X yields two by-products Y and Z. The following particulars relate to a particular period of operation in which the joint cost amounted to Rs 1,40,000: Product Sales (Rs)...
-
Compute the price of a 3.8 percent coupon bond with 15 years left to maturity and a market interest rate of 6.8 percent. (Assume interest payments are semiannual.) Is this a discount or premium bond?
-
According to Modigliani and Miller, if a firm has a 4 0 % corporate income tax rate and if there are no bankruptcy costs, what percent of the firm's assets should be financed with debt?
-
Allen Blay owns 100% of the stock in AB Corporation, organized ten years ago in California. AB operates a foreign branch in Country A. In the current yea r, AB reports $500,000 of taxable income from...
-
2.5 points You need to determine the density of a ceramic statue. The weight of the statue is measured to be 28.4 N in air but when completely submerged in water its apparent weight is 17.0 N. What...
-
Shamika conducts a study comparing the performance of individuals on the first quiz in each of two classes taken in the first term of their freshman year. The scores, out of 100, are provided for...
-
Adult Sleep Times (hours) of sleep for randomly selected adult subjects included in the National Health and Nutrition Examination Study are listed below. Here are the statistics for this sample: n =...
-
Topic: I made a couple changes X Zag HCHW Ch 2 (31) (1).pdf X W2ag HW Ch 1 (20) - Physics 2ag X /Desktop%20user/Downloads/2ag%20HCHW%20Ch%202%20(31) %20(1).pdf f o search Hi 2/14 - I + 90% + 1.1 a....
-
Cashless Society. 40% of consumers believe that cash will be obsolete in the next 20 years (based on a survey by J.P. Morgan Chase). In each of Exercises 15-20, assume that 8 consumers are randomly...
-
Pacifico Company, a U . S . - based importer of beer and wine, purchased 1 , 3 0 0 cases of Oktoberfest - style beer from a German supplier for 3 1 2 , 0 0 0 euros. Relevant U . S . dollar exchange...
-
4. value: 15.00 points The following information is taken from the accounts of Latta Company. The entries in the T-accounts are summaries of the transactions that affected those accounts during the...
-
Test your confidence in the following Project Decisions: SI. # Question 01 02 03 04 05 06 07 08 09 10 How many years did it take to construct the largest Egyptian Pyramid- Pyramid of Cheops? When was...
-
In what way are an individuals pants with four pockets similar to a parent company with three subsidiaries? Explain, with reference to intercompany revenues and expenses.
-
Regina Communications Ltd. develops and manufactures equipment for technology and communications enterprises. Since its incorporation in Year 5, it has grown steadily through internal expansion. In...
-
You, a CA, have recently accepted a job at the accounting firm of Cat, Scan, & Partners, as a manager, and have been assigned the audit of Vision Clothing Inc. (VCI). The partner in charge had been...
-
What changes, if any, would you recommend, and why?
-
2. Identify one or more of Unilevers strengths, weaknesses, opportunities, and threats.
-
1. For Samsungs management, is adding a solar and wind power unit a strategic management issue? Explain.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App