Changes between Version 2 and Version 3 of InstructionsP6
- Timestamp:
- 07/06/26 12:51:44 (6 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstructionsP6
v2 v3 16 16 In 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. 17 17 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.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. 19 19 20 20 Finally, write create Relational Algrebra statements for your SQL solutions. 21 21 22 Create a wiki page called ** AdvancedReports** and use the structure from this template:22 Create a wiki page called **!AdvancedReports** and use the structure from this template: 23 23 24 24 {{{#!box information
