Difference between revisions of "SpEAK:UML Class Diagram"

From Openitware
Jump to: navigation, search
(Relationship Summary)
(Relational Model Diagram)
 
Line 70: Line 70:
  
 
==Relational Model Diagram==
 
==Relational Model Diagram==
[[File:speak_uml.png]]
+
[[File:P1_uml_revised.png]]

Latest revision as of 21:13, 11 May 2011

Contents

Description

A relational model diagram displays all of entities and their attributes and how they relate to each other.

Relational Model Entities and Attributes Definitions

Experiment User


Experiment User - A listing of Users involved in the experiments

  • User ID - Uniquely Identifies individual users

Experiment Admin


Experiment Admin -List of admins involved in the experiments

  • User ID- Composite Key
  • Last Name - Last Name of Admin
  • First Name- First Name of Admin
  • Phone - Admin phone number
  • Email - Admin Email Address
  • Campus - Admin's Campus

Experiment


Experiment- Listing of experiments

  • Experiment Number- Primary Key that uniquely identifies each experiment
  • User ID- Foreign Key
  • Title- Title of Experiment
  • Date Created- Date Experiment was created
  • Date Modified- Date experiment was modified
  • Description- Description of experiment

Viewer


Viewer- Listing Of viewers

  • User ID- Composite Key

Author


Author- Listing of authors involved in the experiments

  • User Id- Composite Key
  • Last Name- Author's Last Name
  • First Name Author's First Name
  • Phone Author's Phone Number
  • Email Author's Email Address
  • Campus Author's Campus

Accessible Experiment


Accessible Experiment- Experiments that are available for viewing by users with the right privlidges

  • User ID- Composite Key
  • Experiment Number-Foreign Key

Keyword


Keyword- Listing of keywords used to search for experiments

  • Keyword ID- Primary Key that uniquely identifies the keyword
  • Experiment Number- Foreign key
  • Keyword Name -Name of Keyword

URL Link


URL Link- Listing of URL links

  • URL ID- Primary Key that uniquely identifies each URL link
  • Experiment Number- Composite key
  • URL Name- Name of the URL

Attachment


Attachment- List of attachments for experiments

  • Experiment Number- Foreign Key
  • Attachment Name- Name of attachment

Relational Model Diagram

P1 uml revised.png