Assignment 2 - Data Exploration using SQL - Revision history

Juliana: /* Assignment Description */

2014-02-27T15:13:53Z

Assignment Description

← Older revision		Revision as of 15:13, 27 February 2014
Line 1:		Line 1:
	== Assignment Description ==		== Assignment Description -- Due on March 3, 2014 ==
	In your first assignment, you explored MTA data about subway fares using a data exploration tool. Now, you will further explore this data set using SQL.		In your first assignment, you explored MTA data about subway fares using a data exploration tool. Now, you will further explore this data set using SQL.


	You will use MySQL. Please follow the instructions in the [http://www.vistrails.org/index.php/Big_Data_Lab_notes_02/19/14 lab notes] to install the system.		You will use MySQL. Please follow the instructions in the [http://www.vistrails.org/index.php/Big_Data_Lab_notes_02/19/14 lab notes] to install the system.

2014-02-25T03:39:34Z

Submission Instructions

← Older revision		Revision as of 03:39, 25 February 2014
Line 60:		Line 60:
	<code>		<code>
	-- remember to end each query with a semi-colon		-- remember to end each query with a semi-colon

	~~use test;~~

	-- ******************Q1*****************		-- ******************Q1*****************

2014-02-25T03:39:00Z

Assignment Description

2014-02-24T23:12:56Z

Submission Instructions

← Older revision		Revision as of 23:12, 24 February 2014
Line 56:		Line 56:
	== Submission Instructions ==		== Submission Instructions ==

	You ~~will~~ submit to NYU Classes two text files:		You are required to submit to NYU Classes two text files:
	* as2.sql -- containing the queries you will write to answer the questions below. Use the following template for this file:		* as2.sql -- containing the queries you will write to answer the questions below. Use the following template for this file:
	<code>		<code>
Line 66:		Line 66:

	SELECT 'Q1' AS ' ';		SELECT 'Q1' AS ' ';

	<insert your query Q1>;		<insert your query Q1>;

Line 71:		Line 72:

	SELECT 'Q2' AS ' ';		SELECT 'Q2' AS ' ';

	<insert your query Q1>;		<insert your query Q1>;

Line 78:		Line 80:
	* as2.log -- containing the answers to you queries		* as2.log -- containing the answers to you queries

	* ~~Extra~~ credit: explain how you would improve and optimize the design of this database. ~~Write your explanation in a file called as2-ec.txt~~		* For extra credit, you can submit a third file named as2-ex.txt where we can explain how you would improve and optimize the design of this database.

	== Queries ==		== Queries ==

2014-02-24T23:11:34Z

Submission Instructions

← Older revision		Revision as of 23:11, 24 February 2014
Line 76:		Line 76:
	....		....

	* as2.log -- containing the answers to you queries		* as2.log -- containing the answers to you queries

			* Extra credit: explain how you would improve and optimize the design of this database. Write your explanation in a file called as2-ec.txt

	== Queries ==		== Queries ==

2014-02-24T23:09:51Z

Assignment Description

← Older revision		Revision as of 23:09, 24 February 2014
Line 36:		Line 36:
	</code>		</code>

	To create these tables and populate them, first download the dump file from: Assignments/2-SQL/mta.sql		To create these tables and populate them, first download the dump file from: http://vgc.poly.edu/~juliana/courses/BigData2014/Assignments/2-SQL/mta.sql
	Then, from a terminal window invoke MySQL and issue the following commands:		Then, from a terminal window invoke MySQL and issue the following commands:

2014-02-24T23:08:07Z

Assignment Description

← Older revision		Revision as of 23:08, 24 February 2014
Line 1:		Line 1:
	== Assignment Description ==		== Assignment Description ==
	In your first assignment, you explored MTA data about subway fares using a data exploration tool. Now, you will further explore this data set using SQL.		In your first assignment, you explored MTA data about subway fares using a data exploration tool. Now, you will further explore this data set using SQL.

			You will use MySQL. Please follow the instructions in the [http://www.vistrails.org/index.php/Big_Data_Lab_notes_02/19/14 lab notes] to install the system.


	You will work with the following tables:		You will work with the following tables:
Line 33:		Line 36:
	</code>		</code>

	~~You will use MySQL. Please follow the instructions in~~ the ~~[http~~://~~www~~.~~vistrails~~.~~org~~/~~index~~.~~php/Big_Data_Lab_notes_02/19/14 lab notes]~~ to ~~install~~ the ~~system~~.		To create these tables and populate them, first download the dump file from: Assignments/2-SQL/mta.sql
			Then, from a terminal window invoke MySQL and issue the following commands:

			<code>

			> use test;
			> source mta.sql

			</code>

			If you are not running MySQL from the same directory where the file mta.sql is located, you need to specify the full path for the file.



	You are encouraged to use the Web as a resource to find more information about MySQL.		You are encouraged to use the Web as a resource to find more information about MySQL.

2014-02-24T20:35:27Z

Assignment Description

2014-02-24T20:34:17Z

Assignment Description

← Older revision		Revision as of 20:34, 24 February 2014
Line 4:		Line 4:
	You will work with the following tables:		You will work with the following tables:

	<~~nowiki~~>		<code>

	create table fares_jan18(		create table fares_jan18(
Line 17:		Line 17:


	create table fares_feb1(		create table fares_feb1(
	remote varchar(10),		remote varchar(10),
	station varchar(100),		station varchar(100),
Line 26:		Line 26:
	students int);		students int);

	</~~nowiki~~>		</code>

	<code>		<code>

2014-02-24T20:33:27Z

Assignment Description