We're going to build a history site for New York City, so we're going to need to create the following database structure:

• landmarks belongs_to the figure who built it
• figures(Historical figures) has_many titles
• titles has_many figures

So for example:

Figure

Landmarks

Titles

Any time you have a has_many to has_many relationship, you'll need to create a join table. An example of a has_many to has_many relationship is titles and figures. A tiles has_many figures because many people hold a title over time and a figure usually has_many titles over their career.

Below is an example of a join table. We called it figure_titles, but you could call it something less clear like Roles if you wanted to.

Figure_titles

Make sure to create web pages, routes, etc. to add, update, and edit figures, titles, landmarks, years, etc.

Your forms will need to be nested. So when you create a new title, you can also add a figure to that title. You should also be able to create a new figure if he/she doesn't already exist in your database. The same applies for all your models that have an association.

Your forms should use checkboxes, which allow you to add multiple figures to a title at the same time, e.g. If I create the Mayor title and a bunch of mayors are already in my database, I'll want to add them all at once when I create the Mayor title.

Make sure to migrate your test database by running rake db:migrate SINATRA_ENV=test

• Sinatra ActiveRecord screencast View this lesson on Learn.co