What are the differences between espoused (publicly declared) values and values in use (the unwritten rules that actors follow)?

How does being family-owned (as compared to being publicly owned) affect a firm’s strategic management?

Create the Database:

The data is the same as was described in the ER Design Project assignment. In that assignment you were asked to map the ER diagram to relations in the database. Here is a formal description of the relations that you will use in this assignment:

streamTV Database Relations

shows(showID, title, premiere_year, network, creator, category)

episode(showID, episodeID, airdate, title)

• showID is a foreign key to shows

actor(actID, fname, lname)

main_cast(showID, actorID, role)

• showID is a foreign key to shows

• actID is a foreign key to actor

recurring_cast(showID, episodeID, actorID, role)

• showID is a foreign key to shows episodeID is a foreign key to episode

• actID is a foreign key to actor

customer(custID, fname, lname, email, creditcard,membersince,renewaldate, password, username)

cust_queue(custID, showID, datequeued)

• custID is a foreign key to customer

• showID is a foreign key to shows

watched(custID, showID, episodeID, datewatched)

• custID is a foreign key to customer
• showID is a foreign key to shows
• (showID, episodeID) is a foreign key to episode
• (custID, showID) is a foreign key to cust_queue

Primary keys are in bold.

Question:

SQL Queries:

The management at streamTV needs to retrieve certain information about their the data in the database. Specify the SQL queries for the questions listed here:

1. Find the titles and premiere years of all shows that were created after 2005.

2. Find the number of episodes watched by each customer, sorted by customer last name.

3. Find the names and roles of all actors in the main cast of Friday Night Lights.

4. Find all actors who are in the main cast of at least one show and in the recurring cast of at least one show. Display the actor's first name, last name, the title of the show in which the actor is in the main cast, the title of the show in which the actors is in the recurring cast, and the role the actor plays in each show.

5. How many shows have episodes with the word "good" in the title.

6. List the show title, episode number, date and episode title for all of the shows with the word "good" in the title. Sort the list by airdate.

7. Which episodes that have been watched originally aired in 2005. Display the show title, the episode title and the original air date.

8. Display the names of all actors who have had recurring roles in shows on NBC. Include the name of the actor, the title of the show and the role.

9. A customer wants to add to her queue every show that Amy Poehler has appeared in. List all of these shows by title.

10. For each customer (display first and last name), display which show and episode was the first one watched by that customer. Sort the result by the customer's last name.

11. Find all shows that have more than 5 seasons. Display the title of the show, and the number of seasons. Sort the result by the number of seasons. Note that the first digit of each episode number represents the season number.

12. Find the titles of all shows that were not watched by any customers in August of 2013.

13. List the title of the show that has been watched the most by customers. Also display the number of times it has been watched.

14. For each show, list the number of customers who have that show in their queue. Display the show title and the number of customers. Sort by show title.

4. Suppose your company has opened a futures position in the Brazilian Real futures contract traded on the CME Group. One contract is worth 100,000 Brazilian Reais, and the price quote is given as # USD per 1 Brazilian Real. Suppose today’s futures price for the Brazilian Real futures contract that expires in October is ‘0.1883’. If the daily changes in the settlement prices over the next 5 days turn out to be 0.0015, 0.0010, -0.0005, 0.0020, and -0.0025 (quoted on same basis as the price--#US$ per 1 Brazilian Real), what would be the total marking-to-market change in the value of the contract over the 5 days? If your company was long Brazilian Real, would it have gained or lost from this marking-to-market change in value (assume 1 contract)?

A publically traded company more than doubled its EPS by changing depreciation methods. In justifying the change, management supported the change as follows: In comparison to direct competitors, the previous depreciation method was more conservative and thus had a negative impact on earnings.

Although difficult to prove, there is considerable evidence that accounting changes are made for reasons other than improved financial reporting. GAAP are flexible in the initial selection of accounting methods and in making subsequent changes. However, the accounting standards specifically require that only changes to preferable accounting methods be made.

Comment on the appropriateness of making accounting changes to fulfill financial reporting objectives, Consisder relevant ethical issues in your response. Who are the stakeholders? Does this violate GAAP? What is the ethical issue? What is an alternative course of action?

A publically traded company more than doubled its EPS by changing depreciation methods. In justifying the change, management supported the change as follows: In comparison to direct competitors, the previous depreciation method was more conservative and thus had a negative impact on earnings.

Although difficult to prove, there is considerable evidence that accounting changes are made for reasons other than improved financial reporting. GAAP are flexible in the initial selection of accounting methods and in making subsequent changes. However, the accounting standards specifically require that only changes to preferable accounting methods be made.

Does this violate GAAP? Is this ethical? What would be an alternative course of action?

1.When Coca-Cola traded their soft drink for wine in Slovenia, the company was engaged in:

A.Exchange control.

B.Countertrade.

C.Tariff trading.

D.Quota trade.

E.Global bargaining

2. In the global marketplace. Production invention

A. is the most inexpensive solution to production introduction

B. is the most localized solution to production introduction

C. is the most global solution to the production introduction

D. is the least commonly enjoyed option to production introduction

E. is the most commonly employed option to the production introduction

3.Psychographics is the segmentation method that delves into how consumers

A. adjust to demographic changes

B.allocate scarce incomes to a variety of goods and services

C.describe themselves

d.value their livelihoods.

E. all of these

4.the type of global entry expansions that has the greatest risk and yet generally the highest profit potential is

A. a joint venture with a foreign partner

B. a joint venture with a local partner

C. a direct exporting by the firm without an export agent

D.a sales and marketing office in the foreign market

E. franchising but no licensing

F. a direct investment in a Wholly -owend Foreign Enterprise.

5.The wheel of retailing means

A. a retail format or individual competitior should always be scanning the environment for a new,cheaper retailer looming on the horizen that may pre-empt its current success.

B.bricks and mortar stores are endangered with the advent of the online store

C. this is a life cycle to bricks-and-mortar retailer formats that is very predictable

D.that fashions recycle and prices assortment over several years may repeat

E.when a retailer first enters the market, prices will be very competitive, then they will decline just as any other product or service experiences as it moves through PLC.

Assume you are the CEO of a publically traded company. Your chief financial officer (CFO) informs you that your company will not be able to meet earnings per share targets for the current year. In that event your stock price will likely decline. The CFO proposes reducing the quarterly provision for uncollectible amounts (bad debt expense) to increase your EPS to the level analysts expect. This will result in an allowance that is less than it should be. The CFO explains that outsiders cannot easily detect a reduction in this allowance and that the allowance can be increased next year. The benefit is that your shareholders will not experience a decline in stock price.

1. Identify the parties likely to be affected by this proposed action.

2. How will reducing the provision for uncollectible accounts affect the income statement and the balance sheet?

3. How will reducing the provision for uncollectible accounts in the current period affect the income statement and the balance sheet in a future period?

4. What argument might the CFO use to convince the company's internal auditors that this action is justified?

5. How might an analyst detect this earnings management activity?

6. How might this action affect the moral compass of your company? What repercussions might this action have?

1.MACRS with Trade-In: In May 2011, your company traded in a computer and peripheral equipment, used in its business, that had a BV at that time of $25,000. A new, faster computer
system having a fair market value of $300,000 was acquired. Because the vendor accepted
the older computer as a trade-in, a deal was agreed to whereby your company

would pay $225,000 cash for the new computer system.

a. What is the property class life and recovery year for the computer system?
b. Using MACRS GDS rates, how much depreciation can be deducted each year based on this class life?