| | 1 | = Instructions on Phase P1: Relational Model (!RelationalModel) |
| | 2 | |
| | 3 | **Develop a detailed relational model** of the project's database relational schema using Visual Paradigm desktop version of the software. You can use the Community Edition for Free, or you can acquire a license. Using the online version is discouraged because it's lacking some modeling features. |
| | 4 | |
| | 5 | ** Create a new wiki page **!RelationalModel** to document the work** and link it to the front-page. The wiki page should have the structure described in the following template. |
| | 6 | |
| | 7 | {{{#!box information |
| | 8 | |
| | 9 | = Relational Model |
| | 10 | |
| | 11 | **Relational diagram** |
| | 12 | |
| | 13 | * Visual Paradigm desktop version is the recommended tool for creating the model. |
| | 14 | * Visually adjust the diagram to be as condense as possible (not waste too much space) and try to adhere as closely as possible to the guidelines on visual layout of the diagram as taught in the modeling lectures. |
| | 15 | * Save the diagram to an image file named RelationalModel.jpg and attach it in this wiki page. |
| | 16 | |
| | 17 | |
| | 18 | **Descriptive documentation and argumentation** |
| | 19 | |
| | 20 | Explain the modeling idea in detail for any specific segments of the model that are not obvious. |
| | 21 | |
| | 22 | * model segment xyz - how and why you have modeled that segment of the model in that specific way |
| | 23 | * ... |
| | 24 | |
| | 25 | }}} |
| | 26 | |
| | 27 | Approval and grading process: |
| | 28 | * Develop the model during laboratory class |
| | 29 | * Get an approval of the project idea and model by your assigned laboratory class assistant |
| | 30 | * Consult with your course professor regarding project idea and further model improvements |
| | 31 | * Approval of the model improvements by the course professor |
| | 32 | * Joint presentation and defense of the model by the entire team in front of the course professors |
| | 33 | * Final model grading |
