SpEAK:Spring 2012 DB


 * Home
 * Semesters
 * Spring 2012

Groups

 * Program Managers
 * [Database]
 * Front End
 * Test

Team Members

 * Chad Connors
 * Melissa Mertz
 * Paskale Odongo
 * Cedric Woodbury

Week Ending May 9th -LAST DAY OF CLASS
Tasks This Week
 * Attempt to reproduce issues that are open on Google Code on local machines - Melissa/Chad
 * Continue to review PHP code - Melissa/Chad/Cedric
 * Continue to be available to support the other teams - Melissa/Chad/Cedric
 * Attempt to review defects posted by the front-end team and suggest solutions if possible - Cedric

Tasks Completed
 * PHP code was reviewed to the best of our abilities
 * We were available to support the other teams
 * Some of the defects appeared to be resolved, the issues log on Google code just had not been updated yet
 * PHP code was reviewed
 * Some members were not able to try to reproduce the issues reported due to technical difficulties getting Apache running.

Week Ending May 2nd
Tasks This Week
 * Update the user table to have fields for a middle name, and other field. - Cedric
 * Change the variable type for the description field on the experiment table to allow more text. - Cedric
 * Update the documentation for the database diagram. - Cedric
 * Review PHP code to become familiar with the SQL calls the front-end team is using - Cedric/Melissa/Chad
 * Be available to answer any questions the other teams might have for the DB team. - Cedric/Melissa/Chad

Tasks Completed
 * Updated the user table with the new fields
 * Updated the description field on the experiment table
 * Updated the database documentation.
 * PHP code was reviewed

Week Ending April 25th
Tasks This Week
 * Create security role as author
 * Create ourselves in the user_id table
 * Come up with four experiments for experiment table
 * Get each experiment_Id and create author record
 * Send to Cedric for adding to main database
 * Add database portion to system design document
 * Attend the URC Poster Presentations Wed 25th between 3:30pm and 6pm ( Just for 10-15mins)

Tasks Completed
 * Create security role as author- Completed by all members
 * Create ourselves in the user_id table-Completed by all members
 * Come up with four experiments for experiment table-Completed by all members
 * Get each experiment_Id and create author record-Completed by all members
 * Send to Cedric for adding to main database-Completed by all members, combined SQL script posted to Google code site.
 * Attend the URC Poster Presentations Wed 25th between 3:30pm and 6pm- Not required but Chad will be there at least, will update tomorrow with others that are there
 * Added database portion to system design document

Week Ending April 18th
Tasks This week
 * Sample data input from Dr J - Melissa/Chad
 * Query strings creation for FE group Melissa/Chad
 * Review current progress made by other teams and identify items for discussion next week - Cedric

Tasks Completed
 * Password field added to users. Diagrams updated.
 * Password field added to users - Cedric
 * Finalize SQL create database and tables scripts - Paskale and Cedric
 * Ensure scripts are rerunable - Paskale and Cedric
 * Comment sql scripts - Paskale
 * Update weekly log - Cedric and Melissa

Week Ending April 11th
Tasks This week
 * Database schema and documentation into RAD not on weekly log
 * SQL code for new schema completed - Paskale
 * Ensure checkout and checkin functionalty working for all team members
 * Review meeting if necessary

Tasks Completed* Sql scripts created
 * database schema documented
 * UML diagram created

Week Ending April 4th
Task List for Week 1 P1 - Due Apr 4th
 * Installation of Tools Complete and Running
 * Review existing Documentation from previous semester
 * Checkout existing codebase from Google code and review
 * Create first table Experiments and SQL database and table creation script
 * Implement on Mysql

TASKS COMPLETED
 * Identified initial field and table requirements

USER_ID

User_Name (PK)

Role (FK)

Last_Name

First_Name

SECURITY

Role (PK)

Role_Desc

EXPERIMENT

Exp_ID (PK)

Description

Keywords

Create_Date

Title

Author

Rec_ID (PK)

User_Name (FK)

Exp_ID (FK)

User Permission Diagram


Diagrams of the Relational Schema have been uploaded to the Google Code Repository in PDF and MySQL Workbench formats.