Suljettu

Open-amp-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

NOTE: The successful bidder to supply source code.

Taidot: Python

Näytä lisää: amp create, python access create table, python cmdialog, sql code oracle, recursively, oracle e source, open-table, open source sql, d&b supply, python open create tables, create table name project, successful names, 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

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

Projektin tunnus: #48320