Author: chris

Write and run SQL statements to complete the following tasks to Locate the record in the vendor table that does not have a value for the attribute V_STATE

Assessment item 5

Query and update databases using SQL

Value: 15%

Due date: 08-Oct-2015

Return date: 30-Oct-2015

Submission method options

Alternative submission method

Task

NOTES

  • This assignment encourages you to use SQLite to complete the tasks listed below.
  • The instructions listed below relate to SQLite.
  • For guidance on how to install SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=YZQuQ6jael8
  • For guidance on how to create tables using SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=Ev2JnjavvmE
  • You are welcome to use MySQL. The instructions for using MySQL will be placed in the Students Resources Folder.
  • To use other packages, please seek the approval of your subject coordinator.
  • Typing the SQL statements or the results is NOT acceptable.

Instructions

From Resources under Main Menu in Interact 2 go to Students Resources Folder

Copy sqlite3.exe and cmd.exe files from the Students Resources Folder into a folder in your machine

 

Copy a5.txt from the Students Resources Folder into the folder in your machine where your SQLite file is located

 

Open a5.txt in Notepad

 

Replace yourstudentid in line .output yourstudentid.txt in a5.txt with your actual studentid i.e. for example 45446667.txt

 

From the Command Prompt type sqlite3.exe yourstudentid.db

 

Note: From the Command Prompt call the folder in your machine where your SQLite file is located before you type sqlite3.exe yourstudentid.db

 

At the SQLite Command Line type .read a5.txt [to create the tables you will use to answer this assignment’s questions]

 

At the SQLite Command Line type .quit

 

Using WordPad open yourstudentid.txt [to check the tables you created exist]

 

From the Command Prompt type sqlite3

 

At the SQLite Command Line type .open yourstudentid.db

 

At the SQLite Command Line type .headers on

 

At the SQLite Command Line type .mode column

 

Write and run SQL statements to complete the following tasks

 

  1. Show all the details of the products by v_code 21344
  2. Locate the record in the vendor table that does not have a value for the attribute V_STATE
  3. Find the customers whose balance is greater than 200 but less than 300.
  4. What is the max balance?
  5. Show the names of the customers for whom we have invoices.
  6. Show the CUS_CODE of the customers for whom we DO NOT have invoices.
  7. Show the names of the customers for whom we DO NOT have invoices.
  8. Find out how many times a customer generated an invoice.
  9. List the names of the customers and how many times a customer generated an invoice.
  10. Add a new attribute (field) credithistory varchar(6) to the customer table.
  11. Update credithistory for customer ‘10011’ to ‘Bad’.
  12. Delete the employee Leighla Genkazi from the EMP table.

 

You are required to submit:

 

  1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file
  2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file

 

 

 

Rationale

This assignment will assess your knowledge and ability to use SQL to query database tables and update them. It will also test your ability to write both simple and complex queries and run those queries to return the requested data.

Marking criteria

The following criteria will be used to assess Assignment 5:

 

Task HD DI CR PS
Write and run SQL statements to complete tasks 1-12 above The SQL statements retrieve or update the required information for all assignment tasks using concise, correct and free of errors SQL syntax that The SQL statements retrieve or update the required information for most of theassignment tasks using correct and free of errors SQL syntax

 

 The SQL statements retrieve or update the required information for some of theassignment tasks using mostly correct SQL syntax The SQL statements retrieve or update the required information for only a few of theassignment tasks using SQL syntax that contains frequent errors

Using the categories presented in chapter two (2) of the textbook, categorize the type of modern attack(s) or computer crime(s) that were committed in this case.

Case Study 1: Keylogger Scam

Read the article titled: “Police Foil $420 Million Keylogger Scam” found on the eWeek.com Website located at http://www.eweek.com/c/a/Security/Police-Foil-420-Million-Keylogger-Scam/

Write a 3-4 page paper in which you:

  1. Give an example of the measures, you believe, the government or society can implement to deter these types of crimes.
  2. Using the categories presented in chapter two (2) of the textbook, categorize the type of modern attack(s) or computer crime(s) that were committed in this case.
  3. Identify the technologies that exist to deter or reduce the threat of these types of computer crimes, and determine the effectiveness of these technologies to deter this specific crime.
  4. Summarize similar success stories by similar government agencies within the U.S. and include the criminals that were caught, the agencies (if any) that were involved, and the sanctions or charges the criminals faced.
  5. 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:

  • Compare and contrast the various types of computer crime.
  • Describe the different types of computer attacks.
  • Evaluate the ethical concerns that computer crimes raise in society and the impact of information technologies on crime, terrorism, or war.
  • 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.

Examine the concept of risk and return as it applies to financial instruments. Determine the relationship between the two (2) and whether or not the relationship between risk and return always holds true. Provide a rationale for your response.

Go to Yahoo! Finance’s Website, located at http://finance.yahoo.com/. Select a publicly traded company in which you are interested, and figure out its symbol (e.g.: Apple-AAPL). Insert the company symbol into the search bar on the left-hand side where it reads “Quote Lookup” and click “Go”. Once on the stocks trading page, look for the vertical blue menu on the left of the page. Scroll down to “COMPANY,” click on the link titled “Key Statistics,” and review basic financial metrics for the chosen company. Discuss two (2) key financial metrics used by investors to evaluate the riskiness of a stock. Select the financial metric that you would be most likely to use and explain your reasoning. Support your selection with one (1) real-world example.

  • Examine the concept of risk and return as it applies to financial instruments. Determine the relationship between the two (2) and whether or not the relationship between risk and return always holds true. Provide a rationale for your response

How can we predict the next financial crisis?

finance questions

[Pin It]

Answer each of the 8 numbered items in at least 100 words each with references.

1. Patent valuation, foreign exchange risk and time value of money

2. regulators should check their biases

3. financial decision making and role of regulatory bodies

4. how data will transform business

5. profits not always the point

6. how can we predict the next financial crisis

7. the four income statements

8. a complete ratio analysis

What are the socio-psychological conditions that create the environment of false confessions?

  1. Why do people confess to crimes they did not commit?
  2. What are the socio-psychological conditions that create the environment of false confessions?
  3. What is the value of DNA evidence in false confessions cases?
  4. Why does the author, Leo, in his article believe that the Miranda rights do not protect innocent people?
  5. After reading the two cases, why did the defendants falsely confess to crimes they did not commit?

Define middle class measuring rod and reaction formation? How do these contribute to the formation of delinquent subcultures?

  1. Define the culture of poverty.

     

     

     

     

  2. How do Messner and Rosenfeld define the American Dream? How is it criminogenic?

     

     

     

     

     

  3. What is relative deprivation? Provide an example.

     

     

     

     

     

  4. Define middle class measuring rod and reaction formation? How do these contribute to the formation of delinquent subcultures?

     

     

     

     

     

     

  5. How was social structure theory used to inform policy in the Kennedy and Johnson Administrations?

Briefly describe the issue and explain how this is an issue which affects the common good.

The aim of this task is to define the common good in relation to this topic. The common good is what is best for all, as opposed to the particular goods that each stakeholder may pursue. Your response should analyse the various perspectives and critique these using relevant principles of human flourishing, in order to show how the common good might be achieved.

 

Choose one of the two Hot Topics and three of the perspectives represented by the major stakeholders in the issue.

 

Structure your essay according to the following framework (word count is given as a guide only):  Briefly describe the issue and explain how this is an issue which affects the common good. (200 words) (criterion 1) (INTRODUCTION)

 Describe and explain the perspectives of three stakeholders. Include a discussion of the main arguments they put forward and the resolution/s they would opt for. (700 words) (criterion 2)

 Choose three principles of human flourishing that are relevant to this issue. Use these principles to analyze each perspective you described above and discuss the ways in which the perspectives of these stakeholders support or hinder the common good. (800 words). (criterion 3)

 How might the common good be achieved in relation to this issue? Suggest a specific course of action and explain how this would best serve the common good. Include a proposal for what each stakeholder could do and what society as a whole could do to promote the achievement of the common good in relation to this issue. (300 words) (criterion 4) (CONCLUSION

Document how your proposed architecture maps to the intended deployment environment with a deployment diagram showing how your functional and technical components will be distributed over hardware nodes.

1. System Wide (Non-Functional) Requirements Fill templated

2. Architecture Notebook  Fill templates

 

3. Component Diagram

Document your proposed architecture with a high level logical view showing functional and

technical components in a component diagram.

4. Deployment Diagram

Document how your proposed architecture maps to the intended deployment environment with a deployment diagram showing how your functional and technical components will be distributed over hardware nodes.

hat Really Happened in the Boston Massacre?

Discussion Section Week 5:

Discovering the American Past, Chapter 4

What Really Happened in the Boston Massacre? The Trial of Captain Thomas Preston

 

1-Page response paper due at the beginning of discussion section. Double-Spaced, use one-inch margins, and 12 point Times New Roman font. Write on the following prompt:

 

The British Empire had just finished fighting the costly Seven Years’ War with the French, racking up massive debts. To pay off these debts the British imposed a series of taxes on the Colonists. While the British viewed this as fair for defending the Americans from French attacks in Canada, the Americans viewed this as too heavy a burden. In order to enforce these taxes the British continued to send more troops and overseers into New England, which enraged many Americans, who were accustomed to nearly autonomous governing. This tension would cause the deaths of five Bostonians in a scuffle with a British garrison.

 

Your assignment is to argue what you think actually happened. Were Captain Preston and his men just defending themselves? Or did they fire into an unarmed or at least mostly harmless crowd? To do this, identify two witnesses’ testimonies which you believe are accurate, and two witnesses who you believe are inaccurate. Pay attention to how close the witnesses are to the actual scene. Pay attention to multiple accounts of the same incident. The closer they are and the more witnesses back up the same story the more reliable it is. Using their testimony, tell us what really happened at ‘The Boston Massacre

Suggest at least three (3) changes that can be made to prevent medication errors due to interruptions.

Scenario: The monthly report on medication errors was presented to all units within ECHO Hospital. Although the rate has decreased, staff identified that the primary cause of medication errors continues to be interruptions while preparing and administering medications.

The nurse manager has asked the staff members to offer assistance in solving the problem of preventing interruptions while RNs are preparing and giving medications.

Using the assigned readings, information from the literature and the above scenario, your knowledge of the, principles of safe medication administration create a discussion post in response to the following:

  • Suggest at least three (3) changes that can be made to prevent medication errors due to interruptions.
  • Select one (1) suggested change and write an outcome statement (realistic, measureable and contains a time frame).
  • Select one (1) suggested change and outline the steps that would be taken to implement it.
  • Describe how the selected change will be evaluated to determine its effectiveness in achieving your stated measurable outcome.

APA FORMAT NO MORE THAN A PAGE IF POSSIBLE ITS JUST A DISCUSSION> NEEDS AT LEAST 2 REF WITHIN 5 YEARS .. THANKS….

 

Journal Articles: