Changes between Version 4 and Version 5 of InstructionsP1


Ignore:
Timestamp:
12/16/25 07:06:55 (13 days ago)
Author:
vangel.ajanovski
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • InstructionsP1

    v4 v5  
    1 **Create an ER diagram for the database of your project.**
     1**Create an Entity-Relationship Diagram (ERD) for the database of your project.**
    22
    3 The recommended software for creating ER diagrams is TerraER (the software is open and freely available from the authors, but we recommend using the version compiled by the teacher with additional adjustments available at https://bazi.finki.ukim.mk/resources/Software/), because it directly allows you to draw with one of the notations learned in lectures. Pay attention to which connecting lines you use where. Make sure to use the appropriate types of diagram elements. At this point, we do not recommend other software. ''If you decide to use another software, make sure to use the same notation as in TerraER so that there are no misunderstandings.''
     3The recommended software for creating ERDs is TerraER (the software is open and freely available from the authors, but we recommend using the version compiled by the teacher with additional adjustments available at https://bazi.finki.ukim.mk/resources/Software/), because it directly allows you to draw with one of the notations learned in lectures. Pay attention to which connecting lines you use where. Make sure to use the appropriate types of diagram elements. At this point, we do not recommend other software. ''If you decide to use another software, make sure to use the same notation as in TerraER so that there are no misunderstandings.''
    44
    5 The ER diagram should correspond to your project description from the previous assignment and include the data requirements that are appropriate for the project described in this way.
     5The ERD should correspond to your project description from the previous assignment and include the data requirements that are appropriate for the project described in this way.
    66
    7 The ER diagram must be made correctly according to the notation that has been taught. The most important thing is that each entity set must have a clearly defined primary key, and for the relational connections between the entity sets, foreign keys should not be specified, but only if there are additional attributes. And all the other rules that have been taught.
     7The ERD must be made correctly according to the notation that has been taught. The most important thing is that each entity set must have a clearly defined primary key, and for the relational connections between the entity sets, foreign keys should not be specified, but only if there are additional attributes. And all the other rules that have been taught.
    88
    9 Arrange the ER diagram to be visually readable, clear and condensed to save as much space as possible without loosing readability:
     9Arrange the ERD to be visually readable, clear and condensed to save as much space as possible without loosing readability:
    1010
    1111* Rearrange the most important entities to clearly visible positions
    … …  
    1616TerraER saves in XML format, do not forget to put an .xml extension to the file so that it can be processed and displayed correctly.
    1717
    18 Expect that there will be many changes to the ER diagram. Keep all versions, naming them as follows: ERModel_v01.xml, ERModel_v02.xml, ...
     18Expect that there will be many changes to the ERD. Keep all versions, naming them as follows: ERModel_v01.xml, ERModel_v02.xml, ...
    1919
    20 Create a Wiki page in your project site called ERModel (be careful with capitalization). Link it to the contents of the front page in Phase P1.
     20**Document the Entity-Relationship Model for the database of your project.**
    2121
    22 Attach all the different versions of the ER diagram as files to the ERModel page both as original source format (ERModel_v01.xml, ERModel_v02.xml, ...) and also attach an exported image of each of the versions of the ER diagram in PNG format under the names (ERModel_v01.png, ERModel_v02.png, ...)
     22Create a Wiki page in your project site called 'ERModel (be careful with capitalization). Link it to the contents of the front page in Phase P1.
     23
     24Attach all the different versions of the ERD as files to the ERModel page both as original source format (ERModel_v01.xml, ERModel_v02.xml, ...) and also attach an exported image of each of the versions of the ERD in PNG format under the names (ERModel_v01.png, ERModel_v02.png, ...)
    2325
    2426The ERModel wiki page should be created according to the following template:
    2527
    26 
    2728{{{#!box information
    2829
    29 = Entity-Relationship Model Current version
     30= Entity-Relationship Model v.NN - ''where NN is the current version''
    3031
    3132**Diagram**
    3233
    33 Image in PNG format of the latest version of the diagram (ERModel_vNN.png)
     34A full-page width image in PNG format of the latest version of the diagram (ERModel_vNN.png)
    3435
    3536**Data requirements**
    … …  
    4243     * the data type (numeric/text/date/...) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, ...)
    4344
    44 = Entity-Relationship Model  History
     45= Entity-Relationship Model History
    4546
    4647List of each version, with a one-sentence explanation of the changes in each version, i.e. what was corrected in that version compared to the previous one. If you made the correction at the request of the teacher/assistant based on a ticket posted in the system, you can link to the ticket instead of an explanation.
    4748
    4849}}}
     50
     51**AI Use**
     52
     53You are free to use an AI to improve your modeling, provided that you adhere to the following rules:
     54
     55 * you use AI in this phase of the project only to improve your own initial model
     56 * you use AI to create an alternate model for ideas that you can borrow and use in your own model
     57 * you document the changes you have made to your own model based on the ideas from the AI tool in the model history above
     58 * you document the entire usage of the AI tool in a new wiki page named ERModelAIUsage linked here, that you structure according to the following template
     59
     60{{{#!box information
     61
     62= Entity-Relationship Model AI Usage
     63
     64**Name of AI service/solution that was used**
     65
     66URL:
     67
     68Type of service/subscription:
     69
     70**Final result**
     71
     72Diagram:
     73
     74Model description:
     75
     76**Entire AI usage log**
     77
     78 1. Line-by-line Log of all interactions with the AI (prompt and response)
     79 2. ...
     80
     81}}}