Case2,situstion 1

Case 2: Databases

Create a DB based on the following:

A pet store lets customers choose and pay for their pets via their web site. Customers pay using either a credit card or a PayPal account. A Paypal account number starts with PP and is follow by a maximum of 12 numbers. For credit cards, only Visa and MasterCard are accepted. Cash is not accepted. The store sells many kinds of animals and breeds, including some exotic species which require the purchaser to have a special licence. If needed, the customer's license number will be collected along with the financial details when he places and order. the licence number is 2 digit number followed by four letters. The law requries the store to produce a list of all exotic species sold during the last month.

The Society of Animal Welfare requires all pet shops to provide a weekly report detailing the health condition of all pets under their care. Pet shops are subject to random inspections and face a large fine if they cannot produce this report. Becuase of this, eah individual animal needs to be tracked. Pets are supplied by a variety of different companies. Ussually one company supplies multiple types of animals. The store uses several queries to check on its business. Each week the manager checks to see the sales for the past week. Occasionally he also checks the sales from the past six months. In the future, he would like to have these same reports group the sales by species of animal.

 Case 2 Database.accdb

Analysing ITGS Situations 1

Instructions: Use the following template to analyze news articles for your ITGS class.

News article title: How hackers can switch on your webcam and control your computer

URL: http://www.smh.com.au/digital-life/consumer-security/how-hackers-can-switch-on-your-webcam-and-control-your-computer-20130328-2gvwv.html#ixzz2PJunxebp

Brief description of situation: A malicious virus known as Remote Administration Tools (RATs) can be used by hackers to switch on your webcam and control the machine without your knowledge.

Key stakeholders: hackers,users,companies.

Related issues of social and ethical significance:

1.1 Reliability and integrity, 1.2 Security, 1.3 Privacy and anonymity, 1.4 Intellectual property, 1.5 Authenticity, 1.6 The digital divide and equality of access, 1.7 Surveillance, 1.8 Globalization and cultural diversity, 1.9 Policies, 1.10 Standards and protocols, 1.11 People and machines and 1.12 Digital citizenship

Areas of social impact:

Economic because people will stop buying things, in internet and the companies will lose some money political the news will tell to the government that how the government cant catch this people, legal because they breaking private stuff and they breaking the law  and morally people will stop using the internet.

Evaluating the impacts:

Are the impacts serious? This is very serious because the people will stop using Internet Are they long or short term? This are long term because its not the first time Are all the stakeholders affected of just a few? All the stakeholders are affected because is like a change if some one is affected all the others will be Are the stakeholders a large or small group? Are large groups because are big companies like Google, etc, Are the impacts local or global? Global this problem is international Are the impacts likely to lead to future problems? Yes, because if they cannot catch them they will continue

Conclusion:

Who is responsible? For the action are the hackers and the fend this are the government What are the consequences? People will stop using Internet What are the alternatives? Stop the hackers Is there an easy solution to the problem? The government’s should make this stop because is affecting the people