Search the Internet and locate an article that relates to the topic of HACKING and summarize the reading in your own words. Your summary should be 2-3 paragraphs in length and uploaded as a TEXT DOCUMENT. Click the link above to submit your work. There is an EXAMPLE attached to show you the format requirements.

In a 500- to 750-word document, address the following:

1. Explain the phases and function of the query optimizer.
2. Identify the tools to edit query optimizer strategies.
3. Explain how performance of a database system is measured.
4. Differentiate between response time and throughput.
5. Explain how the physical design of a database influences performance tuning.
6. Explain three ways queries can be altered to increase database performance.
7. Present specific examples to illustrate how implementing each query alteration could optimize the database.

Locate an article on a system breach (Target stores, Sony Pictures, US Government, and many more).In 2-3 paragraphs, briefly explain the situation and what kind of information was compromised. How large was the breach and how long did it take to find the problem. Include a link to any of your Internet resources.

 There are 4 parts for the project. The question may be long to read but it’s not a heavy work because there are many examples and explanations for the each parts.*Part 1.  The first part of this project requires that you implement a class that will be used to simulate a disk drive. The disk drive will have numberofblocks many blocks where each block has blocksize many bytes. The interface for the class Sdisk should include :

Class Sdisk

{

public :



Sdisk(string diskname, int numberofblocks, int blocksize);

int getblock(int blocknumber, string& buffer);

int putblock(int blocknumber, string buffer);

int getnumberofblocks(); // accessor function

int getblocksize(); // accessor function



private :



string diskname;        // file name of software-disk

int numberofblocks;     // number of blocks on disk

int blocksize;          // block size in bytes

};

An explanation of the member functions follows :

• Sdisk(diskname, numberofblocks, blocksize) This constructor incorporates the creation of the disk with the “formatting” of the device. It accepts the integer values numberofblocks, blocksize, a string diskname and creates a Sdisk (software-disk). The Sdisk is a file of characters which we will manipulate as a raw hard disk drive. The function will check if the file diskname exists. If the file exists, it is opened and treated as a Sdisk with numberofblocks many blocks of size blocksize. If the file does not exist, the function will create a file called diskname which contains numberofblocks*blocksize many characters. This file is logically divided up into numberofblocks many blocks where each block has blocksize many characters. The text file will have the following structure :  

                                                            -figure 0 (what I attached below)              

• getblock(blocknumber,buffer) retrieves block blocknumber from the disk and stores the data in the string buffer. It returns an error code of 1 if successful and 0 otherwise.
• putblock(blocknumber,buffer) writes the string buffer to block blocknumber. It returns an error code of 1 if successful and 0 otherwise.

IMPLEMENTATION GUIDELINES : It is essential that your software satisfies the specifications. These will be the only functions (in your system) which physically access the Sdisk. NOTE that you must also write drivers to test and demonstrate your program.*Part 2.  The second part of this project requires that you implement a simple file system. In particular, you are going to write the software which which will handle dynamic file management. This part of the project will require you to implement the class Filesys along with member functions. In the description below, FAT refers to the File Allocation Table and ROOT refers to the Root Directory. The interface for the class should include :

Class Filesys: public Sdisk

{

Public :

Filesys(string diskname, int numberofblocks, int blocksize);

int fsclose();

int fssynch();

int newfile(string file);

int rmfile(string file);

int getfirstblock(string file);

int addblock(string file, string block);

int delblock(string file, int blocknumber);

int readblock(string file, int blocknumber, string& buffer);

int writeblock(string file, int blocknumber, string buffer);

int nextblock(string file, int blocknumber);





Private :



int rootsize;           // maximum number of entries in ROOT

int fatsize;            // number of blocks occupied by FAT

vector filename;   // filenames in ROOT

vector firstblock; // firstblocks in ROOT

vector fat;             // FAT

};

An explanation of the member functions follows :

• Filesys() This constructor reads from the sdisk and either opens the existing file system on the disk or creates one for an empty disk. Recall the sdisk is a file of characters which we will manipulate as a raw hard disk drive. This file is logically divided up into number_of_blocks many blocks where each block has block_size many characters. Information is first read from block 1 to determine if an existing file system is on the disk. If a filesystem exists, it is opened and made available. Otherwise, the file system is created.The module creates a file system on the sdisk by creating an intial FAT and ROOT. A file system on the disk will have the following segments:                                                           -figure 1 (what I attached below)           
• consists of two primary data objects. The directory is a file that consists of information about files and sub-directories. The root directory contains a list of file (and directory) names along with a block number of the first block in the file (or directory). (Of course, other information about the file such as creation date, ownership, permissions, etc. may also be maintained.) ROOT (root directory) for the above example may look something like                                                   -figure 2 (what I attached below)  The FAT is an array of block numbers indexed one entry for every block. Every file in the file system is made up of blocks, and the component blocks are maintained as linked lists within the FAT. FAT[0], the entry for the first block of the FAT, is used as a pointer to the first free (unused) block in the file system. Consider the following FAT for a file system with 16 blocks.  

                                                        -figure 3 (what I attached below)

• In the example above, the FAT has 3 files. The free list of blocks begins at entry 0 and consists of blocks 6, 8, 13, 14, 15. Block 0 on the disk contains the root directory and is used in the FAT for the free list. Block 1 and Block 2 on the disk contains the FAT. File 1 contains blocks 3, 4 and 5; File 2 contains blocks 7 and 9; File 3 contains blocks 10, 11, and 12. Note that a “0” denotes the end-of-file or “last block”. PROBLEM : What should the value of FAT_size be in terms of blocks if a file system is to be created on the disk? Assume that we use a decimal numbering system where every digit requires one byte of information and is in the set [0..9]. Both FAT and ROOT are stored in memory AND on the disk. Any changes made to either structure in memory must also be immediately written to the disk.  
• fssynch This module writes FAT and ROOT to the sdisk. It should be used every time FAT and ROOT are modified.
• fsclose This module writes FAT and ROOT to the sdisk (closing the sdisk).
• newfile(file) This function adds an entry for the string file in ROOT with an initial first block of 0 (empty). It returns error codes of 1 if successful and 0 otherwise (no room or file already exists).
• rmfile(file) This function removes the entry file from ROOT if the file is empty (first block is 0). It returns error codes of 1 if successful and 0 otherwise (not empty or file does not exist).
• getfirstblock(file) This function returns the block number of the first block in file. It returns the error code of 0 if the file does not exist.
• addblock(file,buffer) This function adds a block of data stored in the string buffer to the end of file F and returns the block number. It returns error code 0 if the file does not exist, and returns -1 if there are no available blocks (file system is full!).
• delblock(file,blocknumber) The function removes block numbered blocknumber from file and returns an error code of 1 if successful and 0 otherwise.
• readblock(file,blocknumber,buffer) gets block numbered blocknumber from file and stores the data in the string buffer. It returns an error code of 1 if successful and 0 otherwise.
• writeblock(file,blocknumber,buffer) writes the buffer to the block numbered blocknumber in file. It returns an appropriate error code.
• nextblock(file,blocknumber) returns the number of the block that follows blocknumber in file. It will return 0 if blocknumber is the last block and -1 if some other error has occurred (such as file is not in the root directory, or blocknumber is not a block in file.)IMPLEMENTATION GUIDELINES : It is essential that your software satisfies the specifications. These will be the only functions (in your system) which physically access the sdisk.

*Part 3.   The third part of this project requires that you implement a simple shell that uses your file system. This part of the project will require you to implement the class Shell along with member functions. The interface for the class should include :

class Shell: public Filesys

{

Public :



Shell(string filename, int blocksize, int numberofblocks);

int dir();// lists all files

int add(string file);// add a new file using input from the keyboard

int del(string file);// deletes the file

int type(string file);//lists the contents of file

int copy(string file1, string file2);//copies file1 to file2

};

An explanation of the member functions follows :

• Shell(string filename, int blocksize, int numberofblocks): This will create a shell object using the Filesys on the file filename.
• int dir(): This will list all the files in the root directory.
• int add(string file): add a new file using input from the keyboard
• int del(string file): deletes the file
• int type(string file): lists the contents of file
• int copy(string file1, string file2): copies file1 to file2

IMPLEMENTATION GUIDELINES :See the figure 4  (what I attached below) for the ls function of Filesys.See the figure 5 (what I attached below) for dir function of Shell. See the figure 6 (what I attached below)  for main program of Shell.*Part 4.  In this part of the project, you are going to create a database system with a single table which uses the file system from Project II. The input file will consist of records associated with Art History. The data file you will use as input consists of records with the following format: The data (180 records) is in date.txt file (what I attached below)

• Date : 5 bytes
• End : 5 bytes
• Type : 8 bytes
• Place : 15 bytes
• Reference : 7 bytes
• Description : variable

In the data file, an asterisk is also used to delimit each field and the last character of each record is an asterisk. The width of any record is never greater than 120 bytes. Therefore you can block the data accordingly. This part of the project will require you to implement the following class:

Class Table : Public Filesys

{

Public :



Table(string diskname,int blocksize,int numberofblocks, string flatfile, string indexfile);



int Build_Table(string input_file);

int Search(string value);



Private :



string flatfile;

string indexfile;



int IndexSearch(string value);

};

The member functions are specified as follows :

• Table(diskname,blocksize,numberofblocks,flatfile,indexfile) This constructor creates the table object. It creates the new (empty) files flatfile and indexfile in the file system on the Sdisk using diskname.
• Build_Table(input_file) This module will read records from the input file (the raw data file described above), add the records to the flatfile and create index records consisting of the date and block number, and then add the index records to the index file. (Note that index records will have 10 bytes .. 5 bytes for the date and 5 bytes for the block number.)
• Search(value) This module accepts a key value, and searches the index file with a call to IndexSearch for the record where the date matches the specified value. IndexSearch returns the blocknumber of the block in the flat file where the target record is located. This block should then be read and the record displayed.
• IndexSearch(value) This module accepts a key value, and searches the index file indexfile for the record where the date matches the specified value. IndexSearch then returns the block number key of the index record where the match occurs.

See the figure 7 (what I attached below) for the main program of Shell which includes a search command. 

1. For this discussion topic, you will need to research storage virtualization and its benefits. Your initial post should focus on what benefits exist from virtualizing the storage attached to the hypervisor.  

2. or this discussion topic, you will need to research network virtualization and examine the resources you find carefully. While most of the information you find will be targeted at the reasons to virtualize networks, you need to determine what pitfalls exist. Summarize your findings in your initial post.  

3. For this discussion topic, you are expected to do research and post your findings on the pros and cons of implementing and using a virtual desktop infrastructure. 

4. In IT, sometimes a large part of the battle when developing a solution to a problem is knowing what options exist.  For this assignment, you will research what companies offer network virtualization products and how their products differ with the goal of writing up a summary of what options exist.  You should include in your summary if any of these solutions come from existing network hardware companies.   

5. For this assignment do research on either VMware Horizon or Microsoft Remote Desktop Services and complete a plan to implement a virtual desktop infrastructure based on up on the business details provided.  You plan should include details as to how many of what types of servers would be needed, how many and what types of virtual desktops would be needed and any other considerations you might encounter.  

6. For this assignment you will research the common client hardware and software that is used by end users to access virtual desktop environments.   You should explore each of the client connection methods in detail list both pros and cons for each connection method or device.  You need to have a minimum of 3 different devices or connection types discussed in your paper.  

See attached pictures to answer all questions 

Work has to be shown in a Word Doc

writing an algorithm first, and finish the program

This week’s discussion has introduced working with geometric objects and transformations, particularly with respect to scalars, points, and vectors. In this assignment, briefly discuss a convex hull.

Instructions

Explain and provide example when it is possible that will cover chapter 4 subjects:

Data Link Layer–

Media Access Control•

Controlled Access•                         Contention Access–                  ErrorControl•                                Prevention•                                     Detection•                                     Correction–                                      Protocols•                                            Async•                                                   SDLC•                                                Ethernet•                                                 PPP–Transmission Efficiency and Throughput

Additionals resources

https://www.csus.edu/indiv/m/millerd/Ch4%20Ed7%20Notes.ppt

Shelly      Cashman Excel 2019 | Modules 1-3: SAM Capstone Project 1a

                    Ensight Healthcare Consultants

CREATE FORMULAS WITH FUNCTIONS 

GETTING STARTED

· Open the file SC_EX19_CS1-3a_FirstLastName_1.xlsx, available for download from the SAM website.

· Save the file as SC_EX19_CS1-3a_FirstLastName_2.xlsx by changing the “1” to a “2”.

o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

· With the file SC_EX19_CS1-3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.
 

Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.

2. In cell J1, enter a formula using the NOW function to display today’s date. Apply the Short Date number format to display only the date in the cell.

3. Format the worksheet title as follows to use a consistent design throughout the workbook:

a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color.

b. Change the font color to White, Background 1.

c. Merge and center the contents of cell B2 across the range B2:H2.

d. Use AutoFit to resize row 2 to its best fit.

4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand:

a. Italicize the contents of cell I2 to match the formatting in cell I1.

b. Apply the Currency number format to cell J2 to clarify that it contains a dollar amount. 

5. Format the data in cell A4 as follows to display all of the text:

a. Merge the cells in the range A4:A13.

b. Rotate the text up in the merged cell so that the text reads from bottom to top.

c. Middle-align and center the text.

d. Remove the border from the merged cell.

e. Resize column A to a width of 4.00.

6. Format the data in row 4 as follows to show that it contains column headings:

a. Change “Description” to use Service Description as the complete column heading.

b. Apply the Accent 6 cell style to the range B4:H4.

c. Use AutoFit to resize column D to its best fit.

7. Carla wants to include the actual dollar amount of the services performed in column E. Enter this information as follows:

a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell J2 in the formula.

b. Use the Fill Handle to fill the range E6:E13 with the formula in cell E5 to include the charges for the other services.

c. Format the range E6:E13 using the Comma number format and no decimal places to match the formatting in column F.

8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows:

a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.

b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.

c. Format the range G6:G13 using the Comma number format and no decimal places to match the formatting in column F.

9. Carla also wants to show the remaining amount as a percentage of the actual amount. Enter this information as follows:

a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5).

b. Copy the formula in cell H5 to the range H6:H14, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total.

10. Calculate the project status totals as follows:

a. In cell D14, enter a formula using the SUM function to total the actual hours (range D5:D13).

b. Use the Fill Handle to fill the range E14:G14 with the formula in cell D14.

c. Apply the Accounting number format with no decimal places to the range E14:G14.

11. Carla also wants to identify the services for which Ensight has billed more than the full estimate amount.
 

In the range H5:H13, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text. 

12. Carla imported data about the consultants working on the Everett Hospital project and stored the data on a separate worksheet, but wants to include the data in the Project Status worksheet.
 

Copy and paste the data as follows:

a. Go to the Consultants worksheet and copy the data in the range B2:G12.

b. Return to the Project Status worksheet. Paste the data in cell J3, keeping the source formatting when you paste it.

13. Carla needs to list the role for each consultant. Those with four or more years of experience take the Lead role. Otherwise, they take the Associate role. List this information as follows:

a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4.

b. If the consultant has four or more years of experience, display “Lead” in cell N5.

c. If the consultant has less than four years of experience, display “Associate” in cell N5.

d. Copy the formula in cell N5 to the range N6:N13, pasting the formula only.

e. Use AutoFit to resize column N to its best fit.

14. Carla wants to include summary statistics about the project and the consultants. Include this information as follows:
In cell D16, enter a formula that uses the AVERAGE function to average the number of years of experience (range M5:M13).

15. Make the 3-D Clustered Column chart in the range B17:H31 easier to interpret as follows:

a. Change the chart type to a Clustered Bar chart.

b. Use Actual Project Hours as the chart title.

c. Add a primary horizontal axis title to the chart, using Hours as the axis title text.

d. Add data labels in the center of each bar.

16. Delete row 33 since Carla has reformatted the clustered column chart.

17. Go to the Schedule worksheet. Rename the Schedule worksheet tab to Project Schedule to use a more descriptive name.

18. Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows:

a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell C6.

b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6.

c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6.

d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.

19. Copy the formulas in Phase 2 to the rest of the schedule as follows:

a. Copy the formula in cell D6 to the range D7:D9.

b. Copy the formula in cell E6 to the range E7:E9.

c. Copy the formula in cell F6 to the range F7:F9.

d. Copy the formula in cell G6 to the range G7:G9.

20. In cell C11, enter a formula that uses the MIN function to find the earliest date in the project schedule (range C6:G9).

21. In cell C12, enter a formula that uses the MAX function to find the latest date in the project schedule (range C6:G9).

Your workbook should look like the Final Figures on the following pages. The value in cell J1 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. 

Final Figure 1: Project Status Worksheet

Final Figure 2: Project Schedule Worksheet