The program I am working on is python and I am getting a lot of error but below are the requirement for it. if you can add comments please so I may better understand. use the function len and sets.

I am constructing a program that

1. asks the user for a database schema name and report the number of tables, a list of table and the number of each record in each table.

Design suggestions:

2. Use two result sets One to hold the results of a "SHOW TABLES" command and one to hold a query of each table to determine the record count.

3.Use a for loop to step through the first result set to display the first element of the tuple (the table name) and then query the table to find the number of records.

Use the len() function on the result set to find the number of tuples.