Changes between Version 2 and Version 3 of InstructionsP6


Ignore:
Timestamp:
07/06/26 12:51:44 (6 days ago)
Author:
vangel.ajanovski
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • InstructionsP6

    v2 v3  
    1616In some cases it might not be possible to solve the problem with pure SQL query, in which case you might turn to solving the problem with using helper views, stored functions and stored procedures.
    1717
    18 If you happen to have a good idea for a query, but you lack the appropriate data in your database design, it is advisable to modify the design to include the necessary structures for such data. Any changes should be made to both the **ERModel** and the **RelationalDesign** and submitted to the course accordingly.
     18If you happen to have a good idea for a query, but you lack the appropriate data in your database design, it is advisable to modify the design to include the necessary structures for such data. Any changes should be made to both the **ERModel** and the **!RelationalDesign** and submitted to the course accordingly.
    1919
    2020Finally, write create Relational Algrebra statements for your SQL solutions.
    2121
    22 Create a wiki page called **AdvancedReports** and use the structure from this template:
     22Create a wiki page called **!AdvancedReports** and use the structure from this template:
    2323
    2424{{{#!box information