Changes between Version 10 and Version 11 of ImportantUseCase002

Timestamp:

12/28/22 15:57:21 (2 years ago)

Author:

201144

Comment:

--

ImportantUseCase002

@@ -45 +45 @@
 
 {{{
-select a.apartment_size,a.apartment_adress,au.phone_number,p.cityname,p.number_of_roommates,p.price
-from apartment a,post p,appuser au,owner_post op,apartment_owner ao,building b
-where p.postid=op.owner_postid 
-and
-ao.ownerid=a.ownerid 
-and 
-op.ownerid=a.ownerid 
-and 
-op.apartmentid=a.apartmentid
-and 
-au.userid=op.ownerid 
-and 
-a.buildingid=b.buildingid 
+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); 
 }}}