Question: Write a python program that will prompt the user for a database schema name and report the number of tables, a list of table and

Write a python program that will prompt 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: 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. 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. please add comments to explain. will connect to db just need help with constructing this.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

The program I am working on needs to run on python and 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...

python Primer on CSV File Format (If you understand CSV files already, you don't have to read this part) We've learned that text files are simply long strings (sequences of characters) that have been...

Needing help writing this program for an assignment. having trouble making the list. Note: must be written without using format. Introduction The purpose of this assignment is to familiarize you with...

This is python. i don't know how to make a code about this. please let me know. Activity #2: Calculating and writing to a file - to be done individually Note: In Lab Assignment #8a, we practiced...

using python 3: i always rate my answer. the program need a main function. i have a program here with an answer but the output only give me the word and the frequency of the first line. i have an...

USING PYTHON 3: I always rate my answer. the program need a main function Program 4: Word Frequencies (20 pts) 1. Use a text editor to create a text file (ex: myPaper.txt) It should contain at least...

Must Enroll In ... Week 0 Week 1-2 Week 3-8 Week 9-16 Required Down Payment O Down Payment 25% Of The Initial Balance 50% Of The Initial Balance Student Is Ineligible Number Of Monthly Payments 4 3 2...

1 Introduction In this assignment, you're going to write a program that can hash a database of license plates and names. After reading in a file containing plateame pairs, your program will let the...

1 Introduction In this assignment, you're going to write a program that can hash a database of license plates and names. After reading in a file containing plate name pairs, your program will let the...

Give the product formed when each of the following compounds undergoes an electrocyclic reaction a. Under thermal conditions b. Under photochemical conditions 1. 2. CH3 CH ,.

Condensed monthly income data for Thurber Book Stores are presented in the following table for November 20x 1. (Ignore income taxes.) Additional Information: Management estimates that closing the...

To what extent do many GPE theorists incorporate the key insights of neo-classical economics without acknowledging explicitly that this is what they are doing?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1. Discuss the five types of learner outcomes.

4. Describe how learners receive, process, store, retrieve, and act upon information.

7. Explain the four components of program design: design document template, course or lesson plan, and course or lesson plan overview.