Project

General

Profile

Task #1574

Create new database model and SQL script to generate database

Added by ivd@pdx.edu over 8 years ago. Updated over 8 years ago.

Status:
In Progress
Priority:
Normal
Assignee:
Start date:
04/22/2012
Due date:
04/22/2012
% Done:

90%

Estimated time:
20.00 h
Spent time:

Description

Please review new database model attached.

Additional files are under code Repository:

https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel

DataBaseScript.sql - database create script
ProcessModeling.mwb - model (opens in MySQL Workbench)
ProcessModeling.png - the same model exported to png

ProcessModeling.png (39.1 KB) ProcessModeling.png ivd@pdx.edu, 04/22/2012 01:29 AM
notes-on-FAST.txt (1.85 KB) notes-on-FAST.txt Notes on OMSE 551 FAST process Anonymous, 04/22/2012 09:11 AM
Users.png (122 KB) Users.png ivd@pdx.edu, 04/30/2012 10:44 PM

History

#1 Updated by Anonymous over 8 years ago

Need to discuss in more detail how we plan to map the FAST process from OMSE 551 (see notes attached) to this structure.

Two main issues that we need to discuss and resolve:-
  • how much of the FAST process to templatize
  • how do we support cross-references entities (similar to the current process)

#2 Updated by ivd@pdx.edu over 8 years ago

  • Status changed from Resolved to In Progress
  • % Done changed from 100 to 90
  • Estimated time changed from 8.00 h to 20.00 h

After our online discussion and mapping FAST process I revamped the data model again:

https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel/ProcessModeling2.mwb
https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel/ProcessModeling2.png

re-generated database locally and created new database script:
DataBaseScript2.sql

inserted FAST template data and created insert scripts
https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel/InsertTemplateData.sql

New exported to png model in the attachment

Please notice that Andy's concern about cross-references are addressed by introducing several "Cd" fields which are will be used to generate bookmarks and anchors

#3 Updated by ivd@pdx.edu over 8 years ago

I added two columns to Creators table, created new View "UsersProcessCount" updated DataBaseScript.sql.

https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel/ProcessModeling3.mwb
https://projects.cecs.pdx.edu/svn/omse-dtcp2/ProcessModeling/DataModel/ProcessModeling3.png

"Users" page screenshot in attachment.

Also available in: Atom PDF