You are the Senior Systems Administrator for a community based charity. Your charity is involved

in locating and providing accommodation, mental health services, training and support services to

disadvantaged people in the community.

Your charity currently runs a small data centre that has some 50 x86 64 bit servers running mainly

Windows Server 2008 R2 for desktop services, database and file services. It also has about 10 Red

Hat Enterprise Linux 5 servers for public facing Web pages, services and support.

Your charity is considering joining a community cloud provided by a public cloud vendor in order

to provide a number of applications to all 500 support staff and administrative users. The

community cloud would also be used to store the charity’s 200TB of data. This data contains a

considerable amount of confidential information about the people to whom the charity provides

services. A small number of the charity’s applications are mission critical and the data that those

applications use is both confidential and time sensitive.

The cloud vendor has made a presentation to management that indicates that operational costs

will drop dramatically if the cloud model is adopted. You are asked to assess whether this model is

in the best interests of the business.

Describe the steps that you would take to do a Risk Management assessment of this proposal.

20. Ramgovind, Eloff and Smith proposed in their 2010 paper that an information security analysis

should include the requirements of Identification and authorisation, authorisation,

confidentiality, Integrity, non-repudiation and availability. Discuss whether these

requirements are adequate for a proper security assessment for a proposed move to an IaaS

model for the charity.

21. A potential migration to the Cloud raises many issues around Governance. Discuss the

governance issues that you see arising from a migration of on-premise servers to an IaaS

model.

22. The charity’s board has proposed a move to migrate its servers to an IaaS model. Discuss the

methods that you would propose to the board to assess the SLA of the Cloud Provider. (10

marks)

23. The board has decided, as an initial step, to move the office automation and database servers

to the AWS cloud in order to begin the migration process, and test their strategy. Describe ten

steps that you would include in the plan to migrate these services.

Choose one health communication campaign to focus on and explain the campaign to your colleagues.

Let's Stop HIV Together

What is the target audience? Is the target audience suffering from a specific ailment or morbidity (disease)?

Share and describe two objectives of the campaign.

Inform your colleagues if the campaign has demonstrated evaluative success or not? Explain using statistics.

Is the campaign designed to prevent, intervene or rehabilitate the target population? Discuss and explain.

The Let’s Stop HIV Together campaign raises awareness about HIV and its impact on the lives of all Americans, and fights stigma by showing that persons with HIV are real people—mothers, fathers, friends, brothers, sisters, sons, daughters, partners, wives, husbands, and co-workers.

More than a million people are living with HIV in the U.S., and the images and stories in this campaign are reminders that HIV does not discriminate across race, gender, or age.

Then, describe two health promotion methods the campaign utilized to reach the target audience. Did the campaign use public service announcements? Fact sheets? Education groups? Thoroughly explain how and what methods were utilized.

Every voice and every story is important. Individuals featured in Let’s Stop HIV Together have shared their stories to raise awareness, fight stigma about HIV, encourage HIV prevention and testing, and champion the power of relationships in the personal and public fight to stop HIV.

Explain the channels the campaign used to reach the population. Did the campaign use television? Radio? Interpersonal communication?

Whether it’s a conversation, text message, Facebook status update, or a tweet—we must talk to each other about HIV and how we can prevent it. In fact, you can do it right now.

Post two questions you have regarding the campaign. Respond to two questions or the health promotion methods discussed by your colleagues.

Does program plan to expand?

And are these health promotions reaching the youth groups?

Use your text as a resource in addition to the website and other scholarly sources as needed. Include APA citations and references.

QUESTION 1

Anna Ltd is a tropical fruit wholesaler in Sydney, Australia. Anna Ltd decides to expand its business by acquiring one of its most successful customers, Lucy Ltd, which squeezes and packs the fruit juice for different companies, and also for its own brand, “Lucy”.

On 1 July 2018, Anna Ltd purchased 80% of Lucy Ltd’s shares for $1,150,000 cash.

On acquisition date, Lucy Ltd’s statement of financial position was as follows:

Additional information:

• On acquisition date, all the assets and liabilities of Lucy Ltd are recorded at their fair values in Lucy Ltd’s statement of financial position, except an internally generated brand name, “Lucy” whose fair value was estimated to be $100,000.
• During the 2018-2019 financial year, Anna Ltd has sold to Lucy Ltd inventory for $110,000. This inventory had originally cost Anna Ltd $70,000. On 30 June 2019, 25% of this inventory was still in Lucy Ltd’s closing inventory.
• During the 2018-2019 financial year, Lucy Ltd paid dividends of $150,000.
• The tax rate is 30%.

REQUIRED:

1. Calculate the amount of goodwill or gain on bargain purchase arising from Anna Ltd’s acquisition of Lucy Ltd. Show all workings necessary to derive your answer.
2. Provide the consolidation journal entries required to prepare the consolidated financial statements for the year ended 30 June 2019. Journal entries allocating equity to non-controlling interests are not required. Show all workings necessary to derive your answer.
3. Create an example of a business combination which results in a gain on bargain purchase and show the calculation of the gain on bargain purchase.

This question covers aspects and integration of personal development planning and data analysis skills towards professional engineering competencies for employability.

Consider the data-set shown in Table 2, which is a subset of employment statistics for the UK from between 2009 and 2018. For the dates specified, the data records an estimate of the number of thousands of engineering professionals, and of IT and Telecommunications professionals, classified according to sex.

Table 2 A subset of employment statistics for the UK from 2009 until 2018

Source: https://www.ons.gov.uk/employmentandlabourmarket/peopleinwork/employmentandemployeetypes/datasets/employmentbyoccupationemp04

• Imagine that you have been invited to a job interview where you will be asked to give a presentation to a non-expert audience. In advance of the interview you are sent the data in Table 2.
  • i.By use of appropriate representation identify and show three significant correlations or trends in the data, and suggest reasons for these trends. Include your representation as part of your answer, together with descriptions of the three correlations or trends you have identified.
  • ii.Comment on the reliability of your observations of the trends in the data.

Write a SQL query to find the movie Title that has received Lowest rating from reviewers, but whose actors have received an award for their contribution in movie.

Output: Fantastic Beasts and Where to Find Them

           //   THE DATABASE //

DROP DATABASE IF EXISTS cs431_movie_database;
CREATE DATABASE cs431_movie_database;
USE cs431_movie_database;

CREATE TABLE `artists` (
`artist_id` INT NOT NULL AUTO_INCREMENT,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`contact_no` varchar(15) DEFAULT NULL,
`Profession` TEXT DEFAULT NULL,
`birth_date` datetime DEFAULT NULL,
`address` TEXT DEFAULT NULL,
PRIMARY KEY (`artist_id`)
) ;

CREATE TABLE `movies` (
`movie_id` INT NOT NULL AUTO_INCREMENT,
`title` varchar(45) NOT NULL,
`genre` varchar(25) NOT NULL,
`gross` decimal(6,2) DEFAULT NULL,
`Distributor` varchar(45) NOT NULL,
`release_date` datetime DEFAULT NULL,
PRIMARY KEY (`movie_id`),
KEY `genre_fk_idx` (`genre`)
) ;

CREATE TABLE `awards` (
`awards_id` INT NOT NULL AUTO_INCREMENT,
`movie_id` INT DEFAULT NULL,
`person_id` INT DEFAULT NULL,
`category` varchar(45) DEFAULT NULL,
PRIMARY KEY (`awards_id`),
KEY `person_id_idx` (`person_id`),
KEY `movie_id_idx` (`movie_id`),
CONSTRAINT `movie_awards_fk` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`movie_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `person_awards_fk` FOREIGN KEY (`person_id`) REFERENCES `artists` (`artist_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ;

CREATE TABLE `movies_ratings` (
`rating_id` INT NOT NULL AUTO_INCREMENT,
`movie_id` INT NOT NULL,
`person_id` INT NOT NULL,
`number_of_stars` INT DEFAULT NULL,
PRIMARY KEY (`rating_id`),
KEY `movies__ratings_fk_idx` (`movie_id`),
KEY `artist_ratings_fk_idx` (`person_id`),
CONSTRAINT `artist_ratings_fk` FOREIGN KEY (`person_id`) REFERENCES `artists` (`artist_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `movies__ratings_fk` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`movie_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ;

CREATE TABLE `movie_cast` (
`id` INT NOT NULL AUTO_INCREMENT,
`movie_id` INT DEFAULT NULL,
`person_id` INT DEFAULT NULL,
`category` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `person_id_idx` (`person_id`),
KEY `movie_id_idx` (`movie_id`),
CONSTRAINT `movie_cast_fk` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`movie_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `person_cast_fk` FOREIGN KEY (`person_id`) REFERENCES `artists` (`artist_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ;

INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (1,'Idrissa Akuna ','Elba','4706091972','Actor','1972-09-06 00:00:00','CA');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (2,'Christopher Hemsworth','Hemsworth','3408111983','Actor','1983-08-11 00:00:00','IL');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (3,'Zoe ','Saldana','4106191978','Actor','1978-06-19 00:00:00','AZ');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (4,'Christopher','Townsend','3903251976','Visual Effects','1976-03-25 00:00:00',NULL);
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (5,'Guy','Williams','3209211985','Reviewer','1985-09-21 00:00:00',NULL);
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (6,'Jonathan','Fawkner','3011131990','Reviewer','1990-11-13 00:00:00',NULL);
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (7,'Dan','Sudick','4701201972','Visual Effects','1972-01-20 00:00:00','NJ');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (8,'Tom','Holland','2401061996','Actor','1996-06-01 00:00:00','CA');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (9,'Justin ','Marks','2804021992','Screenplay','1992-04-02 00:00:00','LA');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (10,'Adam','McGay','5104171968','Director','1968-04-17 00:00:00','PA');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (11,'Adam','McGay','5104171968','Actor','1968-04-17 00:00:00','PA');
INSERT INTO artists (`artist_id`,`first_name`,`last_name`,`contact_no`,`Profession`,`birth_date`,`address`) VALUES (12,'Justin ','Marks','2804021992','Screenplay','1992-04-02 00:00:00','LA');

INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (1,'Star Wars','Sci Fi',2.06,'Disney','2015-12-18 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (2,'Jurassic World','Sci Fi',1.67,'Universal','2015-05-29 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (3,'Minions','Comedy',1.15,'Universal','2015-07-10 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (4,'The Jungle Book','Adventure',9.66,'Disney','2016-04-04 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (5,'Fantastic Beasts and Where to Find Them','Fantasy',8.14,'Warner Bros','2016-09-10 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (6,'Zootopia','Comedy',1.02,'Disney','2016-02-13 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (7,'Beauty and the Beast','Fantasy',1.26,'Disney','2017-02-23 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (8,'Spider-Man: Homecoming','Super Hero',8.80,'Sony','2017-06-28 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (9,'Guardians of the Galaxy Vol. 2','Super Hero',8.60,'Disney','2017-04-10 00:00:00');
INSERT INTO movies (`movie_id`,`title`,`genre`,`gross`,`Distributor`,`release_date`) VALUES (10,'Thor: Ragnarok','Super Hero',8.54,'Disney','2017-10-10 00:00:00');

INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (1,1,1,'Actor');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (2,1,2,'Actor');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (3,1,4,'Visual Effects');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (4,2,5,'Visual Effects');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (5,2,3,'Actor');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (6,5,10,'Director');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (7,4,9,'Screenplay');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (8,5,2,'Actor');
INSERT INTO awards (`awards_id`,`movie_id`,`person_id`,`category`) VALUES (9,5,10,NULL);

INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (1,1,1,'Actor');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (2,1,2,'Actor');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (3,1,4,'Visual Effects');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (4,2,5,'Visual Effects');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (5,2,3,'Actor');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (6,5,10,'Director');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (7,4,9,'Screenplay');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (8,5,2,'Actor');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (9,5,10,NULL);
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (10,1,10,'Director');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (11,2,2,'Actor');
INSERT INTO movie_cast (`id`,`movie_id`,`person_id`,`category`) VALUES (12,2,7,'Visual Effects');

INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (1,1,5,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (2,2,5,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (3,3,5,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (4,4,5,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (5,5,5,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (6,6,5,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (7,7,5,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (8,8,5,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (9,1,6,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (10,2,6,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (11,3,6,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (12,4,6,5);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (13,7,6,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (14,8,6,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (15,9,6,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (16,10,6,4);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (17,9,5,NULL);
INSERT INTO movies_ratings (`rating_id`,`movie_id`,`person_id`,`number_of_stars`) VALUES (18,10,5,NULL);

Please create a matrix A by extract the first 9 entries(first 9 rows) from Ownership(income&lot size) and first 9 entries(first 9 rows) from Non ownership(income& lotsize) by using matlab from the table below:

• High Frequency Trading – Challenges and Opportunities. write a paper of 2000 to 2500 words.

kindly, describe Importance of introducing micro takaful schemes.
must be 2000 words.

Write an algorithm that print all numbers that are divisible by 3 between 1000 and 2000

What role did Enron play in the California energy crisis of 2000-2001?