25.65% is Google’s Long Term Assets as % of Total Assets 2018.

70.82% is Walmart’s Long Term Assets as % of Total Assets 2018.

-What are the possible reasons for the difference in Long Term Assets value between the two companies?

-Which company has the stronger asset turnover in 2018?  What does Asset turnover indicate?

Automotive antifreeze consists of ethylene glycol, CH2(OH)CH2(OH),a non volatile non electrolyte. Calculate the boiling point and freezing point of a 25.0 mass % solution of ethylene glycol in water.
(for water, Kb= 0.51 degrees Celsius c/m, Kf =1.86 degrees c/m; molar mass of C2H6O2 = 62.1 g/mol)

Non-financial performance indicators (400 words)

Comment on non-financial performance indicator of United Utilities Group PLC (UU).

http://financials.morningstar.com/balance-sheet/bs.html?t=UU.&region=gbr&culture=en-US

1. China has over $1 trillion dollars in ‘non-performing loans’. Define ‘non-performing

loans’ and tell how they are handled in the USA.

2. Again, you have read about China’s non-performing loans. What other 3 factors would you look at to validate (confirm) the idea that that the currency will soon be devalued.

3. The interest rate now used globally as the basis for loans has an acronym called ____________ . What does this acronym stand for? ___________________________________________

In Chapter 11 we discussed diversifiable vs. non-diversifiable (i.e., "Systematic") risk.

A diversified portfolio reduces non-systematic (i.e., "diversifiable") risk.

But, what if I do not diversify, and therefore hold some portion of diversifiable risk that I have not reduced through diversification? I am taking more risk, and I need more return to compensate me for the additional risk.

But, will the marketplace compensate me for the additional risk I am taking? Will assets be priced such that I can comfortably take the additional risk and get paid for it?

Draw a relational model for the following case study.
Case Study
The local under-sixteen football league needs a database to help track teams, children
that sign up to play in the league, the parents of these children and the coaches for each
team.
The league wishes to record the details for each parent of a particular player (the parents
last name, first name, phone contact number and address). For each player, the system
needs to record the player's last name, first name, blood type and their date of birth. Any
allergies that the player has also need to be recorded.
A player may only play in one team with this league. Each team is given a unique id, the
system needs to record this id, the teams name, and the city their home ground is located
(a city may have several under-sixteen teams based in it). A team’s colours are also to be
recorded, teams may choose to use a single or multiple team colours. A team may have
several coaches – one of the coaches is designated as the head coach.
A coach is only permitted to coach one team in the under-sixteen leagues. All
communications from the league to the team are via the head coach. To be registered to
play in this league a team must have a head coach and at least one player. The database
needs to track a coach's first and last name, phone and address contact details and the
team that they are coaching.

Exercise 1

A company is planning to reconfigure storage for their accounting application for high availability

Current configuration and challenges:

Application performs 15% random writes and 85% random reads

Currently deployed with five RAID 0 configuration

Each disk has an advertised formatted capacity of 200 GB

Total size of the accounting application's data is 730 GB which is unlikely to change over 6 months

Approaching end of financial year, buying even one disk is not possible

Task

Recommend a RAID level that the company can use to restructure their environment fulfilling their needs

Justify your choice based on cost, performance, and availability

Exercise 2

The same company is now planning to reconfigure storage for their database application for high availability

Current configuration and challenges

The application performs 40% writes and 60% reads

Currently deployed on a six disk RAID 0 configuration with advertised capacity of each disk being 200 GB

Size of the database is 900 GB and the amount of data is likely to increase by 30% over the next 6 months

It is a new financial year and the company has an increased budget

Task

Recommend a suitable RAID level to fulfill the company's needs

Estimate the cost of the new solution (200GB disk costs $1,000)

Justify your choice based on cost, performance, and availability

Consider the following relational database schema:

            employee(employee-name, employee-id, street, e-city)

            works(employee-id, company-id, salary)

            company(company-name, company-id, c-city)

            manages(employee-id, manager-id)

Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below.

1. Retrieve the name and address of employees who work for First Bank Corporation.

2. Retrieve the name, street address, and city of residence of all employees who work for Thrifty Industries and earn more than $10,000 per year.

3. Retrieve the name of all employees who live in the same city as the company for which they work.

4. Retrieve the name of all employees who live on the same street and in the same city as do their managers.

5. Retrieve the name of all employees who do not work for First Bank Corporation.

6. Retrieve the name of all employees who earn more than every employee of Small Bank Corporation.

7. (Assume that companies may be located in several cities) Retrieve all companies located in every city in which Thrifty Industries is located.

8. For each company, find the average salary of employees working for that company.

9. For each city, find the number of employees who work for at least one company in that city.

You have been given the following specifications for a simple database about the requests for software that staff members make for their units (note that primary keys are shown underlined, foreign keys in bold). You should run your SQL to demonstrate that it works correctly, and paste in the statements used plus the output from Oracle.

LAB (RoomNo, Capacity)

SOFTWARE (SoftwareID, SoftwareName, Version)

REQUEST (SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress)

Based on the table specifications provided, answer the following questions.

a. Give the SQL to create the LAB and SOFTWARE tables. Choose appropriate data types. None of the attributes should be allowed to be null. Include the primary key constraints.

b. Give the SQL to create the REQUEST table. Use appropriate data types, and include the primary key and foreign key constraints. Referential integrity should be set such that if a lab is deleted from the database, any requests that exist for that lab are also deleted.

c. Give the SQL to add a record to each of the tables: LAB, SOFTWARE and REQUEST. Make up your own data (you may wish to add lab 350.2.006 to the LAB table for testing in part (e) later).

d. Give the SQL to create a constraint to the REQUEST table to restrict the possible values of Progress to the following 5: Requested, Installed, Function Testing, User Acceptance Testing, and Deployed.

e. Give the SQL to record the fact that the capacity of lab 350.2.006 has increased by 5.

Write the following questions as queries in Relational Algebra. Use only the operators discussed in class (select, project, Cartesian product, join, union, intersection, set difference and renaming —in particular, no outer joins or aggregations). Type your answers. If you can’t find Greek letters in your word processor, you can simply write out the operator, all uppercase (i.e. ’SELECT’). Please use renaming consistently, as indicated in the handout. Before starting, make sure you understand the schema of the database. If you are in doubt about it, please ask the instructor.

Assume a database with schema:

ACTOR(name,age,address,nationality)

MOVIE(title,year,genre,budget,director-name,studio)

APPEARS(name,title,salary)

Write the following questions in Relational Algebra:

1. List the titles and budgets of movies where actor Keanu Reeves appeared in 1999.

2. List the names and ages of actors who have appeared in a comedy produced by Studio ’MGM’.

3. List the names of directors who have directed a drama or a comedy.

4. List the names of directors who have directed a drama and a comedy.

5. List pairs of actors who have appeared together in a movie (note: the schema of your answer should be (name1,name2), where both name1 and name2 are names of actors.