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

Partitioning Databases

A single relational database can contain a set of tables that represent every tangible object with which an organization deals. It's more common, however, to create individual databases that relate to specific organizational functions—typically sales, manufacturing, finance, and human resources. Each database is owned and managed by its department, and other departments only have access to specific fields of selected tables. For example, the sales department's order entry system must associate salespersons with their orders, but doesn't need access to employees'personnel information maintained by the human resources department.

As mentioned earlier, Jet databases let you link table data stored in other Jet, desktop, and client/server databases. Linked tables can reside on any computer to which you have a network connection and security permissions to read and, optionally, update the data. In the case of an employees table, you might find it necessary to split the table to prevent linked access to confidential employee information. Splitting a base table for linking is one of the few instances in which you use a one-to-one relationship.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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