Do employers have a responsibility to alert other employers to an employee’s wrongdoing by supplying an unfavorable reference? Why or why not? Discuss the conflict between community responsibility and self-protection.
Assignment 3
Pine Valley Furniture Corporation
Due: October 3
This assignment is built around the Pine Valley Furniture Corporation case from the textbook.
Download the files PVFC_description.docx and PVFC.zip, available under the tab Software Workshops on the Blackboard site for the course.
Review the description of the PVFC application.
Create and populate the tables for PVFC in a schema on Oracle. You can use an existing schema or create a new schema.
Extract files from PVFC.zip to a convenient folder.
⦁ Use the script CREATEBIGPV.sql to create tables and constraints .
⦁ Use the script LOAD1BIGPV.sq to enter data into tables except for the three table mentioned below.
⦁ Use Data-> Import in SQL Developer to load data into table RAWMATERIAL_T from file RawMaterial.csv
⦁ Use Data-> Import in SQL Developer to load data into table SUPPLIES_T from the file Supplies.csv
⦁ Use Data-> Import in SQL Developer to load data into table USES_T from the file Uses.csv
Note that because of referential integrity constraints data in the table SUPPLIES_T can be entered only after a successful execution of the script LOAD1BIGPV. Similarly, tables RAWMATERIAL_T and SUPPLIES_T must be populated before we can enter data in table USES_T.
Examine properties of individual tables. Make yourself familiar with column names.
Practice building SQL queries for exercises 5-57 through 5-93 on pages 246-248. Some the queries will be very simple , some will require determining aggregates, some will require you to find additional date functions in Oracle. More you practice, better you will become at developing SQL statements.
Work to submit
⦁ Add rows to tables.
Provide values for all fields, making sure that values correspond to data types for the individual columns. You can view column names their types under the Columns tab in the worksheet for a table. To insert a row, use the Data tab. Click on the third button to create a blank row at the bottom of the table. Click on the fifth button to make changes permanent. From the message log copy the corresponding SQL statement that was executes in response to insert and commit steps.
⦁ Insert a row in table Customer_T, with Customer ID =27 and Customer Name as your own name and address as 140 West 62nd Street, New York, NY 10023.
⦁ Associate the new customer with Northeast territory by entering a row in table Does BusinessIn_T.
⦁ Insert a row in CustomerShip Address_T to provide a shipping address for the new customer as 9999 Broadway, New York, NY 10025. Use Ship AddressID as 35.
⦁ Enter an order for the new customer in table Order_T. Use OrderID=93, Sales PersonId = 3, the current date as the order date and null as fulfillment date.
⦁ For the OrderID=93, enter a row in table Order Line_T for an order of two units of ‘Oak Computer Desk’ (ProductID=3) and an order of one unit of ’48 Bookcase’ with finish ‘Oak’ (ProductID=8).
⦁ Modify tables
⦁ Modify table Product_T as specified in exercise 5-57 and test your change by entering data as specified in exercise 5-58.
⦁ Write SQL query to retrieve all columns for all products from modified table Product_T. Include the SQL query and the first five rows in the write-up.
⦁ Submit queries and resulting tables for the following for the problems with modifications as noted:
⦁ Find all orders for customers in Northeast territory that have not yet been filled
Assignment Content
For this assignment, you will use class activities from Sessions 3 and 4 to turn in a 1st Half Draft of your New Product or Service Leadership Plan. Study template and New Product or Service Leadership Plan examples as posted.
Make sure APA formatting, grammar, references, and fluency are clear.
Include a cover page, abstract, in-text citations, and reference page.
Use credible sources, which may include government websites, book chapters, and the minimum number of peer-reviewed articles.
Create an outline with headings and subheadings from the following areas described in the syllabus (APA format):
New Product or Service Leadership Plan
o Introduction to New Product or Service (minimum 2 sources)
o Methodology Leadership (minimum 3 sources, 2 scholarly)
o Plan (minimum 3 sources, 1 scholarly)
o Assignment Format: MSWord
o Submission Format: APA paper
o Length: 4 – 5pages (excluding cover and references)
Citations Required: minimum eight professional or scholarly sources (at least 3 scholarly)
Note: All the required materials have been sent already and attached to the ITM 530 – Leadership in Information Technology – Session 3 – Assignment Part 2
Assignment Instructions for Part-I:
following the article:
Title: “Drive Innovation with Better Decision-Making.”
Author: Linda A Hill, Emily Tedards, Taran Swan
Date of Publication: November–December 2021
Published: Harvard Business Review
Assignment Question(s):
Part-I
Read the article titled as “Drive Innovation with Better Decision-Making.” by Linda A Hill, Emily Tedards, and Taran Swan published in Harvard Business Review, and answer the following Questions:
Summarize the article and explain the main issues discussed in the article. (In 500-600 words)
According to the article, why we should focus on Decision-Making? Discuss in relation with the text you learnt in the course. Use additional reference to support your argument. (In 400-500 words)
Part-II- Critical Thinking Question
“Decision making is the process of making choices by identifying a decision, gathering information, and assessing alternative resolutions.” Explain the statement with example (Words 400-500) Answers
Answer-
Answer-
Answer-
Answer
Discussion
1.Watch the short video in the following link:
Develop Alternatives: https://youtu.be/wyILlakKXiM
(Question):
Discuss the four essential elements of developing alternatives with example.
2.Read the following statement:
Built-in obsolescence means designing products that will degrade over time or otherwise need to be replaced. Many products depend on built-in obsolescence to ensure sales, such as light bulbs, batteries, and electronic devices.
(Question):
Do you think selling products with built-in obsolescence is an ethical way to do business?
3.Read the following statement:
“Critical thinking is the opposite of creative thinking.”
(Question):
Do you agree? Provide examples of why you agree or disagree.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
1.What is public administration? 150
2.What are the main elements of public administration. 200
3.What do you understand by human resource management?150
4.What are the various concepts associated with human resource management?200
5. Do changing regional aspirations create a large number of problems in establishing effective intergovernmental relationships”? 200
Learning Outcomes:
1.Define the fundamental theories of public sector management. (LO1.1)
2.Describe the simple and complex issues pertaining to public management (LO1.2)
Assignment Question(s)(Marks 15)
Part 1
Part 2
“Managing Human Resources is critical in changing the role of the State and public sector policies”. In light of this discuss the role of human resource management for effective public administration.
Limit your answer to about 500 words. (5 Marks).
It is mandatory to include at least two scholarly journal articles in your answer.
Read the case “Goldman Sachs” from Chapter 5 “STRESS ” Page: – 149 given in your textbook – Organizational behaviour: Improving performance and commitment in the workplace (7th ed). by Colquitt, J. A., LePine, J. A., & Wesson, M. J. (2021) and Answer the following Questions:
Assignment Question(s):
Define different perspectives and knowledge of process-flow analysis, process design solutions, lean system, quality controls, Inventory control system and green systems.
Apply knowledge and skills to optimize production objective of maximizing profits using qualitative and quantitative techniques in related areas of operations management
Quality plays a very vital and important role in any project whether it be a manufacturing or service industry not only to increase market share but also to avoid accidents. At its simplest, quality means meeting the intended purpose. Quality is also known as ‘fit for use.’ Quality products meet the stated requirements, have tolerable levels of defects, and are consistently produced. In short, quality means accurate (correct) and precise (consistent) results within a project.
Quality improvement is the framework used to systematically improve care. Quality improvement seeks to standardize processes and structure to reduce variation, achieve predictable results, and improve outcomes for patients, healthcare systems, and organizations.
Q1. What are dimensions of a product quality? (5 Marks)
Q2 How the quality of the Product can be improved? Discuss its cycle. (5 Marks)
Q3. What are different types of Quality through which customer satisfaction and fitness for use can be ensured? (5 Marks)
Answer the following three questions they all count equally. Use the assigned material and any other written sources you wish. Make certain to cite every source by a recognized system of citation. Failure to cite sources will result in severe grading penalties, citing from Wikipedia is not recommended. You will prepare this in a word document and submit it in a drop box. I don’t grade for length but strong answers supported by examples and reasoning beyond simply repeating what the materials state will generally run 1. Page by question.
1) What are the types of intellectual property and give examples of each type
2) Explain how intellectual property can be used offensively and defensively give examples but not from the Chevron Unocal case discussed in legal environment.
3) Explain how you believe the company you have chosen for your project (obviously you will tell me the name of the company in the answer) can be manage their intellectual property portfolio in both offensive and defensive ways to protect their enterprise Halliburtion energy service will be the chosen company for this project
Our team has experienced writers that follow all the codes used in professionalism when writing academic essays. We focus our services on satisfied clients. Through critical attention to detail, our writers abide by all the instructions given by clients. Additionally, the paper format is done according to the dictates of the client in respect to the set academic style. We are proud of completing outstanding top-quality papers.