Changes between Version 14 and Version 15 of AdvancedApplicationDevelopment


Ignore:
Timestamp:
09/30/25 08:53:33 (2 weeks ago)
Author:
223270
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedApplicationDevelopment

    v14 v15  
    241241}}}
    242242
     243=== Релациска алгебра
     244{{{
     245SELECT d.location_name, AVG(r.quality) AS avg_rating FROM destination d JOIN review r ON d.id_destination = r.id_destination GROUP BY d.location_name HAVING AVG(r.quality) > 4;
     246
     247
     248π_{d.location_name, avg_rating} (
     249γ_{d.location_name; avg_rating ← AVG(r.quality)} (
     250destination ⨝{d.id_destination = r.id_destination} review
     251)
     252σ{avg_rating > 4}
     253)
     254}}}
     255
     256
    243257=== Линк до репозиториумот
    244258https://develop.finki.ukim.mk/git/travel_sage.git