Trying to discover a solution for sending data from the underwater facility to the surface so that it can be uploaded to the internet from a research facility on the edge of Mariana Trench, roughly 1 mile below the surface of the ocean. All data will be stored in Amazon cloud database for instant access by scientists from around the World. This needs to be uploaded to (AWS) amazon web services. WHAT CATEGORIES WILL I NEED TO CONSIDER for this to be possible. (Cause and Effects)

If you needed to identify inventory items whose stock was running low, what Access tool could quickly find this answer?

When you're creating relationships,, what Access option allows you to protect your database from inconsistent data?

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add, modify, or delete existing records?

A. Consider the following relations and relationship:

JobOpening (jobNo, positon, salary, requirement, contactPerson)

NewsPaper(newsPaperNo, name, street, city, zipCode, phoneNo)

       Posting(jobNo, newsPaperNo, date, cost)

1. List all the positions that are posted on January 01, 2016

2. List all the positions that have never been posted

3. List the names of all the newspapers where the positions “database administrator has been posted

Identify which cloud computing service model is appropriate to use in each of the following cases:

A company needs to build a web portal for clients all over the world to access web pages.

Google allows customers to do computing on their system. A customer does not need to have a powerful computer, just some means to access the Internet.

A small business does not want to purchase software, such as visio drawing tools and database.

The following relations are part of a school database:

STUDENT(STUD#, STUD_NAME, MAJOR, YEAR, GPA)

TEACHER(FACULTY#, DEPT, TEACHERNAME)

ENROLLMENT(STUD#, COURSE#, GRADE)

RESPONSIBILITY(FACULTY#, COURSE#)

Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions:

What are the names of teachers who are responsible for courses in which students whose name is 'JONES' are enrolled?

Use relational Algebra and relational calculus for this question.

RCK Ltd issues a prospectus inviting the public to subscribe for 90 million ordinary shares of $2.00 each. The terms of the issue are that $1.00 is to be paid on application and the remaining $1.00 within one month of allotment.

Applications are received for 108 million shares during July 2018. The directors allot 90 million shares on 15 August 2018. All applicants receive shares on a pro rata basis. The amounts payable on allotment are due by 20 September 2018. By 20 September 2018 the holders of 18 million shares have failed to pay the amounts due on allotment. The directors forfeit the shares on 30 September 2018.

The shares are resold on 15 October 2018 as fully paid. An amount of $2.00 per share is received. The balance of forfeited shares is refunded on 20 October 2018.

DB Pty Ltd carries on a business with an annual turnover of $11million per annum. Towards the end of the income year ended 30 June 2018, the company incurred the following outgoings, all of which exclude GST:

1. Prepaid insurance expenses of $12,000 on 1 May 2018 for the period 1 May 2018 to 30 April 2019.
2. Prepaid employee bonuses totalling $120,000 on 1 June 2018 representing bonuses that would otherwise have been due for payment on 1 July 2018.
3. Prepaid advertising of $900 on 1 June 2018 for an online advertising campaign that will run for the next 10 months.

Required

Advise DB Pty Ltd how much, if any, of each of the payments would be tax deductible in the year ended 30 June 2018.

Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was $36,500. Its estimated residual value was $11,500 at the end of an estimated 5-year life. The company expects to produce a total of 10,000 units. The company produced 1,350 units in 2018 and 1,800 units in 2019.


Required:

1. Calculate depreciation expense for 2018 and 2019 using the straight-line method.
2. Calculate the depreciation expense for 2018 and 2019 using the units-of-production method.
3. Calculate depreciation expense for 2018 through 2022 using the double-declining balance method.

Complete this question by entering your answers in the tabs below.

• Required A
• Required B
• Required C

Calculate depreciation expense for 2018 and 2019 using the straight-line method.

Champ Corporation has taxable income for 2018 of $20,000. For 2018, Champ had tax exempt interest of $6,000 and received $25,000 of proceeds from a term life insurance policy, paid to the corporation as a beneficiary by reason of the death of a corporate officer. The premium on the policy was $1000 for 2018. The corporation paid charitable contirbutions in 2018 of $7000 in excess of the amount allowed as an income tax deduction. Ignoring federal income taxes, what are Champ Corporations earnings and profits for 2018?

Question #20

The following information pertains to Hopson Co.'s pension plan:

• Actuarial estimate of projected benefit obligation at 1/1/18       $82,000
• Assumed discount rate (Interest rate)    10%
• Service costs for 2018   $23,000
• Pension benefits paid during 2018         $15,000

If no change in actuarial estimates occurred during 2018, Hopson's projected benefit obligation at December 31, 2018 was

Hopson's projected benefit obligation at December 31, 2018 was $