We’re also going to put each article into a ‘category’. These categories are fixed, so we’ll create a second table called ‘categories’ to store the categories, and link the ‘articles’ table to the categories table.

Create your ‘categories’ table, with a single column:

  • name (Text column)

Add these categories to the table:

  • entertainment
  • business
  • travel
  • sport
Creating the categories table

Finally, create a column in your ‘Articles’ table to store a category for each news article. Click the ‘+’ to add a new column, then follow ‘Link to table…’, ‘categories’, and select ‘Single Row’. Call this ‘category’. This creates a link to the ‘categories’ table you just created.

Creating the categories table