Difference between revisions of "SpEAK:Spring 2012 DB"

From Openitware
Jump to: navigation, search
(Week Ending April 4th)
(Week Ending April 4th)
Line 77: Line 77:
  
 
Exp_ID (FK)
 
Exp_ID (FK)
 +
 +
 +
==Datbase Diagram==
 +
[[FileDatabase Diagram.png]]

Revision as of 15:03, 7 April 2012


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

FileDatabase Diagram.png