Writing Assignment (due in Week 10)

The purpose of this project is to analyze healthcare data based on the information that you learned in class. This project will be different for each student since students have the ability to select their own data from the Center for Disease Control’s website. (There is no charge for information from this website.)

Log onto the Center for Disease Control’s website at http://www.cdc.gov/nchs/ (Links to an external site.).  This will take you directly to the National Center for Health Statistics. 

Note: You may find it helpful to get familiar with the website before doing major research. Feel free to click on all the different sources of information on the site…i.e., “Feature Topics”, “New Releases”, “Survey and Data Collections”, etc. Once you identify a topic, feel free to utilize the search engine on the site for additional information about your topic. 

Find a topic that you would like to do some more research in. For example, “Injuries.” You will find that there is an abundance of information for you to complete your report on in most categories. However, you may choose to do your report on Injuries in Alaska, and you will run into problems since there isn’t a lot of data. Make certain that you select a topic and parameters that lend themselves to complete analysis.

Note: There are tutorials available for you to view on the website if you need help with your data.

Your topic needs to include at least 5 variables. Example: Unintentional injuries in Females over the age of 65 in the state of Nevada. (Variable List: 1) Injuries, 2) Unintentional, 3) Females, 4) over 65, and 5) Nevada.)

Now, do an analysis of this information using the information that you learned in class and your book. Make certain to include charts, graphs, and narrative. If you find that you need more information to complete your analysis, broaden your topic. Prepare your analysis as if it is going to be published in a journal making sure to site all of our sources properly. Writing Assignment should be 6-8 pages in content, not to include title and reference pages.

Helpful Information from the Virtual Librarian  (click on the link)

If you have questions or problems don’t hesitate to contact your instructor through the course e-mail or the Virtual Library.   

1. Write a research paper in APA format on a subject of your choosing that is related to Business Intelligence.  Integrate what you have learned from the course resources (.e.g. Textbook Readings, Discussion Board Posts, Chapter Presentations) into your document.

   As you consider the topic for your research paper, try and narrow the subject down to a manageable issue.  Search for academic journal articles (i.e. peer reviewed) and other sources related to your selected subject.  Because this is a research paper, you must be sure to use proper APA format citations.  

   Your paper must include an introduction stating what you paper is about and a logical conclusion.

   This paper must contain a minimum of 1500 words of content and use at least 5 peer reviewed sources.  Peer reviewed sources include:  Academic Journal Articles, Textbooks, and Government Documents.  At least one of the textbooks for this course must be used as a source for this paper.

   Example Topics:

   • Use of Artificial Intelligence in Decision Support Systems.
   • Business Uses of Natural Language Processing.
   • Use of Game Theory in Business Intelligence Systems.
   • Use of Decision Trees in Automated Systems.
   • The Social Networks for Collaborative Decision Making.

   The rubric for this assignment can be viewed when clicking on the assignment link.

   Purdue Owl APA Format

2. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution’s policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.
4. WU RELEASE STATEMENT: The material submitted for this assignment may be screened by the student and/or the instructor for similarity of content by Blackboard’s SafeAssign feature. The purpose of this feature is to help educate the student about the proper citation of borrowed content and to protect the student against plagiarism. The submitted material will be checked against academic databases, internet documents, and student papers from both Wilmington University and other institutions. The final draft of submitted material will become part of the Wilmington University database. The student may also voluntarily submit the material to the SafeAssign Global Reference Database, which helps to protect the originality of the student’s work across institutions. For more information about plagiarism and citation conventions, please reference https://wilmu.edu/studentlife/acadintegrity.aspx.

 COPA and CIPA
Due Week 4 and worth 70 points 
 

Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns and two of your tables. (Hint: where col1 = value1 AND col2 = value2). Which columns and tables you choose is up to you and will be based on your initial design. You may alter your tables if it makes sense to do so.

In most cases you will need to create a separate policy and function for each of the two tables you select. Use the tutorial as a reference and follow the steps for creating the policy function, creating the virtual private database policy and testing the policy.

Deliverables:

1. Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and why you selected the tables and columns you did for your Private database. Provide screen shots showing the successful running of all of your SQL statements and testing your implementation. Be sure your testing is comprehensive and clearly demonstrates how the virtual private database restricts access to specific records. The document should be neat, well-organized, well-written and contain minimal grammar and spelling errors.

2. A .sql script file containing all SQL statements you used for this effort. All SQL statements should be in one file with appropriate connect statements to differentiate users who run the script. The script file should contain comments describe each major set of SQL statements. The script should run perfectly without error when executed from the Oracle SQL*PLUS environment.

3. Create your own short and simple JDBC Java code example that inserts 2 records into an Oracle table of your creation.

From a design perspective, the Java functionality should be separated into methods and use prepared Statements for your SQL statements.

Post your fully functional code along with screen shots demonstrating the successful running of it.

Note this code should compile and run from the command prompt.

Case Study 2: Public Key Infrastructure

Due Week 6 and worth 60 points

Suppose you are the Information Security Director at a small software company. The organization currently utilizes a Microsoft Server 2012 Active Directory domain administered by your information security team. Mostly software developers and a relatively small number of administrative personnel comprise the remainder of the organization. You have convinced business unit leaders that it would be in the best interest of the company to use a public key infrastructure (PKI) in order to provide a framework that fosters confidentiality, integrity, authentication, and nonrepudiation. Email clients, virtual private network (VPN) products, Web server components, and domain controllers would utilize digital certificates issued by the certificate authority (CA). Additionally, the company would use digital certificates to sign software developed by the company in order to demonstrate software authenticity to the customer. 

Write a two to three (2-3) page paper in which you:

1. Analyze the fundamentals of PKI, and determine the primary ways in which its features and functions could benefit your organization and its information security department.
2. Propose one (1) way in which the PKI could assist in the process of signing the company’s software, and explain the main reason why a customer could then believe that software to be authentic. 
3. Compare and contrast public and in-house CAs. Include the positive and negative characteristics of each type of certificate authority, and provide a sound recommendation of and a justification for which you would consider implementing within your organization. Explain your rationale.
4. Use at least three (3) quality resources in this assignment (no more than 2-3 years old) from material outside the textbook. 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.

The specific course learning outcomes associated with this assignment are:

• Explain how businesses apply cryptography in maintaining information security.
• Use technology and information resources to research issues in information systems security.
• Write clearly and concisely about network security topics 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. Click hereto access the rubric for this assignment.