as a database administrator, it's essential to have a clear understanding of the information_schema, a…