1. Create the tables and triggers specified in section IV, V and VI of this document in Oracle. Note that cid in Customer and ordernum in Orders are artificial keys, generated by the system automatically. Make sure to create all tables as stated above, including integrity constraints!. 2. Add 10~20 tuples for each of the tables and then run the queries in section V. 3. Test to see if your database is working by placing some orders and display the updated tables. You need to turn in a printout with your SQL Create Table statements, tuples inserted into the tables, query results, and the Java code.
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).