Changes between Version 11 and Version 12 of ImportantUseCase002

Timestamp:

12/28/22 16:20:26 (2 years ago)

Author:

201144

Comment:

--

ImportantUseCase002

@@ -43 +43 @@
 
 
+= **Опција 1** - зградата не постои во системот
 
 {{{
-insert into city(cityname)     
-values  ('Skopje');
 
 insert into building(cityname,building_adress) 
 values  ('Skopje','Prashka 21');
+
+insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)
+values  (1,1,'2nd Floor Room 21','55m2');
+
+insert into post(cityname,number_of_roommates,price,date_posted,description)
+values  ('Skopje',4,200,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan');
+
+insert into owner_post(owner_postid,apartmentid,ownerid)
+values  (1,1,1); 
+}}}
+
+= **Опција 2** - зградата постои во системот
+
+{{{
+
 
 insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)