The issue is with the add new tag functionality, because I want to add tag machine_learning to be a child of Python and a child of AI too. How can I improve the database design to allow this? What are the approaches to this issue?

The issue is with the add new tag functionality, because I want to add tag machine_learning to be a child of Python and a child of AI too.

Even better example is firewall as a child of networking and child of security.

How can I improve the database design to allow this? What are the approaches to this issue?

$ python books.py --print
tag: root
root
╠══ IT
║   ╠══ AI
║   ║   ╠══ knowledge_representation
║   ║   ╚══ machine_learning
║   ╠══ databases
║   ╚══ programming
║       ╚══ programming_languages
║           ╚══ python
╚══ health

The issue is with the add new tag functionality, because I want to add tag machine_learning to be a child of Python and a child of AI too. How can I improve database design to allow this? What are the approaches to this issue?

PS: I apologize for Python 2.7. I came back to my older project (It will be converted to Python 3 someday)

$ python books.py --print
tag: root
root
╠══ IT
║   ╠══ AI
║   ║   ╠══ knowledge_representation
║   ║   ╚══ machine_learning
║   ╠══ databases
║   ╚══ programming
║       ╚══ programming_languages
║           ╚══ python
╚══ health

The issue is with the add new tag functionality, because I want to add tag machine_learning to be a child of Python and a child of AI too. How can I improve the database design to allow this? What are the approaches to this issue?

I apologize for Python 2.7. I came back to my older project. It will be converted to Python 3 someday.