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:
Search WWH ::




Custom Search