I need a 275 worrd reply to this students post. They answered the question and you must provide them feedback. This is due in 4 hours.

Criteria

Overall Score

You have been hired as the Chief Security Officer for a local University.  For this role you will be responsible for establishing and maintaining an enterprise wide information security program to ensure that all information and data assets are not compromised.  Knowing the concepts that are presented in the course, you will develop a plan to carry out a security program that deters computer crimes, establishes a process for investigation and outlines which laws are applicable for possible offenders. 

Write a 8-10 page paper in which you:

Research the Internet for recent computer hacker attacks or other crimes that have been committed against higher educational institutions. 

1. Analyze the processes put in place by other higher education institutions in order to prevent these crimes from reoccurring. 
2. Recommend processes, methodologies, or technology that can be purchased to lower computer crime threats.  Include specifics on pricing and the level of support and maintenance that would be required.

Research the Internet for current laws and government agencies that exist in your region that address the threat of computer cyber-crimes. 

1. Identify the laws that would be effective to convict offenders.  Determine what computer crime fighting government programs exist within your region that can complement your security operations.

Research the internet for computer forensics technology that can be used by the University. 

1. Identify the types and determine the costs of technology that can be used for gathering electronic evidence, evidence from hardware, evidence from Firewalls, or cell phones.
2. Use at least four (4) 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.

The specific course learning outcomes associated with this assignment are:

• Describe federal computer-related laws and legislation.
• Explain the techniques of computer criminals and hackers.
• Describe organized crime and cyber terrorism crime.
• Evaluate and explain the various methods of computer forensics and evidentiary gathering techniques.
• Summarize the various types of computer crimes toward individuals.
• Use technology and information resources to research issues in the investigation of computer crime.
• Write clearly and concisely about computer crime investigation topics  using proper writing mechanics and technical style conventions.

Data, Information, and Organizational Knowledge

Assignment Overview

Every company has, to a greater or lesser extent, an information subsystem — that is, a means by which it gathers data, interprets it, and makes it available to employees through a distribution system. Whether we are talking about marketing information, cost projections, accounting results, or internal quality reports, every company depends on knowledge to support its planning, decision-making, and control.

So how does knowledge fit into the picture? The emergence of the field called knowledge management has highlighted some key propositions in the last 10 years or so.

All organizations are storehouses of knowledge that operate in information-rich environments made up of people and things both inside and outside the organization itself

Organizations organize, interpret, and evaluate this information to solve organizational problems

Knowledge is the primary mechanism for processing and utilizing information

People’s brains are the key knowledge resource of any organization

Codified knowledge stored in books, audio, videotapes, and computer systems can be an important knowledge resource as well

There are organizational processes and strategies for IT management and management in general. Therefore, processes and strategies in particular can significantly enhance the ability of organizations to use their knowledge resources for problem solving

Several of these themes will come up again in later modules in this course. But by way of introduction to the subject, let’s take a look at some views of how knowledge works. Read and review each of the lectures in Frost’s Knowledge Management site to gain a good understanding of KM and its relation to data, information, and knowledge. 

Frost, A. (2015). Knowledge Management. KMT An Educational KM Site. Retrieved from http://www.knowledge-management-tools.net/

Leonard, D., & Swap, W. (2005). The Knowledge Coach. HBS Working Knowledge. Retrieved from:http://hbswk.hbs.edu/item/4562.html

Case Assignment

The Case assignment for Module 1 consists of two parts. Part I introduces the notion of computer basics. Part II analyzes the Kobuku Food Company which provides an opportunity to appreciate how companies use and differentiate among data, information, and knowledge.

Part 1:

Please review the following tutorials on computer basics and answer the questions below. The tutorials are located athttp://www.gcflearnfree.org/computerbasics

1.     What are computers?

2.     Understanding Operating Systems

3.     Understanding Applications

4.     Understanding the Cloud

After watching the videos, please answer the following questions in 2-3 pages.

1.     What operating system does your computer use?

2.     What are some examples of applications residing in your personal computer?

3.     Do you use any apps or websites now that you think are cloud-based?

4.     How is a web app different from a desktop application?

Part 2:

For part II of the assignment, read the required articles and then write a 3-5 page paper answering the Kokubu case study questions. Be sure your discussion demonstrates that you understand the meanings and differences between data, information, and knowledge. In your discussion, give a real-world example of data, knowledge, and information in the context of the Kokubu Food Company.

Kokubu management has asked you to be the company consultant and prepare a management analysis of the business to help assess the firm’s current situation and future plans. To familiarize yourself with Kokubu’s background, you should review the corporate information, functions and business, and social and environmental conservation activities in the website. Particular attention must be given to the functions and business link to appreciate how IT supports Kokubu operations and knowledge management activities within the company.

Review the Kokubu website at http://www.kokubu.co.jp/english/business/ and after finding the answers to the Case questions, prepare a summary in 3-5 pages analyzing the following questions.

·         What kind of organizational trends are evident in the Kokubu case when we consider the business environment, management, and technology?

·         Discuss the IT applications to the company operations as discussed in the website.

·         Why is the company considered to be customer focused?

·         The CEO said his company “created a culture where people are addicted to data, information, and knowledge.” What does he mean by that, and what are the benefits and drawbacks of such a culture?

As a reminder, you must have at least two outside scholarly references when you write cases.

Assignment Expectations

1.     Include Part I and Part II of the Case in one document, properly labeling each section.

2.     The Case assignment should be 5-8 pages in total excluding cover page and reference list.

Your assignments will be graded following these expectations:

·         Precision: the questions asked are answered.

·         Clarity: Your answers are clear and show your good understanding of the topic.

·         Breadth and depth: The scope covered in your paper is directly related to the questions of the assignment and the learning objectives of the module.

·         Critical Thinking: It is important to read the “required readings” posted in the background material plus others you find relevant. Your paper should include important concepts from these readings and incorporate your reactions and examples that illustrate your reflective judgment and good understanding of the concepts.

·         Your paper meets the page requirements, excluding the cover page or the references pages.

I am working on this homework using MYSQL database. Can you help. Attached is the homework question. 

Here is the scripts am using for the question. 

/* Database Systems, 9th Ed., Coronel/MOrris/Rob */
/* Type of SQL : MySQL */

CREATE SCHEMA TINY_VIDEO;

USE TINY_VIDEO;

/*Create table price*/
CREATE TABLE price
(price_id        INTEGER     PRIMARY KEY AUTO_INCREMENT,
 description     VARCHAR(20) NOT NULL,
 rental_fee      DECIMAL(5,2),
 daily_late_fee  DECIMAL(5,2));


/*Insert data into price*/
INSERT INTO price VALUES(1,'Standard',2.5,1);
INSERT INTO price VALUES(2,'New Release',4.0,3);
INSERT INTO price VALUES(3,'Discount',2.0,1);
INSERT INTO price VALUES(4,'Weekly Special',1.5,.5);


/*Create table movie*/
CREATE TABLE movie
(movie_id       INTEGER     PRIMARY KEY AUTO_INCREMENT,
 title          VARCHAR(75) NOT NULL,
 year_released  INTEGER,
 cost           DECIMAL(5,2),
 genre          VARCHAR(50),
 price_id       INTEGER,
 FOREIGN KEY(price_id) REFERENCES price(price_id));

/*Insert data into movie*/
INSERT INTO movie VALUES(1234,'The Cesar Family Christmas',2007,39.95,'FAMILY',2);
INSERT INTO movie VALUES(1235,'Smokey Mountain Wildlife',2004,59.95,'ACTION',3);
INSERT INTO movie VALUES(1236,'Richard Goodhope',2008,59.95,'DRAMA',2);
INSERT INTO movie VALUES(1237,'Beatnik Fever',2007,29.95,'COMEDY',2);
INSERT INTO movie VALUES(1238,'Constant Companion',2008,89.95,'DRAMA',NULL);
INSERT INTO movie VALUES(1239,'Where Hope Dies',1998,25.49,'DRAMA',3);
INSERT INTO movie VALUES(1245,'Time to Burn',2006,45.49,'ACTION',3);
INSERT INTO movie VALUES(1246,'What He Doesn''t Know',2006,58.29,'COMEDY',1);


/*Create table video*/
CREATE TABLE video
(video_id       INTEGER PRIMARY KEY AUTO_INCREMENT,
 purchase_date  DATE,
 movie_id       INTEGER,
 FOREIGN KEY(movie_id) REFERENCES movie(movie_id));

/*Insert data into video*/
INSERT INTO video VALUES(54321,'2008-06-18',1234);
INSERT INTO video VALUES(54324,'2008-06-18',1234);
INSERT INTO video VALUES(54325,'2008-06-18',1234);
INSERT INTO video VALUES(34341,'2007-01-22',1235);
INSERT INTO video VALUES(34342,'2007-01-22',1235);
INSERT INTO video VALUES(34366,'2009-03-02',1236);
INSERT INTO video VALUES(34367,'2009-03-02',1236);
INSERT INTO video VALUES(34368,'2009-03-02',1236);
INSERT INTO video VALUES(34369,'2009-03-02',1236);
INSERT INTO video VALUES(44392,'2008-10-21',1237);
INSERT INTO video VALUES(44397,'2008-10-21',1237);
INSERT INTO video VALUES(59237,'2009-02-14',1237);
INSERT INTO video VALUES(61388,'2007-01-25',1239);
INSERT INTO video VALUES(61353,'2006-01-28',1245);
INSERT INTO video VALUES(61354,'2006-01-28',1245);
INSERT INTO video VALUES(61367,'2008-07-30',1246);
INSERT INTO video VALUES(61369,'2008-07-30',1246);


/*Create table membership*/
CREATE TABLE membership
(membership_id INTEGER     PRIMARY KEY AUTO_INCREMENT,
 first_name    VARCHAR(30) NOT NULL,
 last_name     VARCHAR(30) NOT NULL,
 street        VARCHAR(120),
 city          VARCHAR(50),
 state         VARCHAR(2),
 zip           VARCHAR(5),
 balance       DECIMAL(10,2));

/*Insert data into membership*/
INSERT INTO membership VALUES(102,'Tami','Dawson','2632 Takli Circle','Norene','TN','37136',11);
INSERT INTO membership VALUES(103,'Curt','Knight','4025 Cornell Court','Flatgap','KY','41219',6);
INSERT INTO membership VALUES(104,'Jamal','Melendez','788 East 145th Avenue','Quebeck','TN','38579',0);
INSERT INTO membership VALUES(105,'Iva','Mcclain','6045 Musket Ball Circle','Summit','KY','42783',15);
INSERT INTO membership VALUES(106,'Miranda','Parks','4469 Maxwell Place','Germantown','TN','38183',0);
INSERT INTO membership VALUES(107,'Rosario','Elliott','7578 Danner Avenue','Columbia','TN','38402',5);
INSERT INTO membership VALUES(108,'Mattie','Guy','4390 Evergreen Street','Lily','KY','40740',0);
INSERT INTO membership VALUES(109,'Clint','Ochoa','1711 Elm Street','Greenville','TN','37745',10);
INSERT INTO membership VALUES(110,'Lewis','Rosales','4524 Southwind Circle','Counce','TN','38326',0);
INSERT INTO membership VALUES(111,'Stacy','Mann','2789 East Cook Avenue','Murfreesboro','TN','37132',8);
INSERT INTO membership VALUES(112,'Luis','Trujillo','7267 Melvin Avenue','Heiskell','TN','37754',3);
INSERT INTO membership VALUES(113,'Minnie','Gonzales','124 6th Street West','Williston','ND','58801',0);


/*Create table rental*/
CREATE TABLE rental
(rental_id     INTEGER PRIMARY KEY AUTO_INCREMENT,
 rental_date   DATE,
 membership_id INTEGER,
 FOREIGN KEY(membership_id) REFERENCES membership(membership_id));

/*Insert data into rental*/
INSERT INTO rental VALUES(1001,'2009-03-01',103);
INSERT INTO rental VALUES(1002,'2009-03-01',105);
INSERT INTO rental VALUES(1003,'2009-03-02',102);
INSERT INTO rental VALUES(1004,'2009-03-02',110);
INSERT INTO rental VALUES(1005,'2009-03-02',111);
INSERT INTO rental VALUES(1006,'2009-03-02',107);
INSERT INTO rental VALUES(1007,'2009-03-02',104);
INSERT INTO rental VALUES(1008,'2009-03-03',105);
INSERT INTO rental VALUES(1009,'2009-03-03',111);


/*Create table detailrental*/
CREATE TABLE detail_rental
(rental_id      INTEGER,
 video_id       INTEGER,
 fee            DECIMAL(5,2),
 due_date       DATE,
 return_date    DATE,
 daily_late_fee DECIMAL(5,2),
 PRIMARY KEY(rental_id, video_id),
 FOREIGN KEY(rental_id) REFERENCES rental(rental_id),
 FOREIGN KEY(video_id)  REFERENCES video(video_id));

/*Insert data into dailyrental*/
INSERT INTO detail_rental VALUES(1001,34342,2,'2009-03-04','2009-03-02',1);
INSERT INTO detail_rental VALUES(1001,61353,2,'2009-03-04','2009-03-03',1);
INSERT INTO detail_rental VALUES(1002,59237,3.5,'2009-03-04','2009-03-04',3);
INSERT INTO detail_rental VALUES(1003,54325,3.5,'2009-03-04','2009-03-09',3);
INSERT INTO detail_rental VALUES(1003,61369,2,'2009-03-06','2009-03-09',1);
INSERT INTO detail_rental VALUES(1003,61388,0,'2009-03-06','2009-03-09',1);
INSERT INTO detail_rental VALUES(1004,44392,3.5,'2009-03-05','2009-03-07',3);
INSERT INTO detail_rental VALUES(1004,34367,3.5,'2009-03-05','2009-03-07',3);
INSERT INTO detail_rental VALUES(1004,34341,2,'2009-03-07','2009-03-07',1);
INSERT INTO detail_rental VALUES(1005,34342,2,'2009-03-07','2009-03-05',1);
INSERT INTO detail_rental VALUES(1005,44397,3.5,'2009-03-05','2009-03-05',3);
INSERT INTO detail_rental VALUES(1006,34366,3.5,'2009-03-05','2009-03-04',3);
INSERT INTO detail_rental VALUES(1006,61367,2,'2009-03-07',NULL,1);
INSERT INTO detail_rental VALUES(1007,34368,3.5,'2009-03-05',NULL,3);
INSERT INTO detail_rental VALUES(1008,34369,3.5,'2009-03-05','2009-03-05',3);
INSERT INTO detail_rental VALUES(1009,54324,3.5,'2009-03-05',NULL,3);
INSERT INTO detail_rental VALUES(1001,34366,3.5,'2009-03-04','2009-03-02',3);