Write a narrative description highlighting the demographic changes seen in the Cumberland community in Illinois to explain the complete Data Template below for the general public. ? Demographics: Include the total number and percent of each in the Data Template below to gather data for both the county, state, and national data from both the 2000 and 2010 Census to show how the county has changed from the last Census as well as how it compares to the demographics of the state and the nation. The data template MUST be included as an appendix in your paper. ? Total Population (include the percent change in population from the 2000 to the 2010 Census) ? Age Distribution (use other similar parameters if unable to find the exact same in your research) ? Under 1 Year ? 1 to 5 Years ? 6 to 13 Years ? 14 to 17 Years ? 18 to 24 Years ? 25 to 49 Years ? 50 to 64 Years ? 65 to 84 Years ? 85 Years and Older ? Females 15 – 44 Years ? Gender ? Median Age ? Racial & Ethnic Composition ? Hispanic ? White (Non-Hispanic) ? Black ? Asian/Pacific Islander ? Socioeconomic Status (include total number and percentage of each) ? Median Household Income ? Persons Below 100% of Poverty Level ? Persons Below 200% of Poverty Level ? Households with Social Security Income ? Households with Public Assistance Income ? Unemployed Persons 16 Years & Older ? High School Graduates 25 Years & Older ? College Graduates 25 Years & Older.

Community Description Data Template

On March 15, 2018, Bank of America issued 94,000 shares of 5.875% Fixed-to-Floating Rate Non-Cumulative Preferred Stock, Series FF for $2.35 billion. Dividends are payable semiannually on or about March 15 and September 15.

a. Assume the stock was issued at face value. What is the face value of each Series FF share?

b. What will be the total dividend for the year ended December 31, 2018, assuming that the number of shares remains unchanged?

Draw the MySQL Data Model

Maria’s Pizza – a local pizza shop that provides pizzas for pickup with one location - has hired you to create a database for them to store information about the store and its operations. Prior to building the database, you have decided to present the data model to the client for her approval. Here are the set of requirements that you have for the data model.

The client would like you to track the employees that they have in their store and the shift that is worked by the employees. They need to keep track of personal information about the employee including their name, phone number, address, social security number and other relevant information. This information does change from time to time as employees occasionally move. The store maintains two shifts, mid-day (11 AM – 5 PM) and night (5:00 PM to 11:00 PM). Employees can work across multiple shifts and shifts have multiple employees that work in that period. Shifts also have an employee as a supervisor. Therefore, different employees have different shift supervisors depending on which shift they are working – an employee in one shift may be the shift supervisor in another shift during the week.

Maria’s Pizza would also like this database to tie into their inventory system of food products that they offer. They sell only pizza for pickup, so the ingredients are what they need to keep track of – and all ingredients are tracked by packages of certain ounces (for example flour comes in 400 oz packages, mushrooms come in 64 oz packages, mozzarella cheese comes in 128 oz packages). They need to know the purchase price for each package, and the date of receipt of each shipment, and they update the quantity on hand every night before closing.

Maria’s Pizza has a single food distributor as its main supplier, but will buy a few items like sausage and fresh tomatoes from other local sources. After conducting inventory every night, they send orders if inventory levels get below certain thresholds. They would like to track the reordering of the different products from the suppliers including the date the re-order was placed, the employee that placed the order, and the scheduled delivery date of that order. Products can get re-ordered multiple times and employees can place multiple orders for products. Supplier information is also to be stored in the database including the supplier’s contact information, name and address. Because the same product can get ordered from multiple suppliers, it is important that the reorder contain information about which supplier that re-order was placed with.

Draw a data model for the above scenario.

1. Discuss the current fiscal and monetary policy and its impact on future economy. Provide a meaningful write up of what the current fiscal and monetary policies are and what it means in terms of economic forecast.
2. Organization, citations, grammar and spelling

Include text citations or works cited if you need it.

the empirical rule for 20 gas stations ranging from $2.45 to $2.57 how do you find the mean, variance, deviation, standard deviation, and the empirical rule (gas prices 2.45, 2.46, 2.46,2.46,2.46,2.47,2.47,2.48,2.48,2.48,2.55,2.55,2.56,2.56,2.56,2.56,2.57,2.57,2.57,2.57)

The following financials are presented for Apple, Inc. for the years 2017 and 2018. (All values in USD million)

Required:

1. Determine the operating Cycle and Cash Cycle for the year 2018.
2. Based on the operating cycle and cash cycle determined above, comment on the liquidity position of Apple, Inc.

Reliability is a concept that should be understood in the development of systems. Discuss the difference between series and parallel (redundant) networks and how such networks can increase or decrease total reliability of the system.

Discuss the FMECA process its components, purpose and how it relates to system reliability.

Maintainability and maintenance are important and related to each other. Describe each and the relationship to each other.