Changes between Version 7 and Version 8 of ImportantUseCase003

Timestamp:

12/28/22 15:59:26 (2 years ago)

Author:

201144

Comment:

--

ImportantUseCase003

@@ -44 +44 @@
 
 {{{
-select ime,prezime,phone_number,(p.price/p.number_of_roommates) as budget from appuser, student s,post p ,student_post sp  
-where (appuser.userid=s.studentid)
+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 
-(p.postid=sp.student_postid)
+op.ownerid=a.ownerid 
 and 
-(sp.studentid=s.studentid)
+op.apartmentid=a.apartmentid
 and 
-(p.price<=400)
+au.userid=op.ownerid 
 and 
-(p.number_of_roommates=4);
+a.buildingid=b.buildingid 
+and 
+p.price < (150*p.number_of_roommates) 
+and
+p.number_of_roommates=2
 }}}