Open DB & create new table.

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

Taidot: Python

Näytä lisää: recursively, open-table, open access tables python, d python, therefore, table, open c, new, mysql python oracle, create new c, create name, create e, b v, access v, display database table python, vistadb, drop list database, name empty, specified, mysql amp

Tietoa työnantajasta:
( 2 arvostelua ) Broadhurst, South Africa

Projektin tunnus: #48305