stevegbrooks/commodify

CIS 550 Final Project Spring 2021

commodify's Issues

create project outline (due Feb 19th)

1. Motivation for the idea/description of the problem the application solves
2. List of features you will definitely implement in the application
3. List of features you might implement in the application, given enough time
4. List of pages the application will have and a 1-2 sentence description of each page. We expect that the functionality of each page will be meaningfully different than the functionality of the other pages.
5. Relational schema as an ER diagram
6. SQL DDL for creating the database
7. Explanation of how you will clean and pre-process the data.
8. List of technologies you will use. You must use some kind of SQL database. We recommend using MySQL specifically because you will use MySQL in HW2, and we will provide guidance for setting up a MySQL database.
9. Description of what each group member will be responsible for

create project proposal (due Feb 12th)

The project proposal should contain the following:

1. A List of group members, email addresses, and GitHub usernames

2. A Description of application/website idea

3. For each dataset you’ve chosen:

• A 1-2 sentence description of the dataset
• A link to where you found the dataset
• If you’re scraping the data, a description of how you will scrape it
• If you’re not scraping the data: relevant size statistics (e.g. For a table, mb/gb, number of rows, and number of attributes. For a graph, mb, number of nodes, and number of edges), and summary statistics of several attributes (e.g. report mean, standard deviation)

4. A list of at least 5 queries (in natural language) you could write for your datasets. Some of these should require complex SQL (aggregations, subqueries, joins, etc.)

Milestone 3: Database population and SQL queries (Due Apr 2nd)

Create a .txt file containing the following:

1. Queries -- A list of 5-10 SQL queries for your database that your application may execute. Ensure that some of your queries are complex (e.g. involve subqueries, joins, aggregations, etc.)

2. Descriptions -- A 1-2 sentence description of what each query is supposed to do

3. Credentials -- Instructions and guest credentials for accessing the database