Computer and Information Networking

 Discussion: 3 pages

1:  Is architectural design a must or just one of the choices for developing and design software system? Does architectural design need to follow standard developing steps or procedures? Is there any flexibility needed? 

2.  What is Hadoop (Explaining Hadoop) ? 

3. What is HDFS? 

4. What is YARN (Yet Another Resource Negotiator)? 

5. For transaction, there are 4 properties, please address those properties.

6. For concurrent control, please describe the required reason of use concurrent control and how to implement concurrent control?

7. If there is Conflict Serializability issue, how to handle it?

8. For database management systems, there are a lot of different design such as Centralized databaseDistributed databasePersonal databaseEnd-user databaseCommercial databaseNoSQL databaseOperational databaseRelational databaseCloud databaseObject-oriented databaseGraph oriented database, and etc. 

Are there any relations between different systems? How to integrate multi-different systems?

 

Exp22_Excel_Ch09_Cumulative_Theatre

#Exp22_Excel_Ch09_Cumulative_Theatre 

#Exp22 Excel Ch09 Cumulative Theatre 

#Excel Chapter 9 Cumulative – Sugarhouse District Theatre 

  

Project Description:

You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook.

     

Start Excel. Download and open   the file named Exp22_Excel_Ch09_Cum_Theatre.xlsx.   Grader has automatically added your last name to the beginning of the   filename.
 

  Note: When you open the file, Excel prompts you to fix a circular error.   Click or press OK and continue.

 

The first column in the Template   worksheet contains cells with a different font color and levels of   indentation. You want to fill this formatting across the Friday, Saturday,   and Sunday worksheets.
 

  Group the Template, Friday, Saturday, and Sunday worksheets. Fill the   formatting for the range A5:A20.

 

You notice that a formula is   missing on worksheets. You will insert the formula simultaneously.
 

  With the worksheets still grouped, in cell E20, enter a formula to subtract   the Grand Total Percentage Sold from 1. Apply Bold to the cell.

 

The range I4:J7 displays the   average number of seats sold in each section. However, two results display   #DIV/0! because the template does not contain sample values in some sections.   You will edit the formula to avoid the error.
 

  With the worksheets still grouped, edit cell J5 by enclosing the AVERAGEIF   function within an IFERROR function. The value_if_error argument should   display the text Missing data. Copy the function to the range J6:J7. Fill   Without Formatting to preserve the borders.

 

Hide the Template worksheet.

 

The Totals worksheet contains   summary data. You will insert a hyperlink to the number of seats sold in each   respective worksheet.
 

  On the Totals worksheet, in cell A5, insert a hyperlink to cell C20 in the   Friday worksheet with the ScreenTip text Friday Seats Sold. In cell A6, insert a hyperlink   to cell C20 in the Saturday worksheet with the ScreenTip text Saturday   Seats Sold. In   cell A7, insert a hyperlink to cell C20 in the Sunday worksheet with the   ScreenTip text Sunday Seats Sold. Test the hyperlinks to ensure the work correctly.

 

Now you are ready to insert a   formula with a reference to the number of seats sold for Friday’s   performance.
 

  In cell B5, insert a formula with a 3-D reference to cell C20 in the Friday   worksheet.

 

Now you are ready to insert a   formula with a reference to the number of seats sold for Saturday’s   performance.
 

  In cell B6, insert a formula with a 3-D reference to cell C20 in the Saturday   worksheet.

 

Now you are ready to insert a   formula with a reference to the number of seats sold for Sunday’s   performance.
 

  In cell B7, insert a formula with a 3-D reference to cell C20 in the Sunday   worksheet.

 

The next section of the Totals   worksheet is designed to display total gross revenue by section.
 

  In cell B11, insert the SUM function with a 3-D reference to calculate the   total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and   Sunday worksheets.

 

You are ready to insert a   function to calculate the total Orchestra Back gross revenue.
 

  In cell B12, insert the SUM function with a 3-D reference to calculate the   total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and   Sunday worksheets.

 

You are ready to insert a   function to calculate the total gross revenue for the Balcony.
 

  In cell B13, insert the SUM function with a 3-D reference to calculate the   total Balcony gross revenue (cell G19) for the Friday, Saturday, and Sunday   worksheets.

 

The worksheet contains a   circular error. Now you want to find and correct it.
 

  On the Totals worksheet, check for errors and correct the formula with the   circular reference.

 

Although the Totals worksheet   contains specified aggregated data, such as the number of seats sold and   gross revenue by section, you want to create another summary that   consolidates data from the three daily worksheets. In the Details worksheet,   you will list the detailed section seating and gross revenue by day for those   seating sections.
 

  In the Details worksheet, in cell A2, use the Consolidate tool to select and   add the range I10:J19 in the Friday, Saturday, and Sunday worksheets. Use the   top row and left column labels when consolidating data.

 

Now you want to format the   consolidated data.
 

  Select the range B2:D2. Apply bold and center horizontal alignment.

 

The third section of the Totals   worksheet needs to link to a value in another workbook.
 

  Open the Exp22_Excel_Ch09_Cum_TheatreVenue.xlsx   workbook. Go back to the Exp22_Excel_Ch09_Cum_Theatre.xlsx   workbook. In cell B17 on the Totals worksheet, insert a link to the Weekend   Evening value (cell C5) in the TheatreVenue workbook. Close the TheatreVenue   workbook.

 

In cell B19 in the Totals   worksheet, multiply the Weekend Evening Fee by the No. of Evening   Performances.

 

You want to create a validation   rule to prevent the user from entering too many seats sold. For now, you will   create a validation for just one input cell.
 

  Select the range C6:C8 in the Friday worksheet, create a validation rule to   allow whole numbers less than or equal to =B6. Enter the input message title Seats Sold and the input message Enter the   number of seats sold.   (including the period). Use the Stop alert with the error alert title Invalid   Number and the   error alert message The number of seats sold cannot exceed the total seats   in the section.   (including the period). Test the data validation by attempting to enter 360 in cell C7 and then cancel the   change. Copy the range C6:C8 in the Friday worksheet. Select the range   C11:C13. Use the Paste Special Validation to copy the validation settings.   Select the range C16:C18 and paste the validation again.

 

You want to unlock data-entry   cells so that the user can change the number of seats sold in the worksheets.   
 

  Group the Friday, Saturday, and Sunday worksheets. Select the ranges C6:C8,   C11:C13, and C16:C18 and unlock these cells.

 

Now that you unlocked data-entry   cells, you are ready to protect the worksheets to prevent users from changing   data in other cells.
 

  Individually, protect the Friday, Saturday, and Sunday worksheets using the   default allowances with the password Expl0r!ng.

 

Mark the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

 

Save and close Exp22_Excel_Ch09_Cum_Theatre.xlsx.   Exit Excel. Submit the file as directed.

electronic innovation and the government

Complete  a review of the article by writing a 3 page overview of the  article. This will be a detailed summary of the journal article,  including concepts discussed and findings. Additionally, find one other  source (it does not have to be a peer-reviewed journal article) that  substantiates the findings in the article you are reviewing.

Paper 1:

https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.614.7867&rep=rep1&type=pdf

Paper 2:

Use the attached pdf

Be approximately 5 – 6 pages in length, not including the required cover page and reference page.

Follow APA 7 guidelines

Discussion 1

 The topic I have selected is a  DoS occurred in 2020 to Amazon Web Services

Introduction to Risk

Individuals, businesses and governments face risk daily. Risk is manifested in different forms and may be described as business, non-business, or financial. Irrespective of the type of risk, it’s important to remember the basic goals of security – to maintain confidentiality and integrity, while also ensuring the availability of data and systems. Organizations and governments usually employ different approaches to mitigating risks, but with a good understanding and consideration for risk elements including (i) vulnerabilities, (ii) threats & threat agents, (iii) impact, and (iv) likelihood. Other considerations include an organization or government’s appetite for risk, business goals, as well as internal and external drivers (laws, regulations, and standards). Proven strategies to deal with risk employ an enterprise risk management approach, and also rely on risk management frameworks including but not limited to: NIST’s risk management framework, ISACA’s risk IT framework, and COBIT 2019.

Overview

Follow these directions to complete the assignment:Identify a cybersecurity-related attack:Using scholarly sources and/or the web, research, identify, and share an example of a cybersecurity-related attack. Examples may include cyber warfare such as “Stuxnet” or the “Equifax” data breach. Feel free to use any of these. Once you’ve decided on the example you will share, “claim” it by posting it to the discussion. Do not post about the same type of attack as your classmates.Create your post:In a discussion post of approximately 600 to 800 words, explain risk and risk elements related to this attack, including a synopsis, attack type, characteristics, vulnerabilities, threats & threat agents, impact, and likelihood of this attack. You may need to make some assumptions as you write about the risk elements. Clearly state any assumptions that you make. Do not offer a potential solution to the attack; 

Action Items

  1. Complete all of the reading for this module.
  2. Claim the cybersecurity-related attack you intend to discuss by posting it to the discussion.
  3. Create your discussion post according to the directions in the overview.

Question

Please answer below questions(plagiarism applies)

  1. Discuss each of the following terms:
    1. data
    2. field
    3. record
    4. file
  2. What is data redundancy?
  3. Discuss the disadvantages of file-based systems.
  4. Explain the difference between data and information.
  5. Use Figure 1.2 (below attachment) to answer the following questions.
    1. In the table, how many records does the file contain?
    2. How many fields are there per record?
    3. What problem would you encounter if you wanted to produce a listing by city?
    4. How would you solve this problem by altering the file structure?