Database Design

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