For our last Forum you will propose a research study. This will give you the opportunity to put in practice everything we have learned about conducting research. You do not need to include any analysis but you are required to choose a method of analysis and explain why you have chosen the particular method. Your study will need to include the following information:1) Topic – explain why you have chosen your topic2) Hypothesis (could be in a form of question or stating the Ho and Ha) 3) Population/Participants 4) Sampling method 5) Data gathering method 6) Method of analysis (depending if you are using qualitative or quantitative method)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

18. For planning purposes, truss manufacturers must try to predict the number of hurricanes that will hit the eastern seaboard of the United States in any given year. If this area is hit with an average of 6 hurricanes per year, find the probability that in a given year…

a) …fewer than 3 hurricanes will hit this area. 

b) …between 6 and 8 hurricanes (inclusive) will hit this area.  

c) What is the standard deviation of this distribution?  

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Assignment 1: Using Measures at Work

It is often said that numbers don’t lie; however, the validity of such a statement is predicated on the quality of data obtained. So how does an organization determine what kind of factors and items to measure, and then how is the best method of measurement determined? Do we measure individual performance, organizational outcomes, employee satisfaction, or something else? As organizations consider such issues, industrial/organizational (I/O) professionals can provide guidance on selecting and implementing metrics in the workplace.

Use your understanding of the application of industrial/organizational (I/O) concepts as well as scholarly sources to address the following questions:

• What are the advantages and disadvantages of using objective measures as you assess factors such as performance?
• How do reliability and validity of measurements impact decisions in organizational processes such as employee selection?

Provide an example of a qualitative employee satisfaction measure and a quantitative employee satisfaction measure. Explain the potential use for each.

Your response should directly address each question, providing references and examples to support your points. You should use at least two scholarly sources cited in APA format. Comment in a substantive manner on the responses of at least two of your classmates. Some comments or questions you may consider while responding to your classmates include:

• Providing another perspective on one of the topic areas
• Providing an additional reference with an interesting complementary or different view of the topic areas
• Providing a personal example related to one of the topic areas

Submission Details:

• Write your initial response in a minimum of 300–400 words.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

For Part II of your final project, you will implement your plan for the scenario below. Project plan should include the entity relationship diagram (ERD), tables, and SQL statements.

Scenario

Imagine that you just started a new job at ABC Car Sales. You’ve been given the task of adding all the new and used car inventory to a new database management system (DBMS). You would like to manage the new and used car sales in the new DBMS system.

Listed below are the categories of information that you will need to input in the new database for each type of inventory:

New Vehicle Inventory

Used Vehicle Inventory

VIN Number

VIN Number

Price

Price

Make

Make

Model

Model

Year

Year

Exterior Color

Exterior Color

Interior Color

Interior Color

Transmission (Manual/Automatic)

Transmission (Manual/Automatic)

Engine (# of cylinders)

Engine (# of cylinders)

Mileage

Mileage

Fully loaded (Yes/No)

Fully loaded (Yes/No)

Carfax Report (Yes/No)

You will also want to track the following types of information for new and used car sales, including specific customer data.

New Car Sales

Used Car Sales

Sales ID Number

Sales ID Number

VIN Number

VIN Number

Customer ID

Customer ID

Advertised Price

Advertised Price

Purchase Price

Purchase Price

Financed (Yes/No)

Financed (Yes/No)

Date sold

Date sold

Customer

Customer ID

First Name

Last Name

Address

Phone Number

Sales ID Number

Instructions

For Part II of the final project, complete the following and submit it as a Word document.

1. List all tables with primary keys and foreign keys identified.
2. List all functional dependencies.
3. Provide the following SQL Statements:

• CREATE query for the New Car Inventory table
• CREATE query for the Used Car Inventory table
• INSERT Used Car Inventory
• INSERT New Car Inventory
• INSERT Used Car Sale
• INSERT New Car Sale
• INSERT Customer
• UPDATE New Car Inventory
• UPDATE Used Car Inventory
• UPDATE Customer

1. Provide a query for each task listed below:

• identify which color car was the most popular customer choice
• give a list of all the used cars that were sold for less than $20,000
• lists all new cars for sale that are priced higher than $40,000
• lists all fully loaded used cars for sale that have less than $30,000 miles
• lists all cars sold this year
• list customers who bought more than one car in the past three years
• lists all manual cars with a 6-cylinder engine and the list displays the VIN number, whether it is a new or used car and the interior and exterior color

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"