Based on the three tables provided on the left, write a query that will return the result set shown in the 4th table, displaying the movie name, actor ID, and actor name.

Choose a company and design an IMC strategy for the company. Start by listing the goal the company should try to achieve. Next, choose three types of media they should use. Explain why you chose each one. Finally, if the company was running a paid advertisement, what type of appeal should they use? Why?

Explain what is meant by core and value-added and give an example of how this applies to either the purchase of a car or an service (like a hotel room).

A store has 75 SKUs of Lunchables in stock.  They are planning a promotion and expect to sell 35 per week for the next 4 weeks at which time they will be restocked.  What is their in-stock percentage?

In your own words, explain three points of negotiation for retailers and why they are important to product or store performance.  

In high-risk child welfare cases, children will remain in their own homes with their families, and the families may receive in-home services and supports.

What SQL query will return the results as shown in the image, combining the Person and Phone tables?

A buyer was reviewing sales of a supplier’s products at the end of the fiscal year.  The products had overall retail reductions of 12% and a markup of 23%.  What was the maintained markup?

Which of the following is not a concept of the simple markup formula?

The following measurements were made by a group of students using the same balance and a 26.00 gram weight. Trial Mass (g) 1 23.96 2 24.01 3 23.98 4 23.97 The data would be considered: I) accurate and precise II) accurate but not precise III) precise but not accurate IV) neither precise nor accurate V) evidence of a systematic error VI) evidence of large random errors