SQL

This assignment aligns with the following objectives:

• Create a relational database containing at least three tables
• Populate the database using the INSERT command
• Create integrity constraints on the tables created

Deli has hired you as a consultant to design a database for the deli. They have provided you with the following information:

• Every employee has a social security number, name, salary, and date of hire.
• The deli is organized into several departments. Each department has a unique name.
• Each department has exactly one employee as its manager but an employee may manage more than one department. The database should record the date when the most recent manager of each dept. was appointed in that position.
• very employee must be assigned a department.
• Every employee has a supervisor who need not be the manager of any department.

The deli has these four departments:

1. hot foods
2. sandwich
3. snacks
4. beverage

You are provided the following additional information, which should be inserted into the database using SQL queries (not using any GUI interfaces, such as PhpMyAdmin):

• Jim Jones (ssn: 134-56-8877, salary: $28,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Rita Bita)
• Rita Bita (ssn: 138-56-8050, salary: $32,000, dept: beverages, date of hire: 2/15/2017, supervisor: Holly Dew. manages: beverages, starting 3/18/2018)
• Holly Dew (ssn: 334-55-8877, salary: $29,000, dept:sandwich, date of hire: 1/15/2016, supervisor: Pablo Escobar)
• Pablo Escobar (ssn: 666-56-6666, salary: $48,000, dept:snacks, date of hire: 1/26/2014, supervisor: Rita Bita, manages: snacks, starting 5/5/2015)
• Al Capone (ssn: 888-91-8870, salary: $40,000, dept:hot foods, date of hire: 1/26/2015, supervisor: Pablo Escobar, manages: hot foods, starting 1/1/2016)
• Bonnie Clyde (ssn: 111-22-3333, salary: $42,000, dept: sandwiches, date of hire: 4/7/2015, supervisor: Al Capone, manages: sandwich, starting 1/1/2016)

Helpful Hints:

Please do not assume that the database should be structured in the way this data is provided. Your database should be structured such that constraints such as “Each dept. has exactly one employee as a manager” can be enforced.

There should not be a separate table for Deli – the entire database represents the deli. There should be a table for each major entity mentioned in the specifications. Relations between entities (such as, who works in which department) should be their own tables. Primary keys for each table should be chosen to enforce constraints.

Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include expenditures and other charges (including depreciation) directly and indirectly incurred in bringing the inventory to its existing condition and location.

In 2016, 2015 and 2014, net income included losses of $295 million and $186 million, and a gain of $187 million, respectively, attributable to the combined effects of LIFO inventory accumulations and drawdowns. The aggregate replacement cost of inventories was estimated to exceed their LIFO carrying values by $8.1 billion and $4.5 billion at December 31, 2016, and 2015, respectively.

Crude oil, products and merchandise as of year-end 2016 and 2015 consist of the following:

5.3 If ExxonMobil had used FIFO in 2016, what would be the value of the inventory?

1. Given a function φ(z) with z = x+iy let

   U(x, y) = ½ [φ(x+iy) + φ(x-iy)] and V(x, y) = i/2 [φ(x+iy) –φ(x-iy)]

A) For φ(z) = z² find U and V and their induced vector fields E =▼U and

F =▼V also show that ▼²U = ▼²V = 0

B) Repeat for f(z) = z³

C) For f(z) = ln z we get U(x, y) = ½ ln (x²+y²) and V(x, y) = arctan (y/x) Find ▼U (electrostatic field) and ▼V (magnetic field) . Also, show that ▼²U = ▼²V = 0 for x²+y² ǂ 0.

a 2d collision

Perform a linear fit, of the form x = A*t + B, to each graph and determine the initial velocity v1 and the final velocities v′1x, v′1y, v′2x, and v′2y. How do I find the v′1y

if: time (sec)= 0.400, 0.460, 0.500, 0.530, 0.560, 0.600, 0.630, 0.670, 0.700, 0.730, 0.700,0.800, 0.830, 0.867, 0.900

position (m) in y dxn= 85, 100, 120, 140, 160, 180, 190, 210, 230, 240, 260, 270, 290, 300, 320

position (m) in x dxn= 800, 850, 920, 980, 1000, 1080, 1140, 1190, 1230, 1280, 1300, 1400, 1440, 1490, 1500

a) Calculate the cell potential at 25°C for the cell

Fe(s) I (Fe²⁺ (0.100 M) II Pd²⁺ (1.0 × 10^-5 M) I Pd(s)

given that the standard reduction potential for Fe²⁺/Fe is -0.45 V and for Pd²⁺/Pd is +0.95 V. - Please show the steps

The Banana Republic’s stock of capital at the end of 2015 was $200 billions. The Republic’s investment during the year 2016 was $ 40 billions. The depreciation rate in the Republic was 10%.  

1. Depreciation of the capital during the year 2016 was _______

2. The net investment during the 2016 in the Republic was _______

3. The stock of capital at the end of 2016 was _________

public class ProductThread {

static class ProductThreads extends Thread{

private int begin, end;

int[] v1, v2;

long ris;

public ProductThreads(String name, int [] v1, int [] v2, int begin, int end) {

setName(name);

this.v1 = v1;

this.v2 = v2;

this.begin = begin;

this.end = end;

this.ris = 0;

}

public void run() {

System.out.println("Thread " + Thread.currentThread().getName() + "[" + begin + "," + end + "] started");

ris = 1;

for(int i = begin; i <= end; i++)

ris *= v1[i] * v2[i];

System.out.println("Thread " + Thread.currentThread().getName() + "[" + begin + "," + end + "] completed");

}//run

public long getResult() {

return ris;

}

}//ProductThread

public static void main(String[] args) throws InterruptedException {

int [] a = {1,2,3,4,5,6,7,8,9,10};

int [] b = {1,2,3,4,5,6,7,8,9,19};

System.out.print("A = " );

print(a);

System.out.print("B = " );

print(b);

System.out.println();

//create threads

ProductThreads t0 = new ProductThreads("T0", a, b, 0, 2);

ProductThreads t1 = new ProductThreads("T1", a, b, 3, 5);

ProductThreads t2 = new ProductThreads("T1", a, b, 6, 9);

//start threads

t0.start();

t1.start();

t2.start();

//wait for completion of threads

t0.join();

t1.join();

t2.join();

//computation of final result

long result = 1;

System.out.println("T0 result= " + t0.getResult());

System.out.println("T1 result= " + t1.getResult());

System.out.println("T2 result= " + t2.getResult());

result *= t0.getResult() * t1.getResult() * t2.getResult();

System.out.println();

//final statement to be printed

System.out.println("Final Results = " + t0.getResult() + " * " + t1.getResult() + " * " + t2.getResult() + "= " + result);

}

static void print(int[] v) {

System.out.print("[");

for (int i = 0; i < v.length; i++) {

System.out.print(v[i] + " ");

System.out.println("]");

}

}

}

Using the same type of multithreading, I need to create a simple program that generates the factorial of a number, but splits up the calculation in multiple threads.

For instance, 5! = 5 * 4 * 3 * 2 * 1 so the threads would split the calculation up. Ex: T1 = 5 * 4 * 3 + T2 = 2 * 1

Lab 5: Practice Dilution Problems

You have a stock solution that contains 24 mg/ml of protein. You want to make a set of standards with the following concentrations:

                  8 mg/ml

                  4 mg/ml

                  2 mg/ml

You need a minimum of 300 ul of each standard.

Using the technique of serial dilution, explain how you would make your standards by filling in the chart below.

You have a stock solution that contains 200 mg/ml of protein. You want to make a set of standards with the following concentrations :

                  100 mg/ml   12.50 mg/ml

                  50 mg/ml    6.25 mg/ml

                  25 mg/ml    3.125 mg/ml

You need a minimum of 300 ul of each standard.

Using the technique of serial dilution, explain how you would make your standards by filling in the chart below.

Dilute the following making sure you end up with a minimum volume of at least 10 ml.

Comprehensive

Instructions

Chart of Accounts

General Journal

Labels and Amount Descriptions

Income Statement

Retained Earnings

Balance Sheet

Instructions

At the beginning of 2016, Norris Company had a deferred tax liability of $6,300, because of the use of MACRS depreciation for income tax purposes and units-of-production depreciation for financial reporting. The income tax rate is 30% for 2015 and 2016, but in 2015 Congress enacted a 38% tax rate for 2017 and future years.

Norris’s accounting records show the following pretax items of financial income for 2016: income from continuing operations, $122,300 (revenues of $353,300 and expenses of $231,000); gain on disposal of Division F, $23,000; loss from operations of discontinued Division F, $10,200; and prior period adjustment, $15,200, due to an error that understated revenue in 2015. All of these items are taxable; however, financial depreciation for 2016 on assets related to continuing operations exceeds tax depreciation by $4,000. Norris had a retained earnings balance of $160,900 on January 1, 2016, and declared and paid cash dividends of $33,600 during 2016.

Required:

General Journal

Prepare Norris’s income tax journal entry on December 31, 2016.

PAGE 1

GENERAL JOURNAL

Labels and Amount Descriptions

Income Statement

Prepare Norris’s 2016 income statement. Additional Instructions

Retained Earnings

Prepare Norris’s 2016 statement of retained earnings. Additional Instructions

Balance Sheet

Show the related income tax disclosures on Norris’s December 31, 2016, balance sheet. Additional Instructions

Jefferson Ltd is a small retail business that operates in the United Kingdom. The company was formed in December 2015 and commenced its new year on 1 January 2016 with

£25,000 in share capital. Jefferson Ltd also has £6,000 in the bank and £15,000 of finished goods stock for resale. This information had already been recorded in the accounting records of Jefferson Ltd.

The company has agreed a bank overdraft facility of up to £15,000.

The following transactions had been budgeted for the first 6 months of 2016.

Sales of goods to debtors in the 6 months to June 2016 were expected to be £160,000 in total, and transacted as follows:

Gross profit margins are always 35% of sales and it was Jefferson Ltd’s policy to have sufficient finished goods stock at the end of each month to service the following month’s cost of sales. The sales forecast for July 2016 was £55,000.

Purchases of goods for resale in the six months to June 2016, based on the above information, were £114,750 and were budgeted to be as follows:

Other transactions:

• Plant and equipment was to be purchased for cash, £10,000, in January 2016, and £20,000 in June 2016.
• The plant and equipment depreciation for the 6 month period is included in the other operating costs, below;
• Director’s salary £2,000 per month was to be paid in cash January to June 2016;
• Sales assistant’s wages £1,000 per month was to be paid in cash January to June 2016;
• Other operating costs, £2,200 per month, include depreciation on plant and equipment, £100 per month. The cash operating expenses were to be paid in cash, each month, January to June 2016;
• Corporation tax of £652 was to be paid in June 2016;
• Bank finance charges of £15 were to be incurred in February 2016;

• Debtors were budgeted to pay in full one month after the month of the sale. In this respect sales made in January 2016, for example, would be paid for in February 2016. Debtors for December 2015 were £40,000.
• Creditors were to be paid in full, two months after the purchase of stock. In this respect purchases of stock made in January 2016 would be paid for in March 2016. Creditors for November and December 2015 were £20,000 and £30,000, respectively.
• A dividend of £1,400 was to be paid during June 2016.

Required:

1. For the 6 months period to June 2016, produce the following for Jefferson Ltd

1. A monthly cash budget;
2. A budgeted income statement for the year ended 30 June 2016; and
3. A budgeted statement of financial position as at 30 June 2016

The cash flow forecast must indicate the cash in hand or overdrawn at the end of each month.