Introduction As a database administrator, one of the crucial tasks…