This week I spent time designing my database of nonprofits. It has three tables, one for nonprofits, one for keywords, and one that acts as a map between the two so that there can be m:n relationships. It is a MySQL database that I'm running on my machine, and so far I've added a few organizations to it. I also connected my application to the database using JDBC (a0178cd3af8d9dea94ef258c02c61972ff937f45). Currently it can execute a query and output the results to the console.
This week I am going to write the query that will actually compare the keywords from an article to the keywords in the database and return some organizations. I will also start working on displaying those results to the user in the UI.
@poorvi-vora
This week I spent time designing my database of nonprofits. It has three tables, one for nonprofits, one for keywords, and one that acts as a map between the two so that there can be m:n relationships. It is a MySQL database that I'm running on my machine, and so far I've added a few organizations to it. I also connected my application to the database using JDBC (a0178cd3af8d9dea94ef258c02c61972ff937f45). Currently it can execute a query and output the results to the console.
This week I am going to write the query that will actually compare the keywords from an article to the keywords in the database and return some organizations. I will also start working on displaying those results to the user in the UI.