An investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profits ($) of each investment under each economic condition are indicated in the following payoff table:

INVESTMENT SELECTION

EVENT A B C

Economy declines 500 -2000 -7000

No change 1000 2000 -1000

Economy expands 2000 5000 20000

Based on his own past experience, the investor assigns the following probabilities to each economic condition:

P (Economy declines) = 0.30

P (No change) = 0.50

P (Economy expands) = 0.20

a. determine the optimal action based on the maximax criterion.

b. determine the optimal action based on the maximin criterion.

c.compute the the expected monetary value for each investment

d. compute the expected opportunity loss for each investment

e. based on (c) or (d) which investment would you choose, and why?

2. working with databases and files in python

a) Write a function with prototype “def profound():” that will prompt the user to type something profound. It will then record the date and time using the “datetime” module and then append the date, time and profound line to a file called “profound.txt”. Do only one line per function call. Use a single write and f-string such that the file contents look like:

2020-10-27 11:20:22 -- Has eighteen letters does

2020-10-27 11:20:36 -- something profound

b) Write a function with prototype “def bestwords():” that will prompt the user to enter a line with some of the best words (separated by spaces). These will be converted to lower case and stored in a data base file (using the dbm and pickle modules) whose keys are a tuple of the current year, month and day (using the datetime module) and the “values” are a set of words collected on that day. Each new word should be checked against all previously-entered words (even those on other days) and it is not added if it already exists in the database. (Hint: I simply subtracted all previous sets of words from the current set, then added that new set to the one for the current day (if it already existed).

c) Write a function with prototype “def printbestwords():” that will simply open the database of best words and print the keys and values, sorted by the keys. Don’t forget to close the database on exit. Example output:

(2020, 10, 26) {'infantroopen', 'susbesdig'}

(2020, 10, 27) {'deligitimatize'}

(2020, 10, 28) {'transpants', 'resaption'}

Consider the below database schema for company ABC:

Employee(empNo, givename, famname, gender, DOB)

Supervises(super_empNo*, empNo*, description)

Department(deptNo, name, manager_empNo*)

Dependent(empNo*, name, relationship)

Project(projNo, description, deptNo*)

The relations Employee, Supervises, Department, Dependent and Project keep data for employees, supervision, departments, dependents of employees and projects of ABC.

For the database, primary keys, and parent and child relations for foreign keys are annotated. The meaning of most attributes is self-explanatory. Answer questions below.

Your answer to each question must be according to the given database schema and instance.

1.1. (2 points) Does the primary key of Supervises (super_empNo, empNo) ensure that each supervisor supervises a different employee? Explain your answer.

1.2. (5 points) Is it possible that a project has no department? Explain why/why not. If possible, identify any data integrity constraints that can be placed on the Project table to prevent this? Can a project have many departments? Explain using the data integrity constraints on the Project table.

1.3. (2 points) Is it possible that a supervisor does not supervise any employees? Explain your answer using the data constraints on the Supervises table.

1.4 (3 point) Assuming that every department is working on at least one project (and the Department table contains a record with department number 8), can the SQL statement below be successfully executed? Explain your answer. DELETE FROM Department WHERE deptNo = 8;

Introduction to the Problem

Design an Amazon Virtual Private Cloud (VPC):

"Scenario: You have a small business with a website that is hosted on an Amazon Elastic Compute Cloud (Amazon EC2) instance. You have customer data that is stored on a backend database that you want to keep private. You want to use Amazon VPC to set up a VPC that meets the following requirements:

•          Your web server and database server must be in separate subnets.

•          The first address of your network must be 10.0.0.0. Each subnet must have 256 total IPv4 addresses.

•          Your customers must always be able to access your web server.

•          Your database server must be able to access the internet to make patch updates.

•          Your architecture must be highly available and use at least one custom firewall layer."

For the Program Level Assessment, short summary report using the following criteria:

Define the Problem

re-state the problem you are asked to solve and detail all relevant findings and recommendations.

Identify Strategies

Explain how your VPC design meets requirements in scenario.

Propose Solutions

How you can improve or change your design using additional services learned in class.

Evaluate Outcomes

Briefly explain how your design and propose solutions meets at least two of the pillars of AWS Well-Architected Framework.

Submit a Word Document

Using the section headers above, provide responses for each and summary report.

Morning Star Ltd was registered on 1 July 2018, as a company with a constitution limiting the

shares that could be offered to 7 000 000 Ordinary shares (including all classes) and 2 000 000

preference shares. The company issued a prospectus dated 1 July 2018 inviting the public to

apply for 4 000 000 Ordinary A class shares at $3.00 per share. The terms of the shares on issue

are $1.50 on application, $1.00 on allotment and $0.50 to be called within six months of

allotment before 31 December 2018.

If the issue is oversubscribed the directors will make a pro-rata issue of shares and the excess

application money will be applied to allotment and calls before any refunds will be given.

On 15 July, the directors also decided to issue 1 000 000 non-voting Ordinary B shares as fully

paid to the promoters for a payment of $2.00 per share.

On 30 July applications closed. Applications for 5 000 000 shares in total had been received with

applicants for 3 500 000 shares paying the full price and 1 500 000 shares paying only the

application fee.

On 1 August, the shares were allotted with all allotment money owed paid by the 30 August.

The company paid share issue costs of $100,000 for the issuing of Ordinary A shares on 1

September. The share issue costs related to legal expenses associated with the share issue and

fees associated with the drafting and advertising of the prospectus and share issue.

The call on the Ordinary A shares was made on 15 Septmber and due by 30 September. All call

money was received except for the call on 75 000 shares. The directors met and forfeited the

shares on 15 October. On 30 October the forfeited shares were reissued at $2.80 fully paid to

$3.00. Costs associated with reissuing the forfeited shares totalled $5,000. The remaining money

was refunded to the defaulting shareholders on 15 November.

The directors decided on 1 November to make a one-day offer of a non-renouceable rights issue

to existing Ordinary A shareholders to purchase additional shares at $1 each for every 5 shares

of holding. Holders of 2 000 000 shares exercised their right.

On 1 January 2019, Morning Star Ltd issued via a private placement semi-annual coupon

debentures (which pay interest every 6 months) with a nominal value of $300,000. The debenture

term is five years and the coupon rate is 12% per year. The market requires a rate of return of

10% per year. The money came in and the debentures were allotted on the same date.

The company issued via a private placement 1 million redeemable preference shares of $2.00

each on 30 June 2019. The shares offer a fixed dividend of 7 per cent per annum. The shares are

later redeemed to non-voting Ordinary Class B shares at the options of the shareholders on 30

June 2021.

Required:

(a) Prepare journal entries for the above transactions for the year ended 30 June 2019.

Note: the entries should be in strict date order of the underlying event.

There are 4 questions required by this exercise (at the very bottom). Show your calculated ratios. Make sure you show the data used to calculate the ratios.

How could the Mortgage crisis of the 2000's been avoided if the market was truly efficient?

What are some examples of economic, social and political growth in America from the 1900-2000?