Changes between Version 1 and Version 2 of UseCase02

Timestamp:

09/19/26 16:02:41 (3 days ago)

Author:

236021

Comment:

--

UseCase02

@@ -43 +43 @@
 SELECT
   d.doctor_id,
-  d.specialization,
-  dep.name AS department_name,
-  u.first_name,
-  u.last_name,
-  u.email
+  ds.specialization_name,
+  dep.department_name,
+  d.first_name,
+  d.last_name,
+  d.email_address
 FROM doctors d
+JOIN users u ON u.doctor_id = d.doctor_id
+JOIN doctor_specialization ds ON d.specialization_id = ds.specialization_id
 JOIN departments dep ON d.department_id = dep.department_id
-JOIN users u ON d.user_id = u.user_id
-WHERE d.user_id = (SELECT user_id FROM users WHERE username = 'elena.kirova');
+WHERE u.username = 'elena.kirova';
 }}}