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

Chapter 7. Entity Types > Simple Entities

Simple Entities

As I said, there is often a one-to-one relationship between an entity and a table. When this happens, the result is a simple entity. A simple entity may contain foreign key references to other tables in the schema—most often lookups of some variety—but the real-world “thing” in the problem space that the entity represents is completely represented by a single table.

Although they're simple to understand, simple entities are surprisingly rare in nontrivial applications. Tables that are used as lookups to ensure data consistency are often simple entities, but it's unusual to find them among the primary entities that model the problem space. In our sample, there are only two nontrivial simple entities: Authors and Illustrators.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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