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

Table Types

You saw in trying to resolve all the relationships among the tables in the database examples that you had to create another type of table, the join table. Four types of tables exist:

  • Data tables are the primary tables where most of your data is stored.

  • Join tables, or linking tables, create a connection between two tables in a many-to-many relationship.

  • Subset tables are data tables that contain fields that describe a specific subject and, thus, are better suited to having their own tables.

  • Validation tables, or lookup tables, are used to validate data entered into other tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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