Database Reference
In-Depth Information
One to one
In this type of relationship, a one-entity record of a table is related to only a one-entity re-
cord of the other table. In our bookstore application, we have the
BookInfo
and
BookDetails
tables. The
BookInfo
table can have information in brief about the
book, which can be used to display book information on web pages, whereas the
BookDe-
tails
table would be used when someone explicitly needs to see all the details of the
book. This design helps us keep our system healthy as, even if there are a large number of
requests on one table, the other table would always be up and running to fulfill what it is
supposed to do. The following screenshot shows how the table structure would look: