SpEAK:Spring 2012 DB

From Openitware
Revision as of 14:08, 9 May 2012 by Crq52 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Groups


Database Group

Team Members


Weekly Log of Activities - Latest Week First

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)


Datbase Diagram

Database Diagram.png

User Permission Diagram

User Permission Diagram.png

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

Week Ending March 28th