Introduction

Now that you have a grasp of SQL, let’s start to get familiar with a database! Make sure you review the overviews of a variety of database platforms. For this course, we will work with Microsoft SQL Server. In the real world, remember, it’s all about the right tool for the right job. Microsoft SQL was chosen for this class because it is well-known in the field, and provides a good foundational understanding of databases with a management tool that is GUI based. (Read more about the Top 10 Databases to Use in 2021Links to an external site.Links to an external site.). 

Directions

1. Download Microsoft Access
2. Use your tables to build your relationships. Refer to the Lecture Video (Panopto) for help. 
3. Once your relationship is built, review the ERD Diagram inside Access. 
4. If it is different than your original diagram, write a no more than 1-page summary of what has changed and why. 
5. Think about what data is missing from your database, and add one additional source to your design if needed. 

Submission

• A copy of your ERD saved from Microsoft Access (Showing the relationships) with your new data source from number 5 above (If needed). 
• Reflect on what has changed during the creation of your datasets (Minimum of 1 – page). 

Instructions

You will be required to write one term paper this semester. The specifications are as follows:

1. You must write a 5-8 page term paper on a topic of your choice related to cybercrime (ALL TOPICS MUST BE APPROVED). Some examples would include, how to avoid being a victim of cybercrime, the laws surrounding cybercrime, a recent incident related to cybercrime or pick an individual cybercrime and discuss the impact this crime has on society. Please write the term paper in a Word document and then upload it for grading.
2. Your term paper outline is due at the end of Week 2.
3. Your term paper is due at the end of Week 8.
4. In addition to the 5-8 pages of the paper itself, you must include a title page and a reference page.
5. Your title page must include the title of your paper, the date, the name of the course, your name, and your instructor’s name.
6. Your reference page must be written in APA citation style, Arial or Time New Roman styles, 12-point font.
7. Page margins Top, Bottom, Left Side, and Right Side = 1 inch, with reasonable accommodation being made for special situations.
8. Your paper must be in your own words, representing original work. Paraphrases of others’ work must include attributions to the authors. Limit quotations to an average of no more than 3-5 lines, and use quotations sparingly. It is always better to write the information in your own words than to directly quote.
9. When submitting the paper, it will automatically run through Turnitin for review. PAPERS WITH AN ORIGINALITY REPORT FROM TURNITIN OVER 15% OR OVER 2% FROM A SINGLE SOURCE WILL RESULT IN A ZERO GRADE.
10. PER THE STUDENT HANDBOOK, YOU CANNOT SUBMIT A PAPER THAT HAS BEEN SUBMITTED IN ANOTHER COURSE.

INSS 662 Project : You are required to use Weka or other open source data mining software, not Watson. 

1. Find an open dataset on the Internet, see below 

2. Conduct appropriate data mining activities and report the processes and outcomes. You need to use at least three competitive algorithms from the same or different classes of Data mining or Machine Learning techniques. See the lecture slides for Chapter 5 for algorithms and techniques under course materials. 

3. Present your results.

Possible data sets to choose from:

Data from Hackathon such as  the Lord of the Machines – Data Science Hackathon, DataHack Premier League, Mckinsey Analytics Online Hackathon,  etc.   (Be brave  to take challenging  problem …)

Possible sources are: 

a. https://archive.ics.uci.edu/ml/index.php  

b. https://www.kaggle.com/datasets  

c. https://www.kdnuggets.com/datasets/index.html (Datasets for Data Mining and Data Science)

d.  open government dataset @ https://catalog.data.gov/dataset?groups=local

e. Dataset from URL: https://www.ibm.com/communities/analytics/watson-analytics-blog/guide-to-sample-datasets/

OR

f. Other datasets after getting approval from the instructors.

Case Study 2.1

Case Study:

You have just been hired to perform digital investigations and forensics analysis for a company. You find that no policies, processes, or procedures are currently in place. Conduct research to find information, and then create a policy and process document (3 to 4 pages in length) to provide the structure necessary for your lab environment. Be sure to cite your online sources and follow APA formatting.

Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• At least two peer reviewed sources that are properly cited and referenced
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

Case Study 3.1

Establish a procedure for your organization on how to validate a new forensics software package. Write 3 to 4 pages outlining the procedure you plan to use in your lab. Be sure to cite references, such as the ISO standard or NIST, to support your procedure. Make sure you use APA formatting.

Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• Include at least two peer reviewed sources that are properly cited
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

Case Study 2.1

Address the six questions associated with the chapter two Case study, “From Steve Jobs to Tim Cook – Apple” on page 23 in a three to five page paper (excluding title, abstract, and reference pages). Include at least three peer reviewed sources found in the Potomac Library properly cited and referenced. Assignment must be in 7th edition APA compliance.

Please use this strategy when you analyze a case:

1. Identify and write the main issues found discussed in the case (who, what, how, where and when (the critical facts in a case).
2. List all indicators (including stated “problems”) that something is not as expected or as desired.
3. Briefly analyze the issue with theories found in your textbook or other academic materials. Decide which ideas, models, and theories seem useful. Apply these conceptual tools to the situation. As new information is revealed, cycle back to sub steps a and b.
4. Identify the areas that need improvement (use theories from your textbook)
   • Specify and prioritize the criteria used to choose action alternatives.
   • Discover or invent feasible action alternatives.
   • Examine the probable consequences of action alternatives.
   • Select a course of action.
   • Design and implementation plan/schedule.
   • Create a plan for assessing the action to be implemented.
5. Conclusion (every paper should end with a strong conclusion or summary)