In 2000 words

: Discus how the fourth industrial revolution could impact on improving electricity sector in South Africa

1. Muna Hsu is an assistant hospitality manager at the Icehouse Arena, home to the Springfield Sharks (the town’s amateur hockey team.) Muna is summarizing two years of sales data from her food vendors. Since each stand supports a different section of the arena, Muna will need to coordinate and consolidate sales data on multiple worksheets. Break the external link that exists in the worksheet, so that the formulas in cells B4, B5, B6, and B7 of the Vendor Information worksheet are replaced with static values. Then switch to the Vendor Information worksheet. 2. Muna wants to update the links in her workbook, so that she’ll be able to quickly pull up the Vendor pricing plans for the 2019-2020 season. In cell B9, create a hyperlink to the Icehouse Arena Vendor Refreshment Price listing for 2019-2020 season as described below: a. The hyperlink should link to the Support_NP_EX16_6a_VendorPrices1920.docx file, available on the SAM website. b. The hyperlink should use 2019-2020 Vendor Refreshment Prices as the text to display. c. The hyperlink should use Click here to view the Vendor Refreshment Price listing for the 2019-2020 season. as the ScreenTip text. 3. Edit the hyperlink Icehouse Arena website in cell B10 as described below: a. The hyperlink should use Icehouse Arena Vendor Website as the display text. b. The hyperlink should use Click here to access the Icehouse Arena Vendor website. as the ScreenTip text. 4. Muna now wishes to give a consistent look and feel to the worksheets submitted by each of the vendor stands. Group the North, East, and South worksheets together and then make the following formatting updates: a. Change the font size in the merged range A1:I1 to 28 pt. b. Apply the Heading 3 cell style to the merged range A2:I2. c. Bold the values in the range A5:A10. d. Apply the Accounting number format with zero decimal places and $ as the symbol to the range B5:I10. (Hint: Depending how you complete this step, the number format for this range may display as Custom.) Do not ungroup the worksheets. 5. With the North, East, and South worksheets still grouped, update the worksheet as described below: a. In cell A7, edit the text to read Shark Bites (instead of Pepperoni Bite). b. In cell A9, edit the text to read Pizza Frenzy (instead of Pizza). Do not ungroup the worksheets. 6. With the North, East, and South worksheets still grouped, select the range B11:H11. Using the AutoSum button, enter a formula using the SUM function that totals the sales for each month of the hockey season (shown in the range B5:H10). Ungroup the worksheets and then check to confirm that the formatting and formulas from steps 4-6 are present in all three worksheets. 7. Muna wants to create a copy of the formatted South worksheet to use for the West section of the arena’s sales data. Create a copy of the South worksheet between the South worksheet and the Consolidated Sales worksheet then update the worksheet as described below: a. Rename the copied worksheet using West as the name. b. In the merged range A2:I2, edit the text to read Feeding Frenzy (instead of Shark Tooth). c. Clear the contents of the range B5:H10. 8. Muna now wishes to consolidate the data from each of the vendor stands. Switch to the Consolidated Sales worksheet. In cell A5, enter a formula without using a function that references cell A5 in the North worksheet. Copy the formula from cell A5 to the range A6:A10 without copying the formatting. 9. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the North:West worksheets. Copy the formula from cell B5 to the range B6:B10 without copying the formatting. Then copy the formulas and the formatting from the range B5:B10 to the range C5:H10. 10. Muna wants to compare the sales from the 2019-2020 season to the 2018-2019 season and needs to include the missing data. Open the support file Support_NP_EX16_6a_1819VendorSales.xlsx. Switch back to the NP_EX16_6a_FirstLastName_2.xlsx workbook and go to the Consolidated Sales worksheet. Create external references in the Consolidated Sales worksheet to the sales information found in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook as described below: a. Using external cell references, link cell J5 in the Consolidated Sales worksheet to cell H5 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. b. Using external cell references, link cell J6 in the Consolidated Sales worksheet to cell H6 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. c. Using external cell references, link cell J7 in the Consolidated Sales worksheet to cell H7 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. d. Using external cell references, link cell J8 in the Consolidated Sales worksheet to cell H8 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. e. Using external cell references, link cell J9 in the Consolidated Sales worksheet to cell H9 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. f. Using external cell references, link cell J10 in the Consolidated Sales worksheet to cell H10 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. g. Do not break the links.

vendor information

North file

East file

South

Consolidated sales

Suppoort NPX16 6A 1819VENDORSALES.xls

Consolidated Sales 2018 2019

support NP EX16 vendorprices1920.docx

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified. This information primarily deals with the assets the airline must use and manage to operate: airports, maintenance flight routes, and scheduled flights onto which customers book seats along with information about the passengers themselves. Employees The company needs to keep the following information regarding its employee. In the US, all employees have a unique social security number. Other information on employees that the airline might need include facts such as the employee's name; the employee's home street address and the employees city, statement and zipcode; the employee's hone phone number; the employee's salary; and the employee's brithdate. Additionally, some employees are pilot crew, while others are attendant crew. For pilots, the company need to keep the following information:the pilot's rank (probationary, junior, regular, senior); a list of the aircraft the pilot is rated to fly; should reference only aircraft the company owns; the number of flight hours the pilots has flown; the pilots home airport (this should be an airport that the airline is allowed to use); and an additional contact number for the pilot. For attendants, the company needs to keep the following information: the attendant's rank (probationary, crew, chief); the attendant's home airport (again it should be one the airline is allowed to use); and an additional contact number for the attendant Airports An airline is only allowed to fly to specific airports. This airline is a US company and is allowed to fly between US domestic airports only. The company needs to maintain information about the airports it is allowed to use. Airports are identified in the US with a three letter code (upper case)m which are unique. Other facts about airports include which city and state they are in, and how many gates are available for boarding and debarking the aircraft customers. The number of gates must be a positive integer. All of this information is required. Airline Flight Routes The airline has many aircraft flying every day to provide transport for its customers. By regulation, the airline is assigned certain routes between a origin airport and a destination airport. Each route (which is identified by a unique code), is schedule for the same time on the same day every week. While the origin and destination airports are the same every time the route is flown, the gates at the origin and destination airports may change from week to week. The origin and destination airports must each refer to one of the airports to which the airline flies. All of this information is required. Scheduled Flights The airline needs to keep track of the flight routes as they are schedule each day. The schedule simply needs to track which route is being flown (see the previous section on Airline Flight Routes) on which date and what are the departure and arrival gates at the origin and destiation airport, respectively. Flight Prices The seats available on each flight can have varying prices, depending on the class of the seat and these prices can vary from day to day. The database must track the ticket price for the following seat categories: first-class; business class; coach class; and economy class. The ticket price is for a specific seat category for a specific flight route id of the airline on a specific date. Ticket prices must be positive monetary amounts (two decimal places). All of this information is required. Passengers The airline is required to keep certain information about passengers who have booked flights with the airline. The database includes the last name, first name, middle initial, the street address, the city, the state, the zip code, and the phone numbers of the of the passenger and the passengers' email. The required information for the database is the first name, the last name, the street address, the city, the state, the zip code. The the other passenger information is optional. A passenger may give a number of phone numbers or none at all. Flight Bookings The airline must keep information that represents a passenger's booking for one of the airline's flights. The information must show which passenger is booked on a which route on which date and for what price. All of this information is required. Flight Crews The company has to assign crew members (pilots and flight attendants) for each date that one of its routes is flown. For each occurrence of a route being flown on a particular date, the company needs to know which pilots and flight attendants are assigned for that flight on that date. There can be different numbers of crew members assigned, but assume that all flights have cetween two and four pilot crew and four and eight attendant crew.

Relational Database Implementation

In this step, you will implement the table schema developed in step 2, using the Postgres SQL DDL language. Your

deliverable will be a Postgres SQL DDL script which when run in Postgres creates the tables for your case study.

Table Population

In this step, you'll create a data set for your database. Your deliverable will be a Postgres SQL DML script which

when run, inserts your data set into the database tables and also a text document with the data presented in a tabular

format.

Database Operational testing

In this final step, you'll create a Postgres SQL DML script which performs a set of queries on your populated database.

Each case study has a set of sample queries. Choose any ten of these queries and implement them. Your deliverable

will be a Postgres SQL DML script, which when run, performs the queries on your database as well as a text

document with the query results presented in a tabular form. Note, you can capture the query results from the result

window of pgAdminIII.

You have been requested to design a schema (as an E/R diagram) for the contact-tracing database. Your group is busy working to design and field a contact-tracing database to be able to trace rapidly people who may have been in close proximity (contact) to someone diagnosed with a highly infectious disease.

The Contact Tracing Domain

To be able to trace with whom a person has been in contact, we need to know where that person has been and when. We have to know this about everyone else too. Then we could figure out the potential contacts by seeing who was in places at the same time as the person. During an epidemic with a highly infectious disease, by tracing the recent contacts of a person who has become ill, these people can be warned to take appropriate action. This can greatly help to stem the epidemic.

Thus Person is fundamental in our database. We are tracing people, after all. Information we should keep for people is a name, address, and phone#. We can keep sin, a person's social insurance number to identify the person. (Assume that the government will issue anyone in Canada who does not have a sin a temporary sin for this very purpose. Also note that, in building such a database for real, in truth, using sin for this would likely not be a good choice. But, for the project, let us assume it is.)

We should also record Places. This will include public building and other indoor places where people can meet, and thus come into contact. (We assume for now that the disease does not transmit outdoors, so we are not keeping track of all possible locations.) We can use a place's name to identify it, and we want to keep about a place its gps coordinates, address, and a description.

Central to the whole database's operation is to collect “observations” about which places a person has been, and when they were there. Thus, we are designing a mass-surveillance database! But we are assuming that this is for a good cause, and that the database, once up and running, will not be abused for other purposes.

Let us call an observation that such a person was in such a place at such a time a Recon — a shortened form of the military term reconnaissance — to have an easier way to organize our thoughts. A Recon names a Person (who) as being at a Place at a given time (when). Let us employ the notion of Time Slot for handling times. There will be effectively an entry in Time Slot for every fifteen-minute period; e.g., 3:00pm 25 September 2020, 3:15pm 25 September 2020, 3:30pm 25 September 2020, and so forth. For any given time slot in which a person was observed somehow to be at a place, we would have a Recon entry. Thus each Recon is associated with a Time Slot, telling us when the person was there. (A better way to handle time in such a scenario is to work with time intervals. This is significantly more involved design-wise, however. Therefore, for our first cut of a schema for our contact-tracing database — that is, this project — let us employ Time Slot to handle the “when” aspect.) In fact, we can use when to identify any given Time Slot. (Say we assume the when value identifies the beginning of the time slot; e.g., 3:00pm stands for 3:00pm up to 3:15pm.)

A Recon then identifies — and therefore, is identified, at least in part, by — the person, the place, and the time slot (when), which is “saying” that Person (who) was at Place during this Time-slot time (when). For any Recon, we also must record the Method, the way, that we know that the person was at the place at that time. Examples of methods might be, for example, contact-tracing phone app, surveillance camera with facial recognition, and a registry entry (the person had to sign a registry book on entering and exiting the building). Note that there could be more than one recons telling us a person was at a place at a given time, each recon supported by different evidence (Method).

In our database, we also need to track when a person is tested, a Test, for the disease. Such a diagnosis Test is administered to a given Person at (“upon”) a given time (Time Slot). This information identifies any given Test. A Test is administered in a Test Centre — which is a Place — and is of a given Test Type. (There are different types of test for the disease, which may differ in efficacy and cost.) Thus, we want to record where the Test was administered, and what type of test it was.

A Test may result in an Action. Let Action be identified by an action name. (An action might be taken given the result of the test; for instance, if it came back positive for the disease, the person might be placed in quarantine.) Assume that a given Test results in at most one Action. Of course, a Test might not result in any action. (Say, the test came back negative and no action was necessary.) We want to track actions resulting from tests.

Not all Test Centres are equipped to administer all types of test (Test Types). Thus, we want to record which Test Types are offered at which Test Centres. A Test Centre may offer different types of test; and a type of test may be available at a number of test centres.

Lastly, the Government is to require that each Person identifies their bubble; that is family and friends — other people (Persons) — with whom they are regularly in contact. We need to record this “bubble” information in the database.

What is the expected output from the following program (3 answers)

______­­ ______namespace std; double insurance(int); void main() { int j; ______ mileage; ______ monthly_rent; for (j=______ j<4; j++) { mileage=1000*j; monthly_rent= 0.3*mileage + insurance(mileage); printf("Monthly rent for %4d.2f is : $ ______ . \n", mileage, monthly_rent); } } double insurance(int miles) { double mileage_charge; if (miles<=1000) { mileage_charge=100.0; }___ if ((miles>1000) && (miles<=2000)) { mileage_charge=150.0; }; ___ (miles>2000) { mileage_charge=200.0; }; return(mileage_charge);

sara is married and loved all year with her husband and two children. she will filt married filling separately and claim her two children as dependants. her son Glen, born may 1 2010 and her daughter, rona, born December 25 2000 are birth us citizens and did not provide any of their own support. Sara's wages were 40000 and she had no other income. her tax is 2155. Sara's child tax credit is:
a) 2155
b) 2000
c) 0
d) 1000

Consider the following production possibilities schedule for two goods- Tshirts and running shoes:

A) Suppose that this economy is currently producing 1000 running shoes per month (on its ppf). At this allocation what is the opportunity cost of producing 2000 more tshirts. Show the calculaitons

B) What are some differences between a PPF that is curved outward and one that is a straight line? Explain.

Given the following information what is the percentage change in the price of the bonds if interest rates suddenly rise by 3%?

Examine the fiscal policies in place at the start of your specific time period of 2000-2010 in relation to their effects on macroeconomic issues. For instance, consider level of government spending, taxation, subsidies, unemployment benefits, and so on.   

Analyze new fiscal policy actions undertaken by the U.S. government throughout the time period during 2000-2010 by describing their intended effects, using macroeconomic principles to explain the actions.  

Explain the impact of the new fiscal policy actions on individuals and businesses within the economy by integrating the macroeconomic data and principles.

Consider the utility function U(W) = W^0.5 where W = wealth

a) Perform the necessary calculations to demonstrate the order of preference of an investor with this utility function. Order them from most preferred to least preferred.

-Prospect 1: 50% chance of $1000, 50% chance of $2000

-Prospect 2: 25% chance of $500, 25% chance of $2000, 50% chance of $1000

-Prospect 3: $1000 for certain.

b) Explain the meaning of the expression certainty equivalent. (That is, Provide the definition)

c) Calculate the certainty equivalent of prospect 1.