Question

Choose MySQL conduct some additional research. Complete the following:

• A summary of the tool, evaluating its functions
• The type of organization or industry that would benefit from this system
• An evaluation of the tool, describing its benefits and limitations and including answers to the following questions:
  • What challenges would an organization face in using a database management system, especially challenges in data and information management?
  • What is one problem that a database management system would not be able to solve?

Answer 1

1 . Pg-admin tool :

It's tool for analyzing the all-database performances.

It does the following tasks for us.

i) You will be able to connect all SQL servers through it , if we have access to it.

ii)Explains the query in a better way

iii) Acts as GUI , it is okay if we don't remember the syntax of a query

iv) we can create procedures and triggers

v)Used as a visualization tool when we need performance of a database.

Organization benefits:

i)Good tool among the SQL databases.

ii)can easily handle multiple servers at the same time

iii) Monitoring is pretty much easy

Challenges and problems :

There may be some loopholes using these tools . they are

I) This tool is very slow. It takes more time when a server has lot of tables/information in it.

ii) This is not secured , it doesn't include any key-exchange algorithms which tells , the tool is not secured when it comes to real time application.

Solution :

Use SSL/SSH methods for authentication.