Database Design

已取消 已发布的 Jan 16, 2009 货到付款
已取消 货到付款

The task is to define, using Oracle 10g, a nested relational structure for an ordering system, using PL/SQL to drive the input of data and searching.

?

The requirements, for the ordering system, are that the following information should be held:

?

* Data on each order, including order number, name and address of customer and date the order was placed

* Data on each item within the order including catalogue code, number ordered and cost charged

?

You should then write two PL/SQL procedures:

1)? ? ? ? ? The first to allow the user to input information for an order and two order items as parameters (You can make it general but full marks will be obtained for the precise number of two).

2) The second to allow the user to input information for a catalogue code as parameter and provide output for such code of the order number, the number ordered and cost charged for each order in which it occurs (this will need a cursor to handle the multiple orders retrieved).?

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Other:Oracle 10g

工程 MySQL Oracle PHP 软件构架 软件测试

项目ID: #3550364

关于项目

2个方案 远程项目 活跃的Jan 16, 2009

有2名威客正在参与此工作的竞标,均价$34/小时

hyddeveloper

See private message.

$25.5USD 在1天里
(0条评论)
0.0
zulqurnan

See private message.

$42.5USD 在1天里
(0条评论)
0.0