Building a Newspaper Database

In a recent forum message, Curatorial Assistant asks:

"I'm trying to make a database of a set of newspaper articles. Each newspaper article has already been assigned one or more keywords within a category or catergories that we use to do research. Ultimately the articles need to be able to be sorted by keyword and also by catergory. How would I build the tables?"

Can you help? Interested in solutions to the same problem? Visit our forum and join the discussion!