Changes between Initial Version and Version 1 of UseCase4

Timestamp:

01/06/22 00:24:37 (4 years ago)

Author:

193026

Comment:

--

UseCase4

@@ +1 @@
+==  Приказ на детали
+ Посетител или Reviewer може да гледа детали за избраниот бизнис.
+
+=== Актери
+ * Посетител
+ * Reviewer
+
+=== Реализација
+Чекор 1 : Системот го прикажува избраниот бизнис.
+
+[[Image(biznis.png, 959px)]]
+
+
+{{{#!sql
+select 
+        b.business_id,
+        b.business_name,
+        (
+        select
+                avg(r.review_stars)
+        from
+                review r
+        where
+                r.business_id = b.business_id 
+) as business_avg_stars,
+        c.category_name,
+        a.address_city
+from
+        business b
+join category c on
+        b.category_id = c.category_id
+join address a on
+        b.business_id = a.business_id
+}}}
+