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

Chapter 22. Exploring Relational Databas... > Normalizing Data to the Relational M...

Normalizing Data to the Relational Model

Up to this point, most of the subject matter in this chapter has been applicable to any type of database—hierarchical, relational, or even the new class of object database systems. However, because Access is a RDBMS, the balance of the chapter is devoted to relational databases. Access fully implements the relational model in its native database structure and you can link tables from other RDBMSs—including client/server tables—to Access databases. Thus, the discussion that follows is general in nature and applies to any database system with which Access is compatible or for which you have the appropriate 32-bit Open Database Connectivity (ODBC) driver. (Access 97 requires the use of 32-bit ODBC drivers.)

The theory of relational database design is founded in a branch of mathematics called set theory, with a great deal of combinatorial analysis and some statistical methodology added. The set of rules and symbols by which relational databases are defined is called relational algebra. This chapter doesn't delve into the symbolic representation of relational algebra, nor does it require you to comprehend advanced mathematics. The chapter does, however, introduce you to many of the terms used in relational algebra for the sake of consistency with advanced texts, which you may want to consult on the subject of database design.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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