Databases

Terrier Television wants to create a database of its TV series recordings. Each Series consists of 13 episodes. Actors may appear in more than one series. Terrier TV wants the database to be searchable be series, episode and actor.

1. Why would a relational database be the most appropriate solution for this?
2. List the tables and attributes for when the database is implemented in Access and identify the primary key and the foreign key for each table.

An employee of a firm has a job where the employee can easily adjust the number of hours they work for the employer per year. The employee is currently payed $40 per hour and will work 2000 hours in 2017. The employer had a good year in 2017 and is considering two changes in the employee’s compensation for 2018.

a) Suppose the employer decides to raise the employees wage to $45 per hour. Explain why it is unclear whether the wage change will cause the employee to choose more or less work in 2018. (Note: The ability of the firm to change wages means this firm is not in a competitive labor market, but this has no impact on the worker’s decision) (1 point)

b) The other alternative the firm is considering is paying the employee a $10,000 bonus, but not changing the wage. Explain how this will change your answer to (a) about how much the employee works in 2018. Explain how it is possible both options cost the employer the same amount of money (1 point)

1. An employee of a firm has a job where the employee can easily adjust the number of hours they work for the employer per year. The employee is currently payed $40 per hour and will work 2000 hours in 2017. The employer had a good year in 2017 and is considering two changes in the employee’s compensation for 2018.

a) Suppose the employer decides to raise the employees wage to $45 per hour. Explain why it is unclear whether the wage change will cause the employee to choose more or less work in 2018. (Note: The ability of the firm to change wages means this firm is not in a competitive labor market, but this has no impact on the worker’s decision) (1 point)

b) The other alternative the firm is considering is paying the employee a $10,000 bonus, but not changing the wage. Explain how this will change your answer to (a) about how much the employee works in 2018. Explain how it is possible both options cost the employer the same amount of money(1 point)

A new market opportunity has opened, and you expect that you will be able to double your sales in 2019. Assume that COGS, operating expenses, current assets and current liabilities maintain the same PERCENTAGE OF SALES as in 2018. Assume no new fixed assets, nothing from 2018 was fully depreciated, and you will have the same dividend policy in 2019 as you did in 2018.

Use the financial statements below to determine if additional funds will be needed, and if so, how much.

a- No Additional Funds Needed

b- $3,333

c- $65,000

d- $8,000

Acme Company Balance Sheet As of January 5, 2018 (amounts in thousands) Cash 14,700 Accounts Payable 2,400 Accounts Receivable 4,800 Debt 3,700 Inventory 3,800 Other Liabilities 5,000 Property Plant & Equipment 15,800 Total Liabilities 11,100 Other Assets 900 Paid-In Capital 6,000 Retained Earnings 22,900 Total Equity 28,900 Total Assets 40,000 Total Liabilities & Equity 40,000 Update the balance sheet above to reflect the transactions below, which occur on January 6, 2018 1. Receive payment of $12,000 owed by a customer 2. Buy $15,000 worth of manufacturing supplies on credit 3. Purchase equipment for $44,000 in cash 4. Issue $80,000 in stock 5. Pay $4,000 owed to a supplier 6. Borrow $58,000 from a bank 7. Buy $15,000 worth of manufacturing supplies on credit What is the final amount in Accounts Payable? Please specify your answer in the same units as the balance sheet.

Water is added to 4.267 grams of UF₆. The only products are 3.730 grams of a solid containing only uranium, oxygen, and fluorine and 0.970 grams of a gas. The percent composition of the gas is 95.0% fluorine and 5.0% hydrogen.

a)     From this data, determine the empirical formula of the gas

b)     What percent of the fluorine of the original compound is in the solid

c)     What is the empirical formula of the solid product

d)     Write a balanced equation for the reaction between UF₆ and H₂O. Assume that the empirical formulas of the products are the true formulas

In a certain county, the sizes of family farms approximately follow mound-shaped (normal) distribution with a mean of 472 acres and a standard deviation of 27 acres.

(a) According to the empirical rule, approximately __% of family farms have a size between 418 and 526 acres.

(b) According to the empirical rule, approximately __% of family farms have a size between 391 and 553 acres.

(c) According to the empirical rule, approximately __% of family farms have a size between 445 and 499 acres.

At December 31, 2017, Grand Company reported the following as plant assets.

Land                                                                                                                                                      4,000,000

Building                                                                                                28,500,000

Less: Accumulated depreciation – buildings                          12,100,000                          16,400,000

Equipment                                                                                          48,000,000

Less: Accumulated depreciation – equipment                     5,000,000                           43,000,000

                Total plant assets                                                                                                             63,400,000

During 2018, the following selected cash transactions occurred.

April 1   Purchased land for $2,130,000

May 1    Sold equipment that cost $75,000 when purchased on January 1, 2014. The equipment was sold                 for $450,000.

June 1   Sold land purchased on June 1, 2008 for $1,500,000. The land cost $400,000.

July 1     Purchased equipment for $2,500,000.

Dec. 31 Retired equipment that cost $500,000 when purchased on December 31, 2008. The company received no proceeds related to salvage.

Instructions:

Journalize the above transactions. The company uses straight-line depreciation for buildings and equipment. The buildings are estimated to have a 50-year life and no salvage value. The equipment is estimated to have a 10-year life and no salvage value. Update depreciation on assets disposed of at the time of sale or retirement.

Record adjusting entries for depreciation for 2018.

Prepare the plant assets section of Grand’s balance sheet at December 31, 2018.

On December 31, 2017, Swifty Inc. has a machine with a book value of $1,109,200. The original cost and related accumulated depreciation at this date are as follows. Machine $1,534,000 Less: Accumulated depreciation 424,800 Book value $1,109,200 Depreciation is computed at $70,800 per year on a straight-line basis. Presented below is a set of independent situations. For each independent situation, indicate the journal entry to be made to record the transaction. Make sure that depreciation entries are made to update the book value of the machine prior to its disposal. A fire completely destroys the machine on August 31, 2018. An insurance settlement of $507,400 was received for this casualty. Assume the settlement was received immediately. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit August 31, 2018 (To record current depreciation.) August 31, 2018 (To record loss of the machine.) SHOW LIST OF ACCOUNTS On April 1, 2018, Swifty sold the machine for $1,227,200 to Dwight Yoakam Company. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit April 1, 2018 (To record current depreciation.) April 1, 2018 (To record sale of the machine.) SHOW LIST OF ACCOUNTS On July 31, 2018, the company donated this machine to the Mountain King City Council. The fair value of the machine at the time of the donation was estimated to be $1,298,000. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit July 31, 2018 (To record current depreciation.) July 31, 2018 (To record donation of the machine.)