/*Jensen McPherson
Assignment 3
January 23, 2016 */
/*1.*/
use movies;
SELECT FirstName, LastName
FROM DIRECTOR
WHERE Sex = 'F'
/*2.*/
use movies;
SELECT FirstName, LastName, mvtitle
FROM STAR, MOVSTAR, movie
WHERE Sex = 'M'and
STAR.starnum=MOVSTAR.starnu
IT 240 Assignment One
Due Date: Tuesday January 12th
1.
a. Insertion: If any one of the current dog owners were to bring another
pet to the office, in a list like this, that owners information would have
to be re-entered even though it is all already on f
Apple
http:/www.apple.com/
*All tags have been highlighted in red*
<!DOCTYPE html><html xmlns="http:/www.w3.org/1999/xhtml" xml:lang="enUS" lang="en-US" prefix="og: http:/ogp.me/ns#"><head itemscope
itemtype="http:/schema.org/WebSite"> <meta http-equiv="X
IT 240 Chapter 3 Notes: SQL for Relational Queries
The SQL Select/From/Where Framework
SQL SELECT clause specifies which columns are to be listed in the query
results.
SQL FROM Clause specifies which tables are to be used in the query
SQL WHERE clause
IT 130-801
Chapter 1 Notes
Every webpage contains DOCTYPE, html, head, and body.
Content that is visual to viewers goes between <body> and </body>, the
two customizable parts are the language code assigned to lang and the text
between <title> and </title>
IT 240-820 Introduction to Databases Chapter 2 Notes
Entity- Something of importance to the user that needs to be represented in the
database.
DBMS products store data in the form of relations, which are a special type of table.
Relation a two-dimensional
Jensen McPherson
IT 240 Assignment One
Due Date: Tuesday January 12th
1.
a. Insertion: If any one of the current dog owners were to bring another pet to
the office, in a list like this, that owners information would have to be reentered even though it is
Why do we use Databases?
-We all use databases (credit cards, atms, ventra, smart phone.
-Underlying technology we use everyday.
What is a database?
- It is a collection of data related to a particular purpose.
- Used to keep track of things
- Spreadsheet
/*Jensen McPherson
Assignment 4
February 2, 2016*/
/*1.*/
use movies;
SELECT Avg(DATEDIFF(NOW(), starborn)/ 365.25)'Avg AGE', MIN(DATEDIFF(NOW(),
starborn)/ 365.25)'Min Age', MAX(DATEDIFF(NOW(), starborn)/ 365.25)'Max Age'
FROM star
WHERE starborn is NOT
Jensen McPherson
IT 240 Assignment Two
Due Date: Tuesday January 19th
1.
a.
b.
c.
d.
e.
f.
g.
h.
i.
1. True
2. False
3. True
4. True
5. False
6. False
(ProjectID, EmployeeName)
2nd normal form
An example of an update anomaly would be if Jones EmployeeSala
IT-223err
Assignment 5
Jensen McPherson
Due Date: 5/20/16
1.
a. If we were just calculating the probability of any cases more than 6 to be
purchased, the probability would be 0.02, calculated from adding up the relative
frequency for the cases purchased b
Video 1:
Variable a characteristic or an attribute that takes different values for the
population of interest.
Quantitative Variable takes numerical values.
Qualitative Variable classifies and individual into categories or groups.
The distribution of a va
Video 1:
r tells you both the strength and direction of a linear relationship between
two quantitative variables.
Is always between -1 and 1. The closer to 1 or -1 the more straight the
line. Negative means its declining, while positive means its increasi
Video 1:
Density Curve: When applied to a histogram, a density curve is a line drawn as a
smooth approximation to the graph. A density curve is also a mathematical model of
a distribution. The proper name for a bell-shaped curve is called normal
distribut
Video 1:
Two seemingly unrelated sets of data can be compared through the use of z-scores. Converting the data
into a z-score and comparing the z-scores then comparing percentiles.
Video 2:
68, 95, 99.7 rule
Under normal curves,
68% is the area between -1
IT-223
Assignment 6
Jensen McPherson
Due Date: May 27th 2016
Problem #1
1. Since it is a die, the only options of roll are 1, 2, 3, 4, 5, and 6. So the
probability of landing on any of these numbers is 1/6 for each. Mean is
going to be the probability mul
Module 6 Notes:
Video 1 notes:
Probability:
- A phenomenon is random if individual outcomes are uncertain. And yet, given a
large number of repetitions, you can expect to see a regular distribution of
outcomes.
- Sample Space- refers to the list of all po
Jensen McPherson
4/6/2016
IT 231
Assignment 1
Defining your project.
Since fashion and apparel are such a large part of my life, I figured it would be
easy enough to branch off of that, using clothes that I currently own as well as from
various stores to
Video 1:
Correlation: doesnt mean causation
Means that there is a relationship between two variables.
Causation: If there is a change in explanatory variable, it will cause a change in the
response variable.
A strong correlation doesnt mean a strong causa
Video 1 Notes
General Addition Rule
P(A or B) = P(A) + P(B) P(A and B)
Can be used on both disjoint and non-disjoint events.
If events are disjoint then
P(A or B) = P(A) + P(B)
Video 2:
A discrete space is one in which all possible outcomes can be clearly
IT-223
Assignment 4
Jensen McPherson
Due Date: 4/29/16
1.
a.
Regression model for Study Time vs Exam Score:
Exam Score = 22.164 + 0.992 * Study Time
R value is 0.821
R^2 is 0.674
Regression model for Anxiety vs Exam Score:
Exam Score = 64.381 + -.069 * an
IT-223
Assignment 1
Jensen McPherson
Due Date: 4/8/16
Question 1:
1. I would use the median to determine the center of this set of data because
although this isnt a lot of data to account for, the spread isnt exactly even,
bin, with low frequencies in the