Jump to content

Recommended Posts

hi,

 

sorry, i have a question to do...but i know how to write in sql query ....however the answer need to write on relational algebra

 

in query is like :

 

SELECT * FROM operation
where r='broken'
group by pc
having count(pc) >1 ;
π id,pc,result ( σ r = 'broken' (operation))
like group by and having clasue...i no idea ...
i searched on internet still @@ ....
isnt the answer like that, i using split/step by step method to do
rel 1 = σ r = 'broken' (operation)
rel 2 = σ count(pc)>1 γ pc,count(pc) (rel 1))
rel 3 = π id,pc,result (rel 2 )
thanks
Edited by HarrySeah
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...