Project #16136 - PL/SQL

Send me a message if you are able to help, so I can give you details of what my proposal-store is all about.

 

YOU ARE NOT CREATING A GUI. Just PL/SQL statements

Create PL/SQL procedure that:

       GUI 2: Register a customer in your store. The following information will be necessary:

?       Name

?       Address

?       Email address

?       Password

?       Secret Question

?       Financial information: This includes a Checking Account (Routing number; Checking account number) and/or a Credit Card (Credit card number, Expiration date)

?       Stored Proc: add new user

        

       GUI 5: Add Product to database

?       Provide details such as:

?       Add Name (Brand new TV, etc.)

?       Short Descriptions with model, year, etc.

?       New

?       Used [if you are selling non-tangible goods improvise appropriately] 

?       Conditions (for used): Looks like new, Fairly Used, Major Scratches, Needs Repair, etc.

?       Comments box (extra info about the product)

?       Price

?       Shipment Price (set price. Does not exist for non-tangible goods)  

?       Add Picture (optional)

 

?       Stored Proc: Add new product

 

o    Procedure ADD_NEW_USER (parameters...). This procedure takes as input parameters the information listed in GUI 2 and generates INSERT statement(s) to populate the appropriate table(s) in your database. GUI 2 specifies a "customer". Some projects may have customers, some may not. Make sure you use "customer" according to your project needs, for example, a customer may be a student, or a patient, a doctor, waiter, etc. When you write this procedure, put yourself in the context of your project.

o    Procedure ADD_NEW_PRODUCT (parameters...). It takes as input information listed in GUI 5 and generates appropriate INSERT statement(s) to populate table(s) in the database. Similar to the previous procedure a "product" needs to be something that makes sense in the context of your project. It may be a product, a service, etc.

 

·          

Subject Computer
Due By (Pacific Time) 11/07/2013 05:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy