Multi-colinearity
Example
A manufacturing company collected the data to study the relationship
between its product consumption/demand (Y) and the product price
(X1) and the local residences average income (X2).
From the plots there appears to be a linear

Section 5
Displaying Data
from Multiple Tables Using Joins
Reminder
Quiz 3 in class on Nov 7
Assignment 4 posted, due 11:59pm Nov 09
Objectives
After completing this lesson, you should be able to do
the following:
Write SELECT statements to access data f

Section 4
Reporting Aggregated Data
Using the Group Functions
Objectives
After completing this lesson, you should be able to do
the following:
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clau

Niles Home
Posttraumatic Stress Disorder (PTSD) is a condition we often associate with military veterans, scarred
from witnessing the horrors of war. It is hard to imagine that within our own communities, far from
foreign wars, children and adolescents ar

Lab 5
Total points: 32
Due Date: 11/16/2016, 11:59pm
Note: Write SQL Queries (Note: Using SQL Developer Worksheet save a .SQL file with
the Question # and Select statements. The first line in the file should contain your full
name and Student ID. The form

Introduction:
Our project is focus on the business rules of OReilly Auto Parts Corp. The
purpose of this project is to create an effective and organized database that looking
and improving on the relationship between employee, customer, product and suppli