中文网站
  Advanced Search
Read the latest Blogs from IT professionals in the field. Read and write community created documents. Need IT help? Ask our staff. Connect with your peers. Check our Tech Shop for posters, books and software tools. Home

5.1.5 Database Systems: The Result Relation

1. If the result of a query includes attributes from several relation schemes, we need a way of displaying the result in a single table.

2. We can declare a temporary result relation including the attributes to be displayed. We put the print command only in that table.

3. To find the customer names and cities and account numbers for all customers having an account at the SFU

deposit bname account# cname balance
  SFU _z _x  
customer cname street ccity
  _x   _y
result cname ccity account#
P. _x _y _z

Database System Structure: