Changes between Version 3 and Version 4 of InstructionsP2


Ignore:
Timestamp:
07/05/26 16:36:49 (2 hours ago)
Author:
vangel.ajanovski
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • InstructionsP2

    v3 v4  
    1414**Enter sample data in all created tables.** The sample data items should seem realistic, and appropriately and logically related among each other. The data should simulate real situations. You should create as many rows as necessary to simulate the necessary situations of your project.
    1515
    16 ** Create a new wiki page **RelationalDesign** to document the entire work** and link it to the frontpage. The wiki page should have the structure described in the following template.
     16** Create a new wiki page **!RelationalDesign** to document the entire work** and link it to the frontpage. The wiki page should have the structure described in the following template.
    1717
    1818{{{#!box information
    … …  
    2626* The script should (re-)create the schema, all the tables, with all constraints, and all other relevant database objects.
    2727* The script should work in an empty database to fully construct everything needed for the project, and should also work in a database where the schema, tables and other objects are already created and they need to be re-created. So drop existing objects and create them again.
    28 * The script should be named schema_creation.sql
    29 * Link the script in this section in the RelationalDesign wiki page as an attachment to the page.
     28* The script should be named **schema_creation.sql**
     29* Link the script in this section in the **!RelationalDesign** wiki page as an attachment to the page.
    3030
    3131**DML script for filling tables with data:**
    … …  
    3333* The script should (re-)create all the data in your tables
    3434* The script should work with empty tables to fully load all needed data for the project, and should also work in a database where the tables already have data and need to be emptied and the data should be imported again.
    35 * The script should be named data_load.sql
    36 * Link the script in this section in the RelationalDesign wiki page as an attachment to the page.
     35* The script should be named **data_load.sql**
     36* Link the script in this section in the **!RelationalDesign** wiki page as an attachment to the page.
    3737
    3838**Relational diagram**
    … …  
    4242* Switch the diagram to use crow-feet notation.
    4343* Visually adjust the diagram to have the same positioning of tables and relations as the corresponding entities and relations in the ER diagram in the previous phase.
    44 * Export the diagram to a file named relational_schema.jpg and attach it in this section.
     44* Export the diagram to a file named **relational_schema.jpg** and attach it in this section.
    4545
    4646}}}