This assignment requires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks.

/in /by

This assignment requires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks.

admin January 7, 2018 0

Task
NOTES
This assignment requires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks.
For guidance on how to install SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=9ynCDVg54H0
For guidance on how to create tables using SQLite, watch this short YouTube video: https://www.youtube.com/watch?v=kij5lPw0F-o
Typing the SQL statements or the results is NOT acceptable.
Instructions for using SQLite:
From Resources under Main Menu in Interact 2 go to Assignment 5 Folder
Copy sqlite3.exe and cmd.exe files from the Assignment 5 Folder into a folder in your machine
Copy a5.txt from the Assignment 5 Folder into the folder in your machine where your SQLite file is located
From the SQLite Command Prompt execute the a5.txt script. To do this, 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 .headers on
At the SQLite Command Line type .mode column
Assignment 5 tasks: each query is worth 5 marks
Write and run SQL statements to complete the following tasks
Part A – DML
Locate the record in the vendor table that does not have a value for the attribute V_STATE
Find the customers whose balance is greater than $300 but less than $400.
Show the names of the customers for whom we have invoices.
What is the max balance?
Show the CUS_CODE of the customers for whom we DO NOT have invoices.
Show the names of the customers for whom we DO NOT have invoices.
Find out how many times a customer generated an invoice – make sure the counted column heading reads “Invoices_generated”.
List the names of the customers and how many times a customer generated an invoice – make sure the counted column heading reads “N_Of_Invoices” .
Part B – DDL
Add a new row/record to the `customer` table to include your actual student_ID in the CUS_CODE, your last_name as the CUS_LNAME` and your firstname as CUS_FNAME. Add any other details of your choice in all the other fields.
Add a new attribute (field) credit_history VARCHAR(6) to the customer table.
Update credit_history for customer ‘10011’ to ‘Bad’.
Delete the employee Leighla Genkazi from the EMP table.
Add a new attribute called ‘email_address’ to ‘emp’ table with data type and length ‘VARCHAR(20).
You are required to submit:
The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line, SQLite will output your SQL statement with the results of the query making it easy to copy and paste both.
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

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post This assignment requires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks. appeared first on homework handlers .

What general procedures or rules govern a typical arbitration proceeding?

/in /by

Question
Case Three: Big Brain Solutions
Big Brain Solutions is a Colossal subsidiary in the consulting industry, located in Silicon Valley.

Early in 2014, Liz Bennett and Ralph Nickleby each applied to become administrative assistants at Big Brain Solutions. After successfully completing the interview process, both were hired and asked to sign contracts that contained the following provision: “If there is any dispute as to employment practices or employee/employer actions, this dispute will be decided via binding arbitration.” Both Liz and Ralph signed their contracts after being given ample time to review them and to consult an attorney if they wished to do so.

Several months after he was hired, Ralph became addicted to cocaine. Around the same time, Liz became pregnant with her first child. When Liz experienced complications during her pregnancy, Big Brain initially agreed to grant her medical leave; but shortly thereafter, the company informed Liz that her position had been eliminated due to a “reorganization.”

Fearing that Ralph might have trouble picking up the slack for the recently released Liz, Big Brain asked him to take a surprise drug test. Ralph was confused and alarmed and refused to take the test. Big Brain informed him that he was fired because of his refusal to take the test.

Liz decided to file a lawsuit in state court under the state and federal Family and Medical Leave Acts, which guarantee pregnant women a set number of weeks off for pregnancy. Ralph, on the other hand, submitted his case to an arbitrator.

Your task is to determine whether either Liz or Ralph’s grievances could be heard by a court, and explain the reasons why or why not. Furthermore, you must determine what the likely outcomes will be if these cases are decided by an arbitrator. Communicate your findings to the vice president via memo.

What general procedures or rules govern a typical arbitration proceeding?
Can a company force an employee to use arbitration (instead of a lawsuit) to settle an employment-related dispute because of a contract provision?
Are there times when an arbitration clause might be invalid or unenforceable against an employee?
What effect do claims based on specific federal or state laws have on arbitration provisions in employment contracts?

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post What general procedures or rules govern a typical arbitration proceeding? appeared first on homework handlers .

Did your “test result” match what you thought were your political beliefs?

/in /by

Assignment 1: Political Belief Profile
The relationship between public opinion and political participation raises many questions associated with how the public thinks, why they behave in the manner they do, and what outcomes in the form of ideological expressions will probably take place because of citizens’ behavior in the political scenario. Essentially, “who, what, and where” issues again surface in response to evaluation of political socialization.
Political socialization may be expressed in a singular way, depending on the issue of concern, but it is not derived from any single impact throughout the life of American voters and nonvoters. Qualities and conditions such as gender, race, economic status, education, and religion impact voter behaviors. Indeed, whether or not an individual votes, or takes part in any of the varied available options for participation, is closely allied with the political socialization of individuals and even entire socioeconomic groups.
The Political Compass Web site (http://www.politicalcompass.org) offers a self-test that helps you analyze your personal political views on what the test authors call a “left–right” scale. Take the test and review your results to see where you stand on the economic scale and the social scale. Discuss the results using the following questions:

Did your “test result” match what you thought were your political beliefs?
What is “politically correct” thinking? Give examples of what might be considered “politically correct” and “politically incorrect.
To what degree do you think your values and beliefs represent the norms, values, and traditions of society? Define your answer using the following Likert scale—extremely common, common, moderately common, uncommon, and extremely uncommon.

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post Did your “test result” match what you thought were your political beliefs? appeared first on homework handlers .

List and discuss the organization’s strategic objectives.

/in /by

At the end, you should have a workable training program in place to address a theoretical organizational performance deficiency. Application of your creative skills is necessary as you will craft an organization for which you will develop a training module to address a fault in performance of operations that has resulted in a gap between actual organizational performance (AOP) and expected organizational performance (EOP). The deficiency could manifest itself in profitability shortfalls, low levels of customer satisfaction, excessive waste of materials, etc.

Parameters: Part 1 You are required to provide an overview of a company (real or one you create) in approximately 750 words:
· Identify a company of your choice (or create one) and provide background information on the organization (type of company, products, services, location, number of employees, etc.).
· Discuss the organization’s mission and vision statements.
· List and discuss the organization’s strategic objectives.
· Discuss the issues that led up to the triggering events and the resulting need.
· Explain how HR and the training unit will work together to ensure that the training program is launched.
Please ensure that the following APA formatting standards are applied:
· APA formatted title page.
· Introduction with a clearly identified thesis statement.
· APA formatted headings for each key element presented.
· APA formatted in-text citations.
· Conclusion summarizing key points presented and a recommendation or solution.
· APA formatted reference page.
Tips….
· Address each identified section
· Include reference(s) and citation(s)
· Length is no less than 750 words
· Rules of grammar, spelling, word usage and punctuation are followed
· Used APA style and format–one inch margins, second headings, double space, title page, reference page
· Include a conclusion which summarizes key points
· Include an introduction which clearly establishes your thesis
RUBICS:
All key elements of the assignment are covered in a substantive way. The content is comprehensive, accurate, and persuasive. The paper links theory to relevant examples and uses the vocabulary of the theory correctly. Major points are stated clearly, are organized logically, and are supported by specific details, examples, or analysis. The paper provides at least two scholarly references, in addition to reliable sources of information. The introduction provides sufficient background on the topic and previews major points. The conclusion is logical, flows from the body of the paper, and reviews the major points. Paragraph transitions are present, logical, and maintain the flow throughout the paper. The tone is appropriate to the content and assignment. All sentences are complete, clear, and concise. The paper, including the title page, reference page, tables, and appendixes, follows APA formatting guidelines. Citations of original works within the body of the paper follow APA guidelines. Rules of grammar, usage, and punctuation are followed. Spelling is correct. In the context of human resources, this student’s submission is well above average, displays professional competence in most or all areas of the task, and would be useful and understood as proficient.

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post List and discuss the organization’s strategic objectives. appeared first on homework handlers .