Đã Đóng


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.

Kỹ năng: Python

Xem thêm: amp create, python access create table, python cmdialog, sql code oracle, recursively, oracle source, open source sql, python open create tables, create table name project, successful names, d python, table, open c, new, mysql python oracle, create new, create e, b v, access v, display database table python, vistadb, code create, drop list database, name empty, specified

Về Bên Thuê:
( 2 nhận xét ) Broadhurst, South Africa

Mã Dự Án: #48320