Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_lcoholi_c
Starting Member
2 Posts |
 Posted - 2007-04-24 : 19:24:05
|
This is a bit of a trivial question, since I know how to actually create the code in SQL. Hope this is the right section to post it in too, since it sort of concerns design I guess..My problem is how to I represent the following SQL query in relational algebra:SELECT *FROM Staff;Since I'm using SELECT, I assume I use selection to represent it, so would it be as "ó(Staff)" [using the sigma symbol, in case it doesn't show]? But as I'm not specifying a predicate since I wish to select all fields in Staff, would it be simply represented as "Staff"?I appreciate any help... it's been baffling me for a while  |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2007-04-24 : 19:39:39
|
| >>But as I'm not specifying a predicate since I wish to select all fields in Staff, would it be simply represented as "Staff"?Yes.DavidMProduction is just another testing cycle |
 |
|
|
a_lcoholi_c
Starting Member
2 Posts |
Posted - 2007-04-24 : 19:48:42
|
| Thanks for the response! Guess I was just trying to make things harder for myself. |
|
|
|
|
|
|
Relational Algebra question