SpEAK:Spring 2012 DB

From Openitware
Revision as of 15:07, 7 April 2012 by Cpc2 (Talk | contribs)

Jump to: navigation, search


Groups


Database Group

Team Members


Weekly Log of Activities

Week Ending March 28th

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