• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

5. Query Languages and the Relational Al... > 5.3. Details of the Relational Algeb...

Details of the Relational Algebra

We are now ready to discuss the details of the relational algebra. The operations that are part of the relational algebra are described in this section. You should find most of these operations intuitive.

Before beginning, however, I should say a word about how Microsoft Access implements the operations of the relational algebra. Most of these operations can be implemented in Microsoft Access by creating a query. This is most easily done in Access’s Query Design mode, which provides the graphical environment shown in Figure 5-1.

The Access Query Design window
Figure 5-1. The Access Query Design window

The user can add table schemes from the database to the upper portion of the Query Design window. From there, various attributes can be moved to the design grid. Note that the second row of the grid shows the table from whence the attribute comes, just in case two tables have attributes of the same name (which happens often).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint