Team minutes DB

Goals for 121022:

Design goals:

• Team goal: Create draft ERD
• Each person create one table shown in the ERD. (We will discuss the ERD next week, which may necessitate some changes to the tables you make this week. C'est la vie.)
• Each person save the sql used to create your table into the file src/dbInitScript.sql in your team's repository. Everyone should put the SQL they create in this same file, which means you'll have to sync dewittm/sousms to your local system, add the SQL for your table to the file, commit your change, then sync back to dewittm/sousms.

Implementation goals:

• All team members need a workable mysql environment, either local or webpages.

###Note:

• Need trade history use case.

##Goals for 121015:

Design goals:

• Each: Write an interface specification you think your area will need. -- NOT DONE: unclear what to do
• Create file: doc/DBUseCases.md in dewittm/sousms -- DONE
• All Put your use case(s) in this file in .md format -- DONE

Implementation goals:

• Each team member - create a database on webpages.sou.edu -- NOT DONE. Can't connect.
• In this database, create a table that would be useful in your area (doesn't have to be perfect or have the 'right' fields -- Just has to be a table). -- DONE: Keith, Scott, Cole finished
• Copy the SQL used to create this table into the file src/dbInitScript.sql in your team's repository. Everyone should put the SQL they create in this same file, which means you'll have to sync dewittm/sousms to your local system, add the SQL for your table to the file, commit your change, then sync back to dewittm/sousms. The build group will use this file to initialize the database on the real server. -- NOT DONE
• Pete - email server address to class -- WILL NOT BE DONE
• Make a table for the feed (see http://www.nasdaqtrader.com/content/technicalsupport/specifications/dataproducts/BASIC_Web_Service_1.0.pdf)
• Make necessary fields, for all data items through pctchg.

##Goals for 121008:

###Infrastructure goals:

• Cole: Create a GitHub fork for the DB team -- DONE
• Cole: Make all team members collaborators on the fork -- DONE
• Cole: Send all team members the URL of the fork -- DONE
• All: Clone the fork to a repository onto your local system -- DONE

###Use case goals:

• All: Using the format shown at the bottom of http://cs.sou.edu/~nordquip/cs469/notes/week02notes01.htm, write two use case narratives for your area. As we discussed in the meeting, you may think of your 'users' as other development groups. -- Scott, Cole DONE, others close

Note:

• All: Record your use cases in an md document named doc/DBUseCases.md -- NOT DONE in the doc directory of your team's repository fork. (Markdown help here: https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet#wiki-images.)
• All: Commit your changes on your local repository then sync these changes to your team's fork.

###Notes: Preliminary division of labor:
Keith - Feed / Trade engine
Scott - Security / User Accounts Emily - Mobile Josh - UI / UA Cole - Trade Engine Others?