Changes between Version 14 and Version 15 of Normalization

Timestamp:

09/23/25 10:52:56 (5 weeks ago)

Author:

223075

Comment:

--

Normalization

@@ -162 +162 @@
 == Пример за cross-domain прашање ==
 
-===  „Кои учесници на настани исто така резервирале час за тренинг ‘Vinyasa’?“ ===
-{{{
-SELECT DISTINCT u.user_id, u.username, e.event_name, e.date
-FROM "User_Event" ue
-JOIN "Event" e ON e.event_id = ue.event_id
-JOIN "User_Booked_Class" ubc ON ubc.user_id = ue.user_id
-JOIN "Class_Includes_Training" cit ON cit.class_id = ubc.class_id
-JOIN "Training" t ON t.training_id = cit.training_id
-JOIN "User" u ON u.user_id = ue.user_id
-WHERE t.training_name = 'Vinyasa'
-ORDER BY e.date;
+=== „Кои часови ги резервирал корисникот X, со информации за тренинг и инструктор?“ ===
+{{{sql
+SELECT c.class_id, c.date, c.start_time, c.location,
+       t.training_name,
+       i.first_name || ' ' || i.last_name AS instructor
+FROM "User_Booked_Class" ubc
+JOIN "Class" c                 ON c.class_id = ubc.class_id
+LEFT JOIN "Class_Includes_Training" cit ON cit.class_id = c.class_id
+LEFT JOIN "Training" t         ON t.training_id = cit.training_id
+LEFT JOIN "Instructor" i       ON i.instructor_id = c.instructor_id
+WHERE ubc.user_id = $1
+ORDER BY c.date, c.start_time;
 }}}
-
 
 == Имплементација во Express ==