Assignment 2: Weekly Assignment: Do the Crime, Do the Time

Officer Johnson has been closely studying the family we have been following throughout this course. He mentioned in his report that Rob and Junior were managing the drug-based business. Mary was managing prostitution. Junior was working with some of his friends on a new capper. One of Junior’s friends was stealing computers from his employer and selling them on the Internet. Officer Johnson is also helping Lucy cope with sexual assault by her father, Rob. She was forced by her parents to get involved in prostitution. She is a minor and a victim of child abuse.

Having reached the conclusion of this course, you have seen how a normal Centervale family became involved in criminal activity. Through the previous modules, you have seen how the criminal element is transferred from the parents to the children and the affect this has on various lives in the family unit. You will now evaluate both sides of the issues in this case; from the prosecution’s perspective and defense’s perspective taking the following into account:

• Family pressure to act a certain way for acceptance
• Possible defenses that could be given
• Sentencing possibilities for the various crimes you have studied

Please consider how the events of this Centervale story play out from the standpoint of the prosecution and the defense. You are to review all modules to complete this discussion.

Submission Details:

By Sunday, November 1, 2015, in a minimum of 300 words, post your responses to the following to the Discussion Area:

• What were the considerations for the family to enter a life of crime?
• How did involvement in crime affect interactions among the members of the family?
• What was the impact of the parents’ behaviors on other family members and the long-term effects on each of the parties?
• What are the various defenses that might be raised for Rob, Mary, and Junior and why?
• What are the potential sentencing options for the three members of the family, Rob, Mary, and Junior, and why are these sentences justifiable?
• Critically analyze the working of the American criminal justice system and suggest ways to improve it so that scenarios as given in this course can be prevented.

By Wednesday, November 4, 2015, respond to at least two of your classmates’ posts. Consider commenting on the family’s considerations for entering crime and how it affects their interactions as a unit. Comment on the considerations for potential sentencing and decipher why these sentences are justifiable. Comment on the suggested recommendations for improvements in the American criminal justice system.

Discussion Grading Criteria and Rubric

All discussion assignments in this course will be graded using a rubric. This assignment is worth 40 points. Download the discussion rubric and carefully read it to understand the expectations.

Assignment 1: LASA 2: Analysis of Technology, Culture and Victims in Crime

Jamal, a straight A junior in High School, was recently involved in a physical fight with another student in the corridor of the school. Juan is a recovering alcoholic who has absenteeism issues and poor grades. Although Juan was held back in sixth grade, and struggles with social situations, he has never been involved in any disciplinary action at school. However, Jamal recently completed 90 hours of community service after being convicted of disorderly conduct and simple assault from an unrelated incident.

The school video recordings show Jamal instigating the fight, yet student witnesses reported to school officials and law enforcement that Juan was the instigator. During the investigation, a drug dog alerted law enforcement to the possibility that a controlled substance was present in Juan’s locker. When confronted by law enforcement, Juan claimed Jamal planted the drugs in Juan’s locker to hide Jamal’s own habit. Regardless, Juan was placed under arrest. An external security camera recorded a verbal altercation between law enforcement and a group of young adults who felt Juan’s arrest was racially motivated.

Tasks:

You are the District Attorney’s Investigator and have been asked to evaluate this situation as pursuant to Juan’s upcoming trial. Compose a 3-6 page paper to address the following:

1. Identify, define, examine, and discuss the crimes potentially committed by Juan and Jamal.
2. Identify the victim(s) in this scenario. Outline the rights of the victim(s) as they related to social responsibility.
3. Compare and contrast the legal issues that could arise for the police department in this scenario.
4. Analyze how societal diversity might have played a role in this case. Discuss ethical practices utilized by law enforcement that help them to maintain their objectivity throughout their investigation of this incident, Jamal and Juan’s backgrounds, and the underlying interests of social order.
5. Evaluate the use of technology, such as video tape recordings, as demonstrative evidence in the courtroom.

Compile your paper, including all information researched, and prepare a submission paper in accordance with the following guidelines:

• This paper is to be in APA format with a cover sheet and reference page at the end.
• The length of the paper is to be a minimum of three pages and no more than five pages. This length does not include your cover or reference sheets.
• Remember that APA font is Times New Roman, font size 12.

Submission Details:

• Save the final paper as M5_A1_Lastname_Firstname.doc.
• By Monday, November 2, 2015, submit your final paper to the M5: Assignment 1 Dropbox.

LASA 2 Grading Criteria and Rubric

All discussion assignments in this course will be graded using a rubric. This assignment is worth 300 points. Download the discussion rubric and carefully read it to understand the expectations

For this application, you must use the following citations and references:

 

 

 

Required Resources

 

 

 

This page contains the Learning Resources for this week. Be sure to scroll down the page to see all of this week’s assigned Learning Resources. To access select media resources, please use the media players below.

 

 

 

Course Text: Qualitative Inquiry and Research Design: Choosing Among Five Approaches

 

Review Chapter 7, “Data Collection”

 

Course Text: “Stretching” Exercises for Qualitative Researchers

 

Appendix G: Conducting Qualitative Interviews: Rules of Thumb (p. 243)

 

This appendix gives some quick tips for conducting qualitative interviews.

 

Chapter 4, “The Interviewing and Writing Habit”

 

This section of the book breaks down the interview cycle into the “before,” “during,” and “after” stages, and provides strategies and exercises to help prepare you for each part of the interview process. The pages for this week explain types of interview questions and provide a sample interview protocol.

 

Course Text: Patton, M. Q. (2015). Qualitative research and evaluation methods (4th ed.). Thousand Oaks, CA: Sage Publications, Inc.

 

Chapter 7, “Qualitative Interviewing”

 

This chapter focuses on strategies needed to ensure the success of qualitative interviews. Patton also discusses relevant subtopics, such as types of interview questions, the importance of neutrality, cross-cultural interview considerations, potential ethical issues, and tips for effectively recording data gathered during the interview process.

 

Software

 

NVivo

 

Media

 

 

 

Video: Laureate Education, Inc. (Executive Producer). (2010c). Doctoral research: Interviewing techniques, part I. Baltimore: Author.

 

 

 

Note: The approximate length of this media piece is 9 minutes.

 

 

 

These programs provides two demonstrations of an interview being conducted in a school setting. As you watch, focus on the differences between the two demonstrations in these areas:

 

The interview setting

 

The interview process

 

Interviewer and interviewee behavior and body language (Is rapport being built? How?)

 

The interview questions (Which questions elicited better information?)

 

 

 

Application

 

Sampling Strategy and Sample Size for a Qualitative Research Plan

 

As you continue to work on your qualitative research plan, you will have to address the size and diversity of your sample population. Different kinds of studies require different sample sizes, and you should select a size that will be most appropriate for your topic and approach.

 

To prepare for this Application:

 

Review the Chapter 5 readings in Qualitative Research and Evaluation Methods for this week.

 

Consider the following questions:

 

From which sampling strategy would your study benefit? What factors contribute to this decision?

 

What sample size would you use for the study that you are planning? What factors contribute to this decision?

 

How would you justify using that particular sampling strategy and sample size? What Resources can you cite to support your justification?

 

The assignment:

 

Craft a 5-page paper in which you do the following:

 

Recommend and justify a sampling strategy and sample size for your qualitative research plan. Include any references to the literature, where appropriate.

The student will select a local or state law enforcement or other state or local government organization concerned with emergency management and planning, and research, analyze and critique on the organization’s emergency management and planning processes. The focus of the analysis is to examine the various emergency management planning components: Mitigation; Preparedness; Response; and Recovery, as well as how the organization uses Unity of Command and NIMS principles in its emergency management practices.

Because federal agencies are generally responsible for supporting state and local agencies involved in emergency management, they should not be used for this assignment. In addition, military emergency planning organizations should not be used for this assignment as a are generally more self-reliant and not involved in community emergency management practices.

The research should include web search, periodicals, publications and interviews of personnel involved with the Emergency Management planning of the organization and personal observations when possible. Students should view the information obtained with the purpose of critiquing the organization’s fulfillment of the components suggested by the text and other sources. Explain the pros and a con of the organization’s emergency management process. The analysis could look at whether the agency has anticipated emergencies that law enforcement will be responsible for. Perform analysis of how the agency has coordinated with other local state and federal agencies. Describe the plans that have been developed for handling emergencies. Evaluate any exercises that test the plans and propose ways in which the organization may improve their emergency management planning and response.

The purposes in conducting and writing this study are to improve your ability to synthesize, analyze, and evaluate information carefully and objectively, solve problems effectively, present your ideas in clear written form directed to a specific audience, in this case, your class.

To complete this project, you should:

1. Select law enforcement agency at the state or local level in which you are interested.
2. Gather materials from the agency, such as planning reports and practical exercise reports and other resources that may be available.
3. Describe the procedures you will use to conduct your study and place in a methodology section.
4. Evaluate the structure, practice, and procedures of the organization.
5. Compose the results of your study.
6. Formulate conclusions about your findings, including the positive and negative aspects you discovered.
7. Argue in what ways the agency could improve its emergency management process.

Your paper must include:

1. A cover page
2. Abstract
3. Introduction
4. Methodology section
5. Discussion
6. Reference page
7. Appendices which may include a summary of your interview(s) and organization charts of your agency and your section

The text of this paper should be at least 2,000 words or eight pages typewritten or computer-generated, not counting the cover page, reference pages, and appendices. The paper shall be double spaced in either Courier or Times New Roman, 12 font. You must illustrate the terminology and the concepts used in the section of the agency you studied and demonstrate that you can apply these concepts.   You must demonstrate that you can define, explain, synthesize, analyze, and evaluate the information acquired. You must correctly use APA format in source citation both in the body of the paper and in the reference page.

You can use a calculator to do numerical calculations. No graphing calculator is allowed. Please DO NOT USE ANY COMPUTER SOFTWARE to solve the problems.

 

 

 

 

 

1. (a) What is an assignment problem? Briefly discuss the decision variables, the objective function and constraint requirements in an assignment problem. Give a real world example of the assignment problem.

 

 

 

(b) What is a diet problem? Briefly discuss the objective function and constraint requirements in a diet problem. Give a real world example of a diet problem.

 

 

 

(c) What are the differences between QM for Windows and Excel when solving a linear programming problem? Which one you like better? Why?

 

 

 

(d) What are the dual prices? In what range are they valid? Why are they useful in making recommendations to the decision maker? Give a real world example.

 

 

 

Answer Questions 2 and 3 based on the following LP problem.

 

 

 

Let     P1 = number of Product 1 to be produced

 

P2 = number of Product 2 to be produced

 

P3 = number of Product 3 to be produced

 

P4 = number of Product 4 to be produced

 

 

 

Maximize 80P1 + 100P2 + 120P3 + 70P4        Total profit

 

Subject to

 

10P1 + 12P2 + 10P3 + 8P4 ≤ 3200       Production budget constraint

 

4P1 + 3P2 + 2P3 + 3P4 ≤ 1000       Labor hours constraint

 

5P1 + 4P2 + 3P3 + 3P4 ≤ 1200       Material constraint

 

P1 > 100         Minimum quantity needed for Product 1 constraint

 

And P1, P2, P3, P4 ≥ 0             Non-negativity constraints

 

 

 

The QM for Windows output for this problem is given below.

 

 

 

Linear Programming Results:

 

Variable           Status   Value

 

P1        Basic    100

 

P2        NONBasic       0

 

P3        Basic    220

 

P4        NONBasic       0

 

slack 1NONBasic       0

 

slack 2Basic    160

 

slack 3Basic    40

 

surplus 4          NONBasic       0

 

Optimal Value (Z)        34400

 

 

 

Original problem w/answers:

 

P1        P2         P3         P4          RHS        Dual

 

Maximize              80       100       120        70

 

Constraint 1          10         12         10         8   <=    3200         12

 

Constraint 2           4           3          2          3   <=    1000          0

 

Constraint 3           5           4          3          3   <=    1200          0

 

Constraint 4          1            0          0          0   >=      100       -40

 

Solution->         100            0      220          0   Optimal Z->    34400

 

 

 

Ranging Results:

 

Variable           Value   Reduced Cost  Original Val     Lower Bound   Upper Bound

 

P1        100      0          80        -Infinity           120

 

P2        0          44        100      -Infinity           144

 

P3        220      0          120      87.5     Infinity

 

P4        0          26        70        -Infinity           96

 

 

 

Constraint        Dual Value      Slack/Surplus   Original Val     Lower Bound   Upper Bound

 

Constraint 1     12        0          3200    1000    3333.333

 

Constraint 2     0          160      1000    840      Infinity

 

Constraint 3     0          40        1200    1160    Infinity

 

Constraint 4     -40       0          100      0          120

 

 

 

 

 

2. (a) Determine the optimal solution  and optimal value and interpret their meanings.

 

(b) Determine the slack (or surplus) value for each constraint and interpret its meaning.

 

 

 

 

 

3. (a) What are the ranges of optimality for the profit of Product 1, Product 2, Product 3, and Product 4?

 

(b) Find the dual prices of the four constraints and interpret their meanings. What are the ranges in which each of these dual prices is valid?

 

(c) If the profit contribution of Product 2 changes from $100 per unit to $130 per unit, what will be the optimal solution? What will be the new total profit? (Note: Answer this question by using the ranging results given above).

 

(d) Which resource should be obtained in larger quantity to increase the profit most? (Note: Answer this question using the ranging results given above.).

 

 

 

 

 

4. The Portfolio Manager of Charm City Pension Planners, Inc., has been asked to invest $1,000,000 of a large pension fund. The management of the company has identified five mutual funds as possible investment options. The details of these five mutual funds are given below:

 

 

 

                                                                  Mutual Fund

 

1           2           3            4             5

 

Annual return (in dollars)     12%       10%      8.5%       10%      11%

 

Risk amount (in dollars)       9.8%       8%      7.2%       7.1%     7.3%

 

 

 

To control the risk, the management of the company has specified that the total risk amount cannot exceed $200,000. In addition, the management wants to invest at least $150,000 in mutual fund 2 and at least $125,000 in mutual fund 3.

 

 

 

With these restrictions, how much money should the portfolio manager of the company invest in each mutual fund so as to maximize the total annual return?

 

 

 

(a) Define the decision variables.

 

(b) Determine the objective function. What does it represent?

 

(c) Determine all the constraints. Briefly describe what each constraint represents.

 

 

 

Note: Do NOT solve the problem after formulating.

 

 

 

 

5. A charity wants to contact people to collect donations. A person can be contacted morning or evening, by phone, or door-to-door. The average donation resulting from each type of contact is given below:

 

 

 

Phone          Door-to-Door

 

____________________________________

 

Morning           $35                    $60

 

Evening            $40                    $70

 

 

 

The Charity has 150 volunteer hours in the morning and 120 volunteer hours in the evening. Each phone contact takes 6 minutes and each door-to-door contact takes 15 minutes to conduct. The Charity wants to have at least 550 phone and at least 400 door-to-door contacts.

 

 

 

Formulate a linear programming model that meets these restrictions and maximizes the total average donations by determining

 

 

 

(a) The decision variables.

 

(b) Determine the objective function. What does it represent?

 

(c) Determine all the constraints. Briefly describe what each constraint represents.

 

 

 

Note: Do NOT solve the problem after formulating

 

 

 

6. The Charm City Truck Rental Inc. has accumulated extra trucks at three of its truck leasing outlets, as shown in the following table:

 

 

 

Leasing Outlet            Extra Trucks

 

1. Atlanta               70

 

2. St. Louis          115

 

3. Greensboro        60

 

 

 

The firm also has three outlets with shortages of rental trucks, as follows:

 

 

 

Leasing Outlet            Truck Shortage

 

A. New Orleans          80

 

B. Cincinnati             50

 

C. Baltimore             45

 

 

 

The firm wants to transfer trucks from those outlets with extras to those with shortages at the minimum total cost. The following costs of transporting these trucks from city to city have been determined:

 

 

 

To (cost in dollars)          

 

From      A      B         C

 

1            75      80        45

 

2          115      50        55

 

3          100      60        40

 

 

 

For this transportation problem:

 

 

 

(a) Define the decision variables.

 

(b) Determine the objective function. What does it represent?

 

(c) Determine all the constraints. Briefly describe what each constraint represents.

You are required to write a thematic paper that traces one of the biblical themes discussed in the course. The paper should be 1000-2000 words in length and follow MLA style. Choose one of the options below:

 

Option A. Trace one of the biblical themes from the list below noting developments of that theme in the Old Testament and in the New Testament. Show how New Testament writers reinterpreted the theme. Show the continuity in the development of the theme as well as any changes in meaning. Note any areas of disputed understanding.

This paper must be accompanied by an outline. Length: 1000-2000 words.

Justice   Love   Jerusalem   Wrath   Christ   Son of God   Lord   Priest    Prophet   Servant   Son of Man  Shepherd     Chosen People  Kingdom of God Elijah   Righteousness  Faith   Obedience   Redemption  Salvation  Resurrection      Law   Death    Passover   Sin   Repentance  Compassion

 

See the course Doc Sharing area for a bibliography for source material. Be sure to use some of those biblical reference books in the bibliography for your paper, especially those by Bauer, Buttrick, Freedman, Kittel and Friedrich, Leon-Dufour, McKenzie, and Sackenfeld. Avoid using other sources found on the Internet unless cleared in advance with the instructor. Publically available digital sources may not always be of high quality. The paper needs to be well documented. Be certain to distinguish between paraphrase and quotation.

 

Option B. Describe the intended audiences (readers) for the Gospels according to Mark, Matthew, Luke, and John. Show how specific words and/or passages in each Gospel imply particular audiences.

See the course Doc Sharing area for a bibliography for source material. Be sure to use some of those biblical reference books in the bibliography for your paper, especially Brown. You may find an EBSCO search using the online library resources to be helpful. Limit your search to full-text and peer-reviewed articles.

 

You may also search GOOGLE BOOKS (not just GOOGLE) to access published books online; document the information from those books as books including author, title, publisher, date, and page numbers. The paper needs to be well documented. Be certain to distinguish between paraphrase and quotation.

Select a government agency (local/state/federal) and develop a four- to five-page APA-style paper summarizing the following:

1. Explain how the debt capacity of the governmental entity is determined.
2. Evaluate the effect of refunding or reorganizing existing debt obligations.
3. Analyze various funding alternatives that can be used to support debt obligations

Develop a four- to five-page paper in which you analyze the Public Budget Cycle in a government agency of your choice. Be sure to include each of the phases of the budget cycle (preparation and submission, approval, execution and audit, and evaluation) and address how each relates to the overall organizational mission of the government agency.

Read the following scenario:

You are an independent consultant who has recently been hired by JC’s Casino to help improve retention issues concerning the dealers and housekeepers. Most of the dealers have been leaving the casino to work at other casinos in the area, even though JC’s Casino pays better than their local competition. On several exit interviews, many of the dealers have cited the pit boss, Joe, as being “toxic, overbearing, evil, and incompetent.” Joe is the casino owner’s step-son and the HR director, Tom Sneed, is afraid to confront the owner.

Among the housekeeping staff, there has been an above normal rate of absenteeism and high turnover of rooms. Many of the managers who work in accounting, payroll, and other departments have had to ask their full-time employees to help cover for housekeeping by cleaning rooms periodically. Because of this problem, the hotel has had to adjust their check in times from 3 p.m. (the industry standard) to 6 p.m. Customers have arrived earlier and the hotel has had to accommodate them by creating a room to hold luggage. They have also had to hire staff to man the luggage room.

The director of housekeeping, Andrew Keehn, has been working hard to add more staff but he states “good help is hard to find.” The housekeeper’s current hourly wage is comparable to other casinos in the area but because of the staffing shortage, the housekeepers have to clean more rooms per day than their counterparts. The casino owner only knows that there are some issues with keeping the dealers and that some customers were upset because they had to wait to check in. You have been hired for a quick fix and your suggestions were needed yesterday.

Write a 1,400- to 1,700-word paper in which you identify each issue and make recommendations to JC, the casino president, on how to improve overall retention. What the scenario does not provide, you can create. Be sure to include the following in your assessment:

• Evaluate at least two work motivation theories and how they can be applied in order to improve employee recruitment and retention at JC’s Casino.
• Examine possible occupational stressors that are negatively influencing recruitment and retention. What improvements would you suggest to alleviate these stressors?
• Examine the role of job satisfaction and its influence on retention at the casino. Provide recommendations for improving job satisfaction of the employees and how that can play a part in successfully improving retention.
• Discuss counterproductive employee behavior occurring at the casino. What suggestions would you make to reduce the counterproductive behavior and increase productive employee behavior?

Assignment 2: LASA 1—Analysis of Historical, Legal, and Ethical Issues

As someone knowledgeable about research on children with exceptionalities, you have been given the task of presenting a report to the court on your arguments for and against people with intellectual disabilities raising children.

Do the following:

• Launch the online library (under Academic Resources).
• Select Find Videos.
• Select Filmakers Library Online.
• In the search box, type “is love enough” and click Go.
• The first result should be Is Love Enough?directed by Tom Puchniak. Review this video.

Analyze the historical, legal, and ethical issues in the video. Make sure you include the following in your analysis (in an order that flows well in your paper):

• Compare the historical trends related to people with disabilities. How would outcomes be different fifty years ago for the people in the movie?
  • Compare the differences from about ten years ago when the movie was produced to today.
  • Explain how far we have come and what still needs to be addressed (such as terminology, acceptance, and support).
• Explain how laws such as the Americans with Disabilities Act (ADA) and the IDEA influence these decisions.
• Identify the ethical principles that might apply to the situation. Consider the professional ethics codes, including the following:
  • American Psychological Association. (2010). Ethical principles of psychologists and code of conduct. Retrieved from http://www.apa.org/ethics/code/index.aspx
  • American Counseling Association. (2005). ACA code of ethics. Alexandria, VA: Author. Retrieved from http://www.counseling.org/resources/codeofethics/TP/home/ct2.aspx
• Synthesize your research and create two arguments: one for and one against parents with intellectual disabilities raising children. Consider the perspectives of the parents as well as the children. Use evidence and examples from research, utilizing your assigned readings, and at least two peer-reviewed articles on this topic to support your argument.
• Given what you learned in the video, your assigned readings, and research you found, recommend supports or interventions for the following:
  • The family
  • Within the community for the family and child
  • The school
• Although this video focused on those with intellectual disabilities, generalize the issues to other exceptionalities.
• Conclude your paper with a review of current thinking for and against people with exceptionalities raising children, based on the sources used.

Write a 7–9-page paper (not counting the title page, abstract, or reference page) in Word format. Apply APA standards to citation of sources. Be sure to include a title page, abstract, and reference page also in APA forma

This assignment consists of two (2) sections: a business requirements document and a Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

 

Procuring quality business requirements is an important step toward the design of quality information systems. Completion of a quality requirements document allows user needs and expectations to be captured so that infrastructure and information systems can be designed properly. Using the requirements document provided in the course shell, you are to speculate on the needs of the company. You must consider current and future requirements; however, assumptions should be realistic and carefully considered.

 

Section 1: Business Requirements Document

1. Write an eight to ten (8-10) page original business requirements document for the project plan using the template provided. Note: The template can be found in the Student Center of the online course shell.
   1. Describe the project including the following:

1. Describe the scope and analyze how to control the scope.
2. Identify possible risks, constraints, and assumptions.

iii.    Describe the integration with other systems and infrastructure.Note: Database and interface design, security, and networking should be considered.

1. Define relevant terms that will be used throughout project.

1. 1. Use at least two (2) quality resources in this assignment. Note:Wikipedia and similar Websites do not qualify as quality resources.

 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

 

Section 2: Revised Gantt Chart / Project Plan

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, fromProject Deliverable 1: Project Plan Inception, with all the project tasks.

 

The specific course learning outcomes associated with this assignment are:

• Apply integrative information technology solutions with project management tools to solve business problems.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

 

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric.

 

 

 

 

 

 

 

 

 

Project Deliverable 3: Database and Programming Design

 

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

 

One (1) of the main functions of any business is to transform data into information. The use of relational databases has gained recognition as a standard for organizations and business transactions. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships,views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company.

 

Section 1: Design Document

1. Write a five to ten (5-10) page design document in which you:

1. 1. Create a database schema that supports the company’s business and processes.
   2. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, andindexes.
   3. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.
   4. Normalize the database tables to third normal form (3NF).
   5. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
   6. Explain your rationale behind the design of your E-R Diagram.
   7. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
   8. Explain your rationale behind the design of your DFD.
   9. Create at least two (2) sample queries that will support the organizational reporting needs.
   10. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.

 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

 

Section 2: Revised Gantt Chart / Project Plan

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, fromProject Deliverable 2: Business Requirements, with all the project tasks.

 

The specific course learning outcomes associated with this assignment are:

• Describe the various integrative functions and processes within the information systems area, including databases, systems analysis, security, networking, computer infrastructure, human computer interaction, and Web design.
• Demonstrate the ability to evaluate organizational issues with integrative technological solutions.
• Apply integrative information technology solutions with project management tools to solve business problems.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

 

 

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric.

 

 

 

 

 

 

Project Deliverable 4: Infrastructure and Security

 

This assignment consists of two (2) sections: an infrastructure document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

 

The last section of the project plan will present the infrastructure in accordance with the parameters set forth at the outset of the project. The network solution that is chosen should support the conceived information system and allow for scalability. The network infrastructure will support organizational operations; therefore, a pictorial view of workstations, servers, routers, bridges, gateways, and access points should be used. In addition, access paths for Internet access should be depicted. A narrative should be included to explain all the nodes of the network and the rationale for the design. Lastly, using the Confidentiality, Integrity and Availability (CIA) Triangle, define the organizational security policy. CIA is a widely used benchmark for evaluation of information systems security.

 

Section 1: Infrastructure Document

1. Write a five to ten (5-10) page infrastructure document in which you:

1. 1. Design a logical and physical topographical layout of the planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
   2. Illustrate the possible placement of servers including access paths to the Internet and firewalls. Note: Facility limitations, workstations, printers, routers, switches, bridges and access points should be considered in the illustration.
   3. Explain the rationale for the logical and physical topographical layout of the planned network.
   4. Create a comprehensive security policy for the company that will:

1. Protect the company infrastructure and assets by applying the principals of CIA. Note: CIA is a widely used benchmark for evaluation of information systems security, focusing on the three core goals of confidentiality, integrity and availability of information.
2. Address ethical aspects related to employee behavior, contractors, password usage, and access to networked resources and information.

 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the infrastructure document. All references to these diagrams must be included in the body of the infrastructure document.

 

 

 

 

Section 2: Revised Gantt Chart / Project Plan

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, fromProject Deliverable 3: Database and Programming Design, with all the project tasks.

 

The specific course learning outcomes associated with this assignment are:

• Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
• Evaluate the issues and challenges associated with information technology integration.
• Evaluate the ethical concerns that information technology solve or present in a global context.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

 

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric.

 

 

 

 

 

 

Final Project: Project Plan

 

This assignment consists of three (3) sections: a written project plan, a revised Gantt chart or project plan, and a project plan PowerPoint presentation. You must submit the three (3) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

 

While taking all business and project parameters into consideration, make quality assumptions to support the following requirements.

 

Section 1: Written Project Plan

You are now in the final stage of the project plan development. All previous documentation will be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team and the venture capital group. The project plan is very detailed which is appropriate to accomplish the monumental task of implementation. However, the executive team is only interested in a ten (10) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive group that your solution is optimal.

1. Write an eight to ten (8-10) page executive summary in which you provide a high-level technical overview of your project where you address the following:
   1. Describe the scope of the project and control measures.
   2. Describe the goals and objectives of the project.
   3. Give a detailed, realistically estimated cost analysis of the entire project.
   4. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.
   5. Provide all aspects of the information technology implementation into the project plan.
   6. Use at least five (5) quality resources in this assignment. Note:Wikipedia and similar Websites do not qualify as quality resources.

 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document.

 

Section 2: Revised Gantt Chart / Project Plan

Use Microsoft Project or an open source alternative, such as Open Project, to:

1. Update the Gantt chart or project plan (summary and detail) template, fromProject Deliverable 4: Infrastructure and Security, with all the project tasks.

 

 

Section 3: Project Plan PowerPoint Presentation

Additional to your detailed executive summary you must present your findings to the executive team and the venture capital group that, along with the executive summary, will convince the group that your solution is optimal.

1. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:
   1. Illustrate the concepts from your written report in Section 1 of this assignment.
   2. Create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
   3. Use a professional technically written style to graphically convey the information.

 

The specific course learning outcomes associated with this assignment are:

• Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
• Evaluate the issues and challenges associated with information technology integration.
• Summarize the competitive advantage that information technology affords to organizations.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.