Changes between Version 4 and Version 5 of ImportantUseCase1

Timestamp:

12/15/22 09:11:04 (2 years ago)

Author:

201050

Comment:

--

ImportantUseCase1

@@ -30 +30 @@
 insert into e_prof_na(p_id, ku_id)
 values
-((select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'Bazi na podatoci - VA')),
+((select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'БнП- VA - 2022/2023')),
+((select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'БнП- VA - 2021/2022')),
+((select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'БнП- VA - 2020/2021'));
 }}}
 == Чекор 4\\
@@ -38 +40 @@
 {{{
 select *
-from project.kursevi as k
-join project.predmeti p on k.pr_id = p.pr_id
-where p.pr_ime = 'Bazi na podatoci';
+from project.e_prof_na as epn
+join project.kursevi k on k.pu_id = epn.ku_id
+where p.p_id = 1;
 }}}
 
@@ -59 +61 @@
 Во позадина се извршува
 {{{
-select * from project.prasanja where ku_id = (select ku_id from kursevi where ku_ime = 'Bazi na podatoci - VA');
+select * from project.prasanja where ku_id = (select ku_id from kursevi where ku_ime = 'БнП- VA - 2022/2023');
 }}}
 за листање на прашањата \\
 {{{
-select * from project.materijali where ku_id = (select ku_id from kursevi where ku_ime = 'Bazi na podatoci - VA');
+select * from project.materijali where ku_id = (select ku_id from kursevi where ku_ime = 'БнП- VA - 2022/2023');
 }}}
 за листање на материјалите\\
@@ -75 +77 @@
 insert into project.materijali(m_ime,p_id,ka_id,ku_id)
 values
-('Правила-и-услови.txt',(select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ka.ka_id from kategorii as ka where ka.ka_ime = 'Predavanja'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'Bazi na podatoci - VA')),
+('Правила-и-услови.txt',(select p.p_id from profesori as p where p.p_korisnicko_ime = 'vangel.ajanovski'),(select ka.ka_id from kategorii as ka where ka.ka_ime = 'Predavanja'),(select ku.ku_id from kursevi as ku where ku.ku_ime = 'БнП- VA - 2022/2023')),
 }}}