Instructions on Phase P1: Relational Model (RelationalModel)

Develop a detailed relational model of the project's database relational schema using Visual Paradigm Community Edition version of the software. The Community Edition is for free for non-commercial purposes (but please check the License). Using the online version is discouraged because it's lacking some modeling features.

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.

Relational Model

Relational diagram

• Visual Paradigm desktop version is the recommended tool for creating the model.
• 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 and element ordering and positioning in the diagram as taught in class (please check the drawing conventions section in the course materials for Lecture 2).
• Save the diagram to an image file named RelationalModel-ProjectCode.svg (Project → Export → Active Diagram as Image → Save as type: SVG) and attach it in this wiki page and also place it as image here (see example below).
• Also attach to this page the original Visual Paradigm model, named RelationalModel-ProjectCode.vpp

Descriptive documentation and argumentation

Explain the modeling idea in detail for any specific segments of the model that are not obvious.

• model segment xyz - how and why you have modeled that segment of the model in that specific way
• …

Approval and grading process:

• Develop the model during laboratory class
• Get an approval of the project idea and model by your assigned laboratory class assistant
• Consult with your course professor regarding the project idea and discuss further model improvements
• Approval of the model revision and implemented improvements by the assistants and professors
• Document the project model
• Joint presentation and defense of the model by the entire team in front of the course professors
• Final model evaluation