Write a program in Python or Ruby to
A/ Prompt for a database name or navigate to it using cmdialog. It may be any of the following types:
i) MS Access
ii) MS SQL
Open the prompted database.
B/ Display the names of all the 'user' tables in the database opened in A/. In other words ignore system tables.
C/ Prompt for a new table name, field names and field types (and field lengths where applicable).
Recursively prompt for these field details, stopping when the next field name entered is empty.
Note that field types must be selected from a drop down list of field types applicable to the database type opened in A/. Therefore knowledge of the available field types in the specified databases will be necessary.
D/ Create the table described in C/ in the database opened in A/.
E/ Close the database. EOJ