Create new database model and SQL script to generate database
Please review new database model attached.
Additional files are under code Repository:
DataBaseScript.sql - database create script
ProcessModeling.mwb - model (opens in MySQL Workbench)
ProcessModeling.png - the same model exported to png
#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 firstname.lastname@example.org 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:
re-generated database locally and created new database script:
inserted FAST template data and created insert scripts
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 email@example.com over 8 years ago
I added two columns to Creators table, created new View "UsersProcessCount" updated DataBaseScript.sql.
"Users" page screenshot in attachment.