Instructions

Several data files are also present: Patients.txt, Diagnoses.txt, Labs.txt, and Admissions.txt.

Please note that each data file has a columns descriptor line as the first line of the file.  When processing, we must IGNORE that line as it is obviously not valid data. The following code preceding the actual loop that reads the file does just that. Each time you read a file containing that header line you must include this code.

fhand = open('Diagnoses.txt')    # open the file, establish the file handle



fhand.readline()                 # read the first line and ignore it

# declare and set any initialization variables here, such as counters, lists, dictionaries

for line in fhand:         # loop through the file line by line 

Part A

What patient (by ID) has the most admissions? 

1. Open Hwk12a_STARTER.py, rename it, and run it. It should display the ID field from all the lines in the file Admissions.txt. Comments included therein guide your code development.

2. Run and study the code in Ch 9 code sample 13. It provides most of what you need for this task. (PLEASE ATTACHED FILE PART A.JPG FOR CODE SAMPLE)

Part B 

What are the 10 patients (by ID) having the most labs? 

1. To tackle this task, repeat the code you wrote in 12a to create a dictionary containing IDs and the count of those IDs, this time on the Labs.txt file.

2. Then employ the strategies used in Ch 10 code sample 10 (ten most common words) to create a list of tuples, sort the list, and then print the first ten.

Part C 

Of the top 10 patients with the most labs, how many are male? Print their IDs and print the number of males in the top 10.

1. Repeat the code you wrote in 12b to create a dictionary containing IDs and the count of those IDs, create the list, and sort the list in reverse.

2. Now you have to find out which of the top 10 in the list of most Labs are male. To do that, you have to loop through the Patients.txt file, checking to see if the ID is present in the same line as the word ‘Male’.

3. Follow the comments in the code to add the statements necessary to achieve the tasks. Don’t be afraid to add print statements to help you write the code; remove them when you’re finished. The output is shown below.

Topic: Internet of Things

Outline for Presentation

• Define your topic and its associated ethical dilemma (ethical values or principles)
• Identify the facts: Stake holders, activity, actions, laws (or lack of)
• Briefly outline two or three options / solutions and their consequences (intended and unintended) 
• Thoughtful discussion questions or prompts to engage the class to discuss the conflict or dilemma 
• What did you find surprising about this issue or the class discussion???
• Last word:  Your opinion and justification…any changes from discussion input.

I want you to identify the paper that was the best one of the semesters, and

the paper that was the worst one of all these papers below. You should name

each of them, and provide just a couple of sentences describing why you

choose them. Then use the scholarly search tools we listed early in the

semester to find current papers (2020 onward) on the same two general

topics. For example, if one of your choices is the paper that focused on

Multics virtual memory, you probably wouldn’t find much that is current and

specifically references Multics, but you could certainly find papers on some

aspect of virtual memory. So again, find a current paper on each of those two

topics. Then write the usual summary and reaction for each of them with the

headings. (Note: don’t forget which papers you chose for best and worst.)

Paper 1: Read this paper: Peter Chen, Edward Lee, Garth Gibson, Randy Katz,

and David Patterson, "RAID: High-Performance, Reliable Secondary Storage",

ACM Computing Surveys, volume 26, number 2, June 1994. 

Paper 2: Mendel Rosenblum and John Ousterhout, "The Design and

Implementation of a Log Structured File System", Proceedings of the

Symposium on Operating Systems Principles, 1991.

Paper 3: John Howard, Michael Kazarm Sherri Menees, David Nichols, M.

Satyanarayanan, Robert Sidebotham, and Michael West, "Scale and

Performance in a Distributed File System", ACM Transactions on Computer

Systems, Volume 6, Number 1, February 1988. 

Paper 4: The paper is A. Bensoussan and R. Daley, "The Multics Virtual Memory:

Concepts and Design", Proceedings of the Symposium on Operating Systems

Principles, 1969."

Paper 5: Peter Denning, "The Working Set Model for Program Behavior",

Communications of the ACM, 1968.

Paper 6: Richard Carr and John Hennessy, "WSClock — A Simple and Effective

Algorithm for Virtual Memory Management", Proceedings of the Symposium on

Operating Systems Principles, 1981.

Paper 7: Judy Kay and Piers Lauder, A fair share scheduler, Communications of

the ACM 31.1, 1988

Paper 8: Carl Waldspurger and Weihl William, Lottery scheduling: Flexible

proportional-share resource management,  In Proceedings of the 1st USENIX

conference on Operating Systems Design and Implementation,  1994

Paper 9: Dabek, Frank, et al. "Event-driven programming for robust software."

Proceedings of the 10th workshop on ACM SIGOPS European workshop. 2002.

Paper 10: Rob von Behren, Jeremy Condit, and Eric Brewer, Why Events Are A

Bad Idea (for high-concurrency servers), Workshop on Hot Topics in Operating

Systems, 2003.

Discussion: Research a Recent Data Breach Involving Databases

Instructions:

In this module, we discussed how important security is when it comes to databases. As an effective database professional, you’ll need to ensure the systems and solutions you design and use are properly secured from accidental or intentional misuse. Many databases contain sensitive information, such as PII (Personally Identifiable Information, like your birth date), PHI (Personal Health Information, such as your medical history or current prescriptions), and PCI (Payment Card Information, such as your bank or credit card details). Then there are the thousands upon thousands of other data points captured about you and the world (physical and virtual) around you. All of this information is under attack – by malicious hackers seeking to profit, competitors looking for the “Next Big Thing”, or just bored kids who have nothing better to do. 

In your duties, you’ll be managing and acting as a “Data Custodian.” By understanding how impactful a database breach can be, use the internet to research data breaches from the past 5 years. Focus on breaches where

• Data was stored in a database, S3 bucket, or other online repository,
• Data was the primary focus of the attack
• Where that attack caused serious business or financial harm

In general, your post should include: key characteristics or facts about the attack, type of data impacted, business or financial impact. Include any lessons learned or relevant personal experiences. 

The post should be roughly 3-4 paragraphs and be roughly 300-400 words long. 

You MUST cite resources in APA format.