Database Management (Data Analysis)

SWTechs has an example worksheet (poorly designed) that contains data about employees, their dependents, and passports. They have over 100 employees, so the worksheet is just an example. After viewing the worksheet one can see that some employees have passports and some do not, and that some have dependents, and others do not. Many employees have multiple dependents, like a spouse and one or more children. The real table they have shows employee data, passport data, and dependent data in three separate worksheet tabs.
For example, to find data about an employee, a clerk uses Excel’s “Find” tool (Ctrl+F) to look for their last name and narrow down to the specific employee. The clerk does the same to find data about an employee’s passport and dependents. If they have no passport or no dependent, then there are all blanks (nulls) in the columns beside their name. If they have dependents, they are listed out across columns.
The clerk must manually update each employee’s age and years with company, each year, and do the same for the ages of all dependents. The clerk must do the same for passport status, determining if the passport is Current or Expired. Dependent data is entered across the columns, and currently
The actual employees, passports, and dependents are irrelevant. They are just included to show an example.
Things to remember;
Every table must have a Primary Key. It is best to assume it will be an Autonumber.
Attributes are either Unique, Single Valued, Multi-Valued, Composite, Derived, or Optional. Primary Keys are always Unique. Single Valued = Pick one from the list (Race, Gender). Multi-Valued = Pick one or more from the list (Certifications, Courses Completed)
Derived attributes require an attribute from which it is derived (Age requires DOB, Total Cost requires Quantity and Price).
ERDs do not show data. People do not belong in an architect’s building blueprint; data does not belong in an ERD. Creating an ERD showing actual data (Region names, Store names, Employee names, Job Titles) means you completely miss the point of an ERD.
For 1:M relationships, the Parent entity is the “1” side, the Child entity is the “M” side.
A Weak entity is a Child entity that cannot logically exist without the Parent Entity. The Weak entity always shares the Parent’s PK. Can a dependent exist without an employee? No, so it is weak. Can a flea exist without a dog? Yes, so it is not weak. Business rules and common sense determine weak entities.
Entities are nouns, where the names are all caps and singular. Attribute names are nouns where the names are singular.
Relationships are BI-DIRECTIONAL and are described with verbs (action words/phrases). EMPLOYEE (noun) Has (verb) DEPENDENT (noun); DEPENDENT (noun) Is Related To (verb) EMPLOYEE (noun).
The business rules and tasks follow.
Business Rules
An Employee can have no, or at most, one Passport, and a Passport is held by one and only one Employee. A Passport Number is unique, but both the Employee ID and Passport Number are unique.
An Employee can no or many Dependents, but a Dependent can be related to one and only one Employee.
Tasks – View the worksheet.
Using the software package ERDPlus
Identify the various entities.
Identify Weak entities (those that can’t exist without the parent tables PK.
Assign a unique attribute (PK) to each entity.
Assign all relevant attributes for each entity from those shown in the worksheet.
In the ERD, show attributes that are composite as such, not broken down into atomic attributes. For example, use (Name) instead of LastName, FirstName, MI
Identify all derived attributes for each entity.
Determine the relationship(s) among entities (parents and children); 1:1, 1:M, M:N
Determine the participation between related entities; mandatory versus optional.
Construct the complete ERD of entities and attributes reflecting primary keys, attributes, as well as relationships and participation.
Specify bi-directional business rules in the relationship diamonds.
Name the ERD SWTechs.
Use the snipping tool to take a screenshot of the ERD and save it only as a .jpg file.
Upload the file to Dropbox.
Grading Rubric
Correct image .jpg extension (I will not try to open and grade other image types)
Correct number of entities
Correct PKs assigned
Correct FK noted
Correct relationships
Correct cardinalities
Strong versus Weak entities

Position Paper on Aristotle (Nichomachean Ethics)

A position paper is your opportunity to grapple with interpretation – arguing what the philosopher means and connections you personally see in the text in response to a specific question – then, applying the interpretation you’ve crafted to the choices of an individual n the midst of atrocity to draw out a lesson for yourself, and
close with your own argument on the same issue. It’s a true position paper in that you’re
arguing for what you see Aristotle, Kant, Arendt or Ricoeur asserting, and then giving your
own position on the same matter or concept.

– Position papers must be submitted to Brightspace on or before the due date. Position
papers must be submitted as Word documents. PDFs and other word-processing
programs are not acceptable

Immigration and Terrorism

You need to include at least 6 peer reviewed sources (textbook, journal articles, research
published on Department of Corrections website) which supports your research.
Your written report will need to be typed in WORD, double-spaced, with Times New Roman 12 ps. font size, be between 7 and 9 pages in length, and include the following:
-The history of the program or topic
-How and why the program or topic has changed over time
-Research on the effectiveness and ineffectiveness of the program topic (via minimum of THREE
program evaluations)
-Sample size
-Lengthen of the study
-Composition of the sample
-Measures of effectiveness (recidivism rates, graduation rates, etc …)
-Results
-Author’s recommendations for changes
Formatting requirements:
-7 to 9 pages
-Times New Roman, 12 font, 1 inch margins
-Cover page including (does not count toward 7-page minimum)
-Name- Lanie Hamilton
-Title of paper- Immigration and Terrorism
-CRIJ 2313.200
-Spring 2022
-APA in-text citations & reference list (references list does not count toward 7 pg min)

Class: Correctional Systems and Practices

Leadership theory to practice paper

I’m still searching and open to a topic theory for this paper. I do have to use the theories studied so far in the course. The book we are reading is “Reframing Organizations” by Boleman and Deal. We are up to chapter 13. Asa practice of the theory I would like to come from a “Vice President of Academic Affairs” point of view.

In your opinion, what is the best base of power for the Army Profession? Why? What is the best way to influence and motivate Soldiers? Why? How does this influence your leadership philosophy?

Read the attached readings on Bases of Power and Motivating Soldiers and answer the following questions:

In your opinion, what is the best base of power for the Army Profession? Why? What is the best way to influence and motivate Soldiers? Why? How does this influence your leadership philosophy?

You must thoroughly answer each question and defend your stance. Please cite from the readings.

Formatting guidance: Use 12pt. Times New Roman, double-spaced. Citing will be done using MLA
format.

Unit 3 Special Interest Group

Select a special interest group from the HUD website.

Using your selected special
interest group, write a two-page paper to answer the questions below.
Use headings to indicate sections of your paper. Be sure to include
supporting evidence for your main ideas.

Introduce the agency, its roles and functions.
Identify how the agency attains its members.
List any special affiliation services it provides to its membership.
Classify what specific public policy category it attempts to
advance and how it goes about having its interests applied in policy
development.
Reference association conferences it has held, and identify what issues and solutions were addressed.
List past organizational conferences it has held, and identify what issues and solutions were addressed.
List any watchdog functions, such as monitoring the actions of congressional member voting records.
What is the draw to become a member in the group you have selected? What political interest does the agency serve?
Summarize the agency’s success at influencing public policy.

Your case study must be at least
two pages in length, not including the title and reference pages. Be
sure your paper is double-spaced and uses one-inch margins. Use your own
words, and include citations and references as needed to avoid
plagiarism. All sources used must be referenced; paraphrased and quoted
material must have accompanying citations and be cited per APA
guidelines.

For additional guidance on APA style, refer to the APA Paper Examples in the Learning Resources found in the Resources tab of the Student Portal.

Link to the selected special interest group:
https://www.hud.gov/program_offices/gov_relations/oirpublicinterestgroups

What noise—either from your family, friends, society, or yourself—do you feel you most need to shed? How will shedding this noise get you more aligned to who you are and where you want to go?

The Nosie: Shed It
1. What noise—either from your family, friends, society, or yourself—do you feel you most need to shed? How will shedding this noise get you more aligned to who you are and where you want to go?

2. Do you think it’s possible to truly shed all of your noise? Why or why not?
3. When you shed the noise and are able to get to your own blank canvas, you are you. Who or what does that look like?
Instructions: In this typed 1-2 page, double- spaced essay, you will create a reflection response on the above questions. Your paper should be thoughtful, clear, well-organized, and demonstrate a deeper understanding or analysis of purpose.
Your essay must include the following:
Response Reflection
INTRODUCTION
Provide an overview of your purpose paper and include your personal purpose, academic and career statement.
RESPONSE CONTENT REFLECTION
Clearly state your response to the question.
Explain why this is important to you and relate it to yourself. Use examples, personal experiences, or people who have influenced you to support your explanation.
Explain how this response relates to your reflection.
If applicable, discuss possible obstacle(s) and possible solution(s) for overcoming that obstacle.
CONCLUSION
Provide an overview of your reflection paper.
Restate your responses.
WRITING MECHANICS
There are no errors in grammar/spelling to distract the read from the content. Your paper is written in essay format. Paragraphs and sentences are well-constructed. Words are used correctly (appropriate word choice) and ideas are clearly conveyed.

Shakespeare Hamlet Essay

ENG 165: British Literature from Hamlet to Hamnet

Here are a few ideas for your first essay, due 2 / 15. You do not need to write about one of these,
but you may appreciate some help finding a topic:

The Renaissance was a time when humans rediscovered their potential for scientific, historical,
linguistic, geographic, and other kinds of discovery. The natural world yielded insights into the
workings of the human body; texts in ancient languages were recovered and translated;
engineering feats such as the great dome over Florence’s cathedral were completed; previously
unknown regions of the world were visited and mapped. There seemed to be no end to what the
human mind could achieve. At the same time, people feared there were limits to what we should
attempt to achieve. Was there a boundary to the pursuit of knowledge? Could the quest for
knowledge have some terrible consequences? Renaissance writers were fascinated by the legend
of Dr. Faustus, a medieval scientist who sold his soul to the devil in exchange for boundless
knowledge, wealth, and pleasure. Faustus thought himself clever enough to escape the devil’s
contract, but the devil finally claimed his soul and carried Faustus off to hell. Christopher
Marlowe, one of Shakespeare’s contemporaries, wrote a tragedy, Doctor Faustus, based on the
legend.

But long before Marlowe and Shakespeare, the Greek playwright Sophocles wrote a tragedy
exploring the limits of the human quest for knowledge during a similar period when the sciences
and arts flourished. Oedipus Rex is about a king proud of his ability to solve puzzles and resolve
mysteries. He sets out to find the murderer of his city’s previous king but is warned by a prophet
not to continue. He persists, only to discover that he was the murderer. Oedipus inflicts on
himself the penalty of exile he had imposed on the undiscovered criminal and blinds himself to
compound his suffering. Sophocles clearly warns contemporary Greeks not to stray beyond the
limits of reason imposed by the gods. (If you have studied ancient myths, you can think of other
stories, such as those of Prometheus and of Pandora, with similar lessons.)

In many ways, Hamlet is related to this enduring theme. Hamlet is “great” because he is what
today we call a “Renaissance Man” as Ophelia describes him: a soldier, a scholar, a courtier. He
is, above all, the cleverest person at court, sparring verbally with his mother and stepfather and
mocking the uncomprehending Polonius, Rosencrantz, and Guildenstern. Even the “scholar”
Horatio is unable to communicate with the ghost of King Hamlet, but Hamlet converses with the
spirit and learns the identity of his murderer. While mistrusting the ghost—is it a devil?—Hamlet
tries to prove its revelation by disguising himself as a madman and provoking Claudius to reveal
his guilt at a play. But when Hamlet finally acts, he mistakenly kills an innocent spy, Polonius,
instead of the king. Hamlet is caught in a chain of events that ends in Claudius’ death but also
those of Rosencrantz, Guildenstern, Ophelia, Laertes, Gertrude, and himself. The most brilliant
man in Denmark has unwittingly destroyed the royal dynasty, paving the way for a Norwegian
successor. Is this a story about the possible consequences of brilliance? Hamlet tries to prove the
truth or falsity of a spirit’s story; he hesitates to violate the sanctity of Claudius’ apparent prayer
but mistakes the king’s posture for penitence; the play is full of references to people trying, often
failing, to pierce behind appearances. (In the case of Polonius’ death, he is literally pierced while
hiding behind a curtain.) In the case of “The Mousetrap,” Hamlet apparently succeeds, but even
this scene is ambiguous—does Claudius rise because he is guilty or because he feels threatened by his nephew? Is
Shakespeare inviting us to consider the limitations of our reasoning power? That there may be some mysteries we
cannot solve? Unforeseen consequences of our discoveries?

Write an essay considering this way of looking at Hamlet. Is this a topic we still find “relatable”
today? When you consider all the brilliant technological innovations of the past few decades,
such as Amazon, Google, Facebook, Twitter and the rest, have there been unanticipated bad
consequences? What would Shakespeare say about the pursuit of ever-more-sophisticated
technology? Are the famous Titans of Tech the modern equivalents of Faust? Of Hamlet? You
can probably think of many pursuits, such as the quest for never-ending youth or longevity, that
recall the older cautionary tales, so feel free to respond based on your personal interest and
information.

On a related topic, write an essay about the phenomenon of spying in Hamlet. In Elizabethan
Britain, networks of spies were employed to foil real and imagined plots by Catholic rulers
against the British throne. Spies worked in all the noble households, for example, trying to
discover treason and unearth hidden Catholic priests. Thinking about all the references to spies
and spying in Hamlet, what do you think Shakespeare is saying to his audience about the dangers
of espionage to a healthy state? Does spying have anything to do with the play’s main plot and
its conclusion?

Another topic would be to write an essay about Hamlet and Claudius as “mighty opposites,” two
men locked in a battle—one to conceal, the other to reveal, the previous king’s murderer. How
does Shakespeare construct Claudius as the worthy opponent of his nephew? Or, in your opinion,
is the king a weak opponent, and in that case, why would Shakespeare characterize him that
way?

We discussed Laertes and Fortinbras as “foils” of Hamlet. In your opinion, why does Laertes
come to a bad end while Fortinbras inherits the Danish crown? The two characters are
similar—what if anything distinguishes Fortinbras? Or if they are parallel, why do you think
Shakespeare includes both of them in the play as foils?

We did not discuss Gertrude and Ophelia in depth, but they are worth considering as additional
foils to the main male characters. Shakespeare was a conservative writer (patronized by the
court), so his female characters usually have traditional personalities. Good women are
nurturing, innocent, loving; bad women are cruel, aggressive, conniving. Young virgins are
allowed a period of flirtation and adventure, but once married, they adopt traditional manners.
Shrews must be tamed. With this background in mind, what are the roles of Gertrude and
Ophelia within this plot? While Hamlet and Claudius are spying and plotting revenge or murder,
what do the plots involving either or both ladies reveal about the principal men in the play? Or
about the position of women at court? In British society?

Descriptive Statistics/Data Analysis Project

Presentation:
Create a document where you include the following:
Cover Sheet
2.List of Survey questions and response options
A report of the raw data you collected from the internet with the source and description of the sampling method used to collect/select the data.
The mean, median, standard deviation, IQR, and outliers for each group of data. Show computations for outliers and IQR.
Graph(s) that clearly display and contrast the “average” price in each of the cities. (Embed the graph(s) into the document.) Please identify the measure of center you used for “average” in your comparison and justify your choice of measure of center.
We re going to be using the gas prices in 5 major cities data.