# relational algebra

## 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
##### Share on other sites

Your teacher might want you to use specific symbols for group by and having, but there's a similar question asked here:

##### Share on other sites

To: justsomeguy

thank you so much for help,

yes that page i was viewed before ...but that answer quite ... some confusing ..

by the way , thanks

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
×
• Create New...