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

Chapter 45. Joins > Understanding Relational Database Design

Understanding Relational Database Design

You use SQL joins to perform operations and extract data from relational databases. As such, an understanding of relational database design is a prerequisite to successfully using joins.

Relational databases are sets of tables that each store parts of a complete data set; these parts relate to each other, and thus are termed “relational”. The underlying principle here is that data should be organized so that it never has to be repeated (stored more than once), while at the same time keeping it in small, manageable sets.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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