Open DB & create new table.

Kapalı İlan edilme: Mar 8, 2006 Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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

iii) MySQL

iv) Oracle

v) VistaDB

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

Python

Proje NO: #48305

Proje hakkında

1 teklif Uzak proje Aktif Nov 26, 2006