In this chapter, you built a model of a lending library by building its database schema, or design. The relationships between the table mirror the relationships between objects and their borrowers. As a database grows, it might generate new relationships that you don’t anticipate. Build a database design and explain how it might be used to generate new relationships.

An example might be a banking database, which might have a table of accounts and a table of transactions. Could you discover patterns of borrowing money that could lead to a marketing campaign or a new type of lending strategy?

Another example might be a museum, which would have a table of ticket sales linked to a table of exhibits. Could you discover patterns of people who are interested in an exhibit? How would you react to discovering such an insight?