Custom Trivia Q/A Database

Question

Background:
I've been a professional trivia host for almost 10 years. In that time, I've accumulated A LOT of trivia questions, and I'm at the point where I'm afraid of becoming redundant. I also have over 25 years working in the IT field, so I'm knowledgeable/well-versed in computers, but sadly over the years the one area I never invested time into learning was databases.

Goal:
I'm looking to create a database where I can enter all the questions (and answers) I've used over the years and track where/when/how often I've used that question or ones similar to it.

Examples:
I'd like it to be searchable by keyword. For example. when I type in "Kennedy", all questions related to the president or his relatives would come up.

I'd also like to be able to "tag" each question with one or more categories. Again, searching tags like "U.S. Presidents", "History", "U.S. History", "Politics", etc. would bring up any question relating to a president that I've tagged as such.

Lastly, I'd like to have a web-interface if possible. Something where I can host the DB on one of my servers and you can search it thru a custom webpage I create.

As an IT person, I'd like to learn to do this from scratch, but if something else is already out there along these lines then I will take that as well. Any help, direction, instruction, correction, etc. would be greatly appreciated. Thank you.

Answer 1

Hi @Sin Sanity , welcome to Microsoft Q&A forum.

You can develop an ASP.NET application for a web interface and Azure SQL Database as backend. Below are couple of links that should give a good start. Again these tutorials are not specific to your requirements but a little customization based on inputs can help us achieve our objectives.

Tutorial: Deploy an ASP.NET app to Azure with Azure SQL Database

Create ASP.NET Web App With SQL Database In Azure

https://www.youtube.com/watch?v=SEx9Alv-ia0

Firstly we will need to finalize the database tables. For that we need to list down all the entities, their attributes and the relationship between them.

We can start with one table where we store question and answers with tags data, and say another table with categories.

Here we have linking between these tables. So one question can have multiple tags related to it. To get all the tags for a question, we can do inner join between those tables.

We can go step by step here till we achieve the objective. Please post us with your progress and we can move ahead accordingly.

Please let us know if you run into any issue and we will be delighted to look into it..

----------

If answer is helpful, you can mark it 'Accept Answer'