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

Chapter 7. Entity Types > Complex Entities

Complex Entities

Whereas simple entities are represented by a single table in the database schema, complex entities are, of course, represented by multiple tables in the database schema. The classic example of a complex entity is a SalesOrder, a single logical entity that is implemented using (at least) two tables, OrderHeader and OrderDetails. (Of course, the names and the attributes vary, but the structure is relatively stable.)

Complex entities are usually represented by two tables, as in our SalesOrder example, but occasionally they require more. Their representation in a single form is largely determined by the relationship between the tables: one-to-one, one-to-many, or many-to-many.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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