Give the tuple calculus expressions for each using the below schema: Make a database up if needed

SPERSON(EmpID, Name, Dept)

TRIP(TripID, EmpID, ToCity, StartDate, EndDate)

EXPENSE(ExpID, TripID, AccountID, Amount)

a) List the names and employee ID of a salesperson.

b) List employee ID and employee names that took a trip(s) to New York city.

c) List the names of all employees who have spent more than $700 on their trip.

d) List employees' names and their IDs that have never taken a trip.

e) List the names of all salespersons that have at least been on one trip.

Because the database server can cache and reuse ___________________ statements, they are more efficient than regular SQL statements.

When you work with a result set, the ____________ identifies the current position in the result set.

You use the __________________ class to work with data returned from a SQL query.

What does the invoices result set contain after the code that follows is executed?
String sql = "SELECT InvoiceDate, InvoiceTotal "
           + "FROM Invoices WHERE InvoiceTotal > ?";
PreparedStatement ps = connection.prepareStatement(sql);
ps.setDouble(1, 100);
ResultSet invoices = ps.executeQuery();

7. Using the provided schema of a Purchase Order Administration database, write the following queries in SQL. (In the schema, bold attributes are primary keys and italicized attributes are foreign keys.)

SUPPLIER (SUPNR, SUPNAME, SUPADDRESS, SUPCITY, SUPSTATUS)

SUPPLIES (SUPNR, PRODNR, PURCHASE_PRICE, DELIV_PERIOD)

PRODUCT (PRODNR, PRODNAME, PRODTYPE, AVAILABLE_QUANTITY)

PO_LINE (PONR, PRODNR, QUANTITY)

PURCHASE_ORDER (PONR, PODATE, SUPNR)

7d) Write a nested SQL query to retrieve the supplier number, supplier name, and supplier status of each supplier who has a higher supplier status than supplier number 21.

7e) Write a nested SQL query using the keyword IN to retrieve the supplier name of each supplier who supplies more than five products.

Using Inventory Analysis Tools
AutoZone and O'Reilly are two competitors in the retail automotive parts industry.

Use the information above to compute the companies' gross profit margin and days inventory outstanding for both years.
Round answers to one decimal place (ex: 0.2345 = 23.5%).

Round to answers to nearest whole number (day).

Prat Corp. started the 2018 accounting period with $29,000 of assets (all cash), $11,500 of liabilities, and $14,000 of common stock. During the year, the Retained Earnings account increased by $15,550. The bookkeeper reported that Prat paid cash expenses of $30,500 and paid a $2,900 cash dividend to the stockholders, but she could not find a record of the amount of cash that Prat received for performing services. Prat also paid $4,000 cash to reduce the liability owed to the bank, and the business acquired $6,300 of additional cash from the issue of common stock.

1. a-1. Prepare an income statement for the 2018 accounting period.
2. a-2. Prepare a statement of changes in stockholders’ equity for the 2018 accounting period.
3. a-3. Prepare a period-end balance sheet for the 2018 accounting period.
4. a-4. Prepare a statement of cash flows for the 2018 accounting period.

Section 179. (Obj. 2) Sand Corporation buys one asset in 2018---machinery costing $32,300,000. The machine was placed in service on June 2, 2018. Sand wants to elect the maximum Section 179 possible, even if some must be carried over to 2019. Sand's 2018 business income limitation (taxable income before Section 179 expense, but after all other expenses, including depreciation) is $167,000. A) Compute the maximum Section 179 Sand can elect to expense in 2018, the actual allowed 2018 expense deduction, and the Section 179 carryover to 2019. B) What is the regular depreciation deduction on the machine (7-year property; half-year convention) after taking into account the maximum section 179 deduction and assuming no bonus depreciation is clamied?

Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years.

(1) Calculate the required monthly mortgage payment for Mr. Davidson.

(2) Construct the 2018~2047 amortization table for Mr. Davidson.

(1)   Mr. Davidson should prepare his 2018 tax filings in early 2019. Please compute the total mortgage interest payments which he can use for his 2018 tax deductions.

Need step by step help on how to solve this on excel!

The Young Company enters into a long-term project to build a new office building. The Contract price is $9,000,000 and Young expects to complete the project in three years. Young gives you the following information for the first two years regarding the project:

Required:

1.    Prepare the journal entries to record the above information for both 2017 and 2018 under the percentage of-completion method.

2.    What items would be disclosed on the Company’s December 31, 2018 balance sheet?

Prat Corp. started the 2018 accounting period with $31,000 of assets (all cash), $12,500 of liabilities, and $16,000 of common stock. During the year, the Retained Earnings account increased by $16,550. The bookkeeper reported that Prat paid cash expenses of $31,500 and paid a $3,100 cash dividend to the stockholders, but she could not find a record of the amount of cash that Prat received for performing services. Prat also paid $5,500 cash to reduce the liability owed to the bank, and the business acquired $6,900 of additional cash from the issue of common stock.

a-1. Prepare an income statement for the 2018 accounting period. a-2. Prepare a statement of changes in stockholders’ equity for the 2018 accounting period. a-3. Prepare a period-end balance sheet for the 2018 accounting period. a-4. Prepare a statement of cash flows for the 2018 accounting period.

2. At the end of 2018, Builders Inc. has one project underway to build a warehouse. The project was begun in early 2017. The contract amount is $50,000,000 and the project is expected to be completed in late 2019. Data on this project are presented below:

Costs incurred in 2017 $8,000,000

Billings in 2017 $6,000,000

Estimated cost to complete at 12/31/17 $32,000,000

Additional costs incurred in 2018 $19,000,000

Billings in 2018 $15,000,000

Estimated cost to complete at 12/31/18 $18,000,000

Required:

1) For the Percentage of Completion Method, prepare the journal entries to record (a) the costs incurred, (b) the billings, and (c) recognition of any revenue or expense for both 2017 and 2018.

2) For the Percentage of Completion Method, present the income statement and balance sheet disclosure that would be required for 2017 and 2018.